IBM Support

Control Center shuts down from a database error after globalization

Troubleshooting


Problem

ERROR SQLExceptionShutdownHandler - ** About to broadcast CJDB026E, which will cause engine to shut down
Control Center is running with a MSSQL 2014 database server with globalization turned on

Symptom

<----------------- executeBatchUpdate - Exception Info - Begin -------->executeBatchUpdate - SQL cmd :null
executeBatchUpdate - SQL Exception msg : Operation failed. The index entry of length 938 bytes for the index 'EVENT_FILE_SEARCH' exceeds the maximum length of 900 bytes.
executeBatchUpdate - SQL State : S0003
executeBatchUpdate - SQL Error Code : 1946
<-----------------executeBatchUpdate - Exception Info - End --------->
ERROR SQLExceptionShutdownHandler - ** Event not updated or details on what was being done when error occurred -> Operation failed. The index entry of length 938 bytes for the index 'EVENT_FILE_SEARCH' exceeds the maximum length of 900 bytes.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9GLA","label":"IBM Control Center"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","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 December 2019

UID

ibm10870144