SAP Knowledge Base Article - Preview

2695053 - SAPHostAgent / saphostctrl -Failed to retrieve interface from sql.ini - SAP ASE for BS

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

SAP NetWeaver 7.5

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.