SAP Knowledge Base Article - Preview

2657980 - Fault Manager cannot get 'db host status' - 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 for Me (Login required).

Search for additional results

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