Troubleshooting
Problem
Information Server EngMonApp fails with the following error: [] ERROR com.ibm.datastage.runtime.common.db.DBManager.selectAll(DBManager.java:600) - Error executing Query statement: SELECT CONFIGID,NodeList FROM DSODB.ParallelConfig WHERE HOSTID = ? AND NodeListHash = ?. Values: [-679343652176979937, -581649198] java.sql.SQLException: [IBM][Oracle JDBC Driver]This column type is not currently supported by this driver. [] This occurs if the operations database is configured to use an Oracle database version 11.2.0.2 or later.
Cause
Oracle 11.2.0.2 changed the default XMLTYPE storage type from CLOB to binary. The branded Progress DataDirect JDBC driver does not support XMLTYPE binary storage.
DataDirect Can't Query Oracle XML Data Types on Oracle 11.2
Diagnosing The Problem
The EngMonApp process shows as "Not Running" in the Operations Console, or as "STOPPED" if using the DSAppWatcher.sh -status command. In the relevant EngMonApp log file (InformationServerRoot/Server/DSODB/logs/EngMonApp-***.log), the following error is reported:
ERROR com.ibm.datastage.runtime.common.db.DBManager.selectAll(DBManager.java:600) - Error executing Query statement: SELECT CONFIGID,NodeList FROM DSODB.ParallelConfig WHERE HOSTID = ? AND NodeListHash = ?. Values: [-679343652176979937, -581649198]
java.sql.SQLException: [IBM][Oracle JDBC Driver]This column type is not currently supported by this driver.
Resolving The Problem
Install patch JR43526 to resolve the above error in the EngMonApp when accessing Oracle 11.2.0.2 or later.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21616215