Unsolved

This post is more than 5 years old

37 Posts

3360

February 20th, 2018 20:00

SAP IQ backup fails in Networker 9.2

Hi All,

This is first time we configure SAP IQ backup in Networker 9.2. All prerequisites are met.

I created nmda cfg file on client side. When I run backup, I am getting below error.

24148:nsrdasv: CT-LIBRARY error:

        ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

170480:nsrdasv: Unable to log in to the database 'SAPIQDB_dev'.

170548:nsrdasv: The child nsrdasv program exited with a non-zero return code: 65280

Error says unable to login database. When I test the credentials using isql command it works.

user@hostname:/usr/sap/Q1D/OCS-16_0/bin> ./isql -Udba -P sql -D SAPIQDB_dev_dev -S NLS_Dev

Msg 504, Level 11, State 0:

SQL Anywhere Error -265: Procedure 'use' not found

1> select @@version

2> go

@@version                                                                                                                                                                                                                                                                                                                                                                                 

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SAP IQ/16.0.110.2528/10554/P/sp11.11/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2017-08-16 03:56:06                                                                                                                                                                                                                                                                               


(1 row affected)

Please help to fix this.

37 Posts

March 7th, 2018 10:00

After configuring correct port number in interfaces file, backup succeeded.

4 Operator

 • 

14.4K Posts

February 26th, 2018 14:00

Can you post your configuration files?

37 Posts

March 5th, 2018 05:00

Hi Hrvoje,

Config file is below.

hostname:/nsr # cat nmda_iq_backup.cfg

IQ_USER = dba

SYBASE = /usr/sap/DB

IQ_OCS_PATH = /usr/sap/DB/OCS-16_0

NSR_CLIENT = hostname

NSR_DATA_VOLUME_POOL = POOL

NSR_SERVER = xxxxxx

NSR_SAVESET_NAME = IQ:/SAPDB

USER_PSWD="     $1$QCWEURHUXEQGASWU$64d984dce4fe528b6dfwf393e6615a79be"

1 Message

March 25th, 2021 02:00

Can you tell me how can we know what port is used by DB currently. As per interface file we use port 30000 but not sure about the port number of DB.

0 events found

No Events found!

Top