SAP Knowledge Base Article - Preview

2657980 - Fault Manager can not get 'db host status'- SAP SRS

Symptom

  • Fault manager is installed on third node for HADR on Windows platform.  

        C:\SAP\FaultManager>sybdbfm status
        fault manager running, pid = 1288, fault manager overall status = OK, currently
        executing in mode BOOTING
        *** sanity check report (5)***.
        node 1: server <hostname1>, site <site1_name>.
        db host status: UNKNOWN.
        db status OK hadr status PRIMARY.
        node 2: server <hostname2>, site <site2_name>.
        db host status: UNKNOWN.
        db status OK hadr status STANDBY.
        replication status: UNKNOWN.

  • Host Agent log shows the following error message after trace level 3 is turned on(add service/trace = 3 to the profile file which is %ProgramFiles%\SAP\hostctrl\exe\host_profile)

        [PID 1708] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]The optimizer could not find a unique index which it could use to perform an isolation level 0 scan on table 'tempdb..sapsybha'.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Host Agent 7.21 SP36 or below
  • Microsoft Windows 2012

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Fault Manager, db host status, UNKNOWN, isolation level 0 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.