Unsolved
This post is more than 5 years old
37 Posts
0
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.
0 events found


Raja_Bala
37 Posts
0
March 7th, 2018 10:00
After configuring correct port number in interfaces file, backup succeeded.
ble1
4 Operator
•
14.4K Posts
0
February 26th, 2018 14:00
Can you post your configuration files?
Raja_Bala
37 Posts
0
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"
Prince2389
1 Message
0
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.