Troubleshooting
Problem
Control Center shuts down right after starting issuing message
About to broadcast CJDB026E, which will cause engine to shut down
Symptom
Engine port is not listening. Can not connect the GUI Console.
Cause
CCP-15919 Getting NPE after executing runEngine if using mssql-jdbc-7.0.0.jre8.jar for MSSQL
Exception occurred when invoking Clob.length() function, which I used to convert the CLOB value to a String
Exception occurred when invoking Clob.length() function, which I used to convert the CLOB value to a String
Environment
Microsoft SQL Server 2016 and Microsoft JDBC Driver 7.0
Diagnosing The Problem
Look at the Engine log.
Engine log shows the following errors
ERROR SQLExceptionShutdownHandler - ** SQLExceptionShutdownHandler entered with sqlex=java.lang.NullPointerException
ERROR SQLExceptionShutdownHandler - ** Event not updated or details on what was being done when error occurred -> null
ERROR SQLExceptionShutdownHandler -
Stack Trace:
java.lang.NullPointerException
at com.microsoft.sqlserver.jdbc.SQLServerClobBase.length(SQLServerClob.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerClob.length(SQLServerClob.java:97)
Stack Trace:
java.lang.NullPointerException
at com.microsoft.sqlserver.jdbc.SQLServerClobBase.length(SQLServerClob.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerClob.length(SQLServerClob.java:97)
Resolving The Problem
Switch the JDBC driver from 7.0 to one of the following using configCC
mssql-jdbc-7.4.1.jre8.jar
mssql-jdbc-7.2.2.jre8.jar
mssql-jdbc-6.4.0.jre8.jar
mssql-jdbc-6.2.2.jre8.jar
mssql-jdbc-7.2.2.jre8.jar
mssql-jdbc-6.4.0.jre8.jar
mssql-jdbc-6.2.2.jre8.jar
after switching to the correct driver, ensure the old driver is no longer accessible by ICC.
Ensure that only the correct MSSQL JDBC driver is in lib\thirdparty before restarting ICC.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9GLA","label":"IBM Control Center"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.1.2.0;6.1.2.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
18 February 2020
UID
ibm12872299