IBM Support

Error accessing database - DSRA0010E: SQL State = , Error Code = -1,768

Troubleshooting


Problem

ExceptionMapp E AWSJDB801E An internal error has been found while accessing the database. SQL1768N Unable to start HADR. Reason code = "7".

Symptom

This is the specific error in SystemOut.log for the -1,768 code mentioned in the title:

PrivExAction W J2CA0144W: No mappingConfigAlias found for connection factory or datasource jdbc/twsdb.

ConnectionPoo E 7DSRA0010E: SQL State = , Error Code = -1,768

ExceptionMapp E AWSJDB801E An internal error has been found while accessing the database. The internal error message is: "7DSRA0010E: SQL State = , Error Code = -1,768"

Log in as the DB2 administrator and attempt to connect to the TWS database.

db2 connect to TWS

SQL1768N Unable to start HADR. Reason code = "7"

[{"Product":{"code":"SSGSPN","label":"IBM Workload Scheduler"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"DB2","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.4;8.5;8.5.1;8.6;9.1;9.2","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
17 June 2018

UID

swg21462386