Technical Blog Post
Abstract
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:
Check out all our other posts and updates: | |
Academy Blogs: | htt |
Academy Videos: | htt |
Academy Google+: | htt |
Academy Twitter : | htt |
UID
ibm11277224