IBM Support

Information Server EngMonApp fails with error: "[Oracle JDBC Driver]This column type is not currently supported by this driver"

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.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21616215