SAP Knowledge Base Article - Preview

2639066 - SQL1768N Unable to start HADR, Reason Code 7

Symptom

  •  HADR Primary is failed to establish connection with standby and throw below error in db2diag.log

    2018-04-06-13.52.06.290846+120 I81285178A561 LEVEL: Error
    PID : ********* TID : ********** PROC : db2sysc 0
    INSTANCE: db2***  NODE : 000 DB : ***
    APPHDL : 0-27413 APPID: *LOCAL *********************
    AUTHID : DB2*** HOSTNAME: *****************
    EDUID : ******* EDUNAME: db2agent (***) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21250
    MESSAGE : SQL1768N Unable to start HADR. Reason code = "7".

  • 2018-04-06-13.52.06.316564+120 E81285740A2480 LEVEL: Event
    PID : ********* TID : ********** PROC : db2sysc 0
    INSTANCE: db2***  NODE : 000 DB : ***
    APPHDL : 0-27413 APPID: *LOCAL *********************
    AUTHID : DB2*** HOSTNAME: *****************
    EDUID : ******* EDUNAME: db2agent (***) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetDbRoleAndDbType, probe:10020
    CHANGE : HADR DATABASE ROLE/TYPE -
    HADR database role set to STANDARD (was PRIMARY).
    HADR database type set to NONE (was PHYSICAL).
    CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
    [0] 0x0900000038F76EBC hdrSetDbRoleAndDbType__FP9SQLP_DBCBCUiT2 + 0x1530
    [1] 0x090000003A396C94 hdrUndoDbRoleIfNecessary__FP14sqlpMasterDbcbCUiT2 + 0x254
    [2] 0x090000003A8B1DD8 hdrEduStartup__FP16sqeLocalDatabaseP9sqeBsuEduP14sqlpMasterDbcbCbCUiT4C19hdrEduStartupActionP5sqlcaT4 + 0x3D0
    [3] 0x090000003ADE59B8 sqlpCheckToStartHadr__FP8sqeAgentP16sqeLocalDatabaseP5sqlcabUiPbT4 + 0x36C
    [4] 0x090000003ADEED9C sqlpCheckToStartHadr__FP8sqeAgentP16sqeLocalDatabaseP5sqlcabUiPbT4 + 0x4C8
    [5] 0x090000003A938954 AppStartUsing__14sqeApplicationFP8SQLE_BWAP8sqeAgentcT3P5sqlcaPc + 0x1388
    [6] 0x090000003CCB8E14 AppLocalStart__14sqeApplicationFP14db2UCinterface + 0x53C
    [7] 0x090000003CCB8854 sqlelostWrp__FP14db2UCinterface + 0x44
    [8] 0x090000003B1CBC80 sqleUCengnInit__FP14db2UCinterfaceUs + 0x268
    [9] 0x090000003CCCA888 sqleUCagentConnect + 0x420
    [10] 0x090000003CCC79F4 sqljsConnectAttach__FP13sqljsDrdaAsCbP14db2UCinterface + 0x750
    [11] 0x090000003CCC648C sqljs_ddm_accsec__FP14db2UCinterfaceP13sqljDDMObject + 0x32C
    [12] 0x090000003CCC5F34 sqljsParseConnect__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x4C
    [13] 0x090000003B1E3354 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1130
    [14] 0x090000003B1E2F48 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xD24
    [15] 0x090000003A9D7988 @72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
    [16] 0x090000003A9D849C @72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5FC
    [17] 0x090000003C836A88 RunEDU__8sqeAgentFv + 0x40618
    [18] 0x090000003C869974 RunEDU__8sqeAgentFv + 0x11C
    [19] 0x090000003BE56364 EDUDriver__9sqzEDUObjFv + 0x130
    [20] 0x090000003C402498 sqloEDUEntry + 0x394
    [21] 0x090000000054CE10 _pthread_body + 0xF0
    [22] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF


Read more...

Environment

  • Db2 LUW 9.7 and above
  • SAP NETWEAVER 7.5 / 701
  • SAP SOLUTION MANAGER 7.1
  • SAP ERP 6.0

Product

SAP ERP 6.0 ; SAP NetWeaver 7.5 ; SAP Solution Manager 7.1

Keywords

HADR, HADR_TIMEOUT, hadr_peer_window, Connection , KBA , BC-DB-DB6-DBA , Database Administration , 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.