SAP Knowledge Base Article - Preview

2996592 - DBACockpit returning "Unable to call procedure 'saptools..SP_DBH_HADR_PATHS'" - SAP ASE for BS

Symptom

  • The following error is reported from DBACockpit when trying to access to database:

Exception CX_DBA_RDI in class CL_DBA_RDI_QUERY method IF_DBA_RDI_QUERY~COLLECT line 206
...
...

Message:                       Unable to call procedure 'saptools..SP_DBH_HADR_PATHS'!
...
...

DB Error: Yes 
SQL Code: 535  
SQL Message: [ASE Error SQL535][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Difference of two datetime fields caused overflow at runtime.

  • Executing the offending stored procedure from isql returns the same error:

isql -S<SID> -Usapsa -X

1> saptools..SP_DBH_HADR_PATHS
2> go
Msg 535, Level 16, State 1:
Server 'FP0', Line 1:
Difference of two datetime fields caused overflow at runtime.
(return status = 0)

  • DBACockpit Correction Collection is implemented on last version (see "See Also" section below)
  • From menu Configuration > DBA Cockpit Framework > Data Collectors and Admin Procedures > Clicking on collector "HA/DR Paths" you can see that the Setup Status says "Collector belongs to Database Delivery (BALDR)". That means BALDR is installed (see SAP Note 2502193 - "SYB: BALDR - New Monitoring Persistency Layer for SAP ASE"). 
  • BALDR configuration can belong to a Solution Manager system


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite SP03 or higher
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

HADR, HA/DR, SP_DBH_HADR_PATHS, SQL535, Msg 535, overflow, runtime, datetime, IF_DBA_RDI_QUERY~COLLECT , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.