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

Technote (troubleshooting)


Problem(Abstract)

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.

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere DataStage

Software version:

8.7

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1616215

Modified date:

2012-11-04

Translate my page

Machine Translation

Content navigation