Symptom
-
Execute saphostctrl -function ListDatabases and get error "No databases found".
-
Execute saphostctrl -function getdatabasestatus -dbname <XXX> -dbinstance <XXX> -dbtype syb and will see following error:
Error: Failed to retrieve interface for server <XXX> from \sybase\<XXX>\ini\sql.ini.
-
When you enable the Host Agent trace level 3, you will get more detailed information such as:
[PID 3932] ERROR AT sybServer.cpp:SybServer::getInterface:48575 TIME: 2018 Aug 14 15:19:19 DESCRIPTION: Failed to validate first entry 'master' for: master=TCP,<Hostname>,<port> LAST OS-ERROR: (0) : The operation completed successfully.
[PID 3932] ERROR AT sybServer.cpp:SybServer::getInterface:48575 TIME: 2018 Aug 14 15:19:19 DESCRIPTION: Failed to validate first entry 'master' for: query=TCP,<Hostname>,<port> LAST OS-ERROR: (0) : The operation completed successfully.
[PID 3932] SybServer::getInterface: Blank line and end of entry reached
[PID 3932] ERROR AT sybServer.cpp:SybServer::getInterface:48716 TIME: 2018 Aug 14 15:19:19 DESCRIPTION: Could not find machine entry for server <XXX> LAST OS-ERROR: (0) : The operation completed successfully.
[PID 3932] ERROR AT sybServer.cpp:SybServer::init:41966 TIME: 2018 Aug 14 15:19:19 DESCRIPTION: Failed to retrieve interface for server server <XXX> from \sybase\<XXX>\ini\sql.ini. LAST OS-ERROR: (0) : The operation completed successfully.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP NetWeaver (NW) 7.5
- SAP HOST AGENT 7.21
Product
Keywords
Failed to retrieve interface, sql.ini, TCP, NLWNSCK, Windows , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.