Warehouse Proxy Agent is failing with SQLException ORA-00922

Body

I was working on case, where the IBM Tivoli Monitoring  Warehouse agent (WPA) fails to write data to an ORACLE 11G R2 database with: SQLException ORA-00922 error

The warehouse agent logs shows the following error:
...
..
2012/05/02,07:46:04.0000-5F:kdepnpc.c,138,"KDEP_NewPCB") 0.0.0.63: EF9007AF, KDEP_pcb_t @ CDB04AE8 created
(2012/05/02,07:46:04.0001-5F:kdebpli.c,211,"KDEBP_Listen") pipe 19 assigned: PLE=CD4030D8, count=7, hMon=7FF007D3
(2012/05/02,07:46:04.0002-37:khdxjdbc.cpp,2294,"SQL_Tables") Calling SQLTables using owner <ITMUSER> tablename <KIS_DNS>
(2012/05/02,07:46:04.0003-37:khdxbase.cpp,336,"setError")
+2012/05/02,07:46:04.0003  Error Type= CTX_JDBCError
+2012/05/02,07:46:04.0003  Severity= CTX_Critical
+2012/05/02,07:46:04.0003  Native Error Code = 922
+2012/05/02,07:46:04.0003  SQL State= 42000
+2012/05/02,07:46:04.0003  Reason Code= 0
+2012/05/02,07:46:04.0003  executing: processJavaException
(2012/05/02,07:46:04.0004-37:khdxbase.cpp,339,"setError")
+2012/05/02,07:46:04.0004 ERROR MESSAGE: "com.tivoli.twh.khd.KHDException: execDirect Error :
+2012/05/02,07:46:04.0004 at com.tivoli.twh.khd.khdxjdbc.execDirect(khdxjdbc.java:1146)
+2012/05/02,07:46:04.0004 Caused by: java.sql.SQLException: ORA-00922: missing or invalid option
+2012/05/02,07:46:04.0004
+2012/05/02,07:46:04.0004   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
 

We solved the problem by verifying the ORACLE DB Server if it is using the same JDBC driver as the warehouse proxy agent:
Check the KHD_WAREHOUSE_JARS variable in the hd.env file
e.g.
KHD_WAREHOUSE_JARS=/opt/IBM/ITM/ojdbc14.jar

After using the correct odbj*jar file, the WPA was working as expected.

#jens

Subscribe and follow us for all the latest information directly on your social feeds: