IBM Support

Sterling Control Center shutdown due to SQL exception error " A NON-ATOMIC INSERT STATEMENT SUCCESSFULLY COMPLETED FOR SOME OF THE REQUESTED ROWS..."

Troubleshooting


Problem

Sterling Control Center shutdown due to SQL exception error " A NON-ATOMIC INSERT STATEMENT SUCCESSFULLY COMPLETED FOR SOME OF THE REQUESTED ROWS..."

Symptom

Nested SQL exception[100]: Message: A NON-ATOMIC INSERT STATEMENT SUCCESSFULLY COMPLETED FOR SOME OF THE REQUESTED ROWS, POSSIBLY WITH WARNINGS, AND ONE OR MORE ERRORS SQLSTATE: 22529 Error code: -253 SQLSTATE=08003
Nested SQL exceptio......
Nested SQL exceptio......
......
ERROR SQLExceptionShutdownHandler - ** About to broadcast CJDB026E, which will cause engine to shut down ...
ERROR SCCEventHandler - CCTR089E Engine shutdown has been initiated ...
INFO SCCEngine - CCTR089E Engine shutdown has been initiated ...


[{"Product":{"code":"SS9GLA","label":"IBM Control Center"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.0;5.4.2.1;5.4.2;5.4.1;5.4.0.1;5.4;5.3","Edition":"All Editions","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 December 2019

UID

swg21882674

Page Feedback