Operation Console issue - ODBQueryApp failed to run.
Posted: Fri Jul 27, 2012 3:43 am
Hi, looking for a expertise help in Operation Console setup IIS8.7 in AIX platform. We have done the setup as per the procedure provided by Concierge program team, Created ops database using the scripts regenerated after applying ops console rollup patch.
Starting the services is returning as below.
./DSAppWatcher.sh -start
AppWatcher:STARTED
EngMonApp:STARTING
ODBQueryApp:STARTING
./DSAppWatcher.sh -status
AppWatcher:RUNNING
EngMonApp:RUNNING
ODBQueryApp:STOPPED
ResMonApp:RUNNING
The logs with respect to the above issue
2012-07-27 00:31:57,930 DEBUG com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:182) - main method is invok
ed.
2012-07-27 00:31:58,258 INFO com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:218) - ODBQueryApp server i
s listening on port :13451
2012-07-27 00:31:58,739 ERROR com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:261) - Error checking avail
ability of database operation functions.
com.ibm.db2.jcc.am.xo: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=RUNMAJORSTATUS;FUNCTION, DRIVER=3.58.135
at com.ibm.db2.jcc.am.ed.a(ed.java:676)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.zm.c(zm.java:2524)
at com.ibm.db2.jcc.am.zm.d(zm.java:2512)
at com.ibm.db2.jcc.am.zm.a(zm.java:1992)
at com.ibm.db2.jcc.t4.fb.g(fb.java:140)
at com.ibm.db2.jcc.t4.fb.a(fb.java:40)
at com.ibm.db2.jcc.t4.t.a(t.java:32)
at com.ibm.db2.jcc.t4.ub.i(ub.java:135)
at com.ibm.db2.jcc.am.zm.fb(zm.java:1963)
at com.ibm.db2.jcc.am.zm.a(zm.java:2983)
at com.ibm.db2.jcc.am.zm.a(zm.java:652)
at com.ibm.db2.jcc.am.zm.executeQuery(zm.java:636)
at com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:247)
2012-07-27 00:31:58,741 ERROR com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:262) - Unable to verify that the operations database functions have been installed into the database.
Please check that you have run all the required manual post installation scripts following any update such as a patch or feature pack installation.
Any help would be highly appreciated. Thanks in advance
Starting the services is returning as below.
./DSAppWatcher.sh -start
AppWatcher:STARTED
EngMonApp:STARTING
ODBQueryApp:STARTING
./DSAppWatcher.sh -status
AppWatcher:RUNNING
EngMonApp:RUNNING
ODBQueryApp:STOPPED
ResMonApp:RUNNING
The logs with respect to the above issue
2012-07-27 00:31:57,930 DEBUG com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:182) - main method is invok
ed.
2012-07-27 00:31:58,258 INFO com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:218) - ODBQueryApp server i
s listening on port :13451
2012-07-27 00:31:58,739 ERROR com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:261) - Error checking avail
ability of database operation functions.
com.ibm.db2.jcc.am.xo: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=RUNMAJORSTATUS;FUNCTION, DRIVER=3.58.135
at com.ibm.db2.jcc.am.ed.a(ed.java:676)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.zm.c(zm.java:2524)
at com.ibm.db2.jcc.am.zm.d(zm.java:2512)
at com.ibm.db2.jcc.am.zm.a(zm.java:1992)
at com.ibm.db2.jcc.t4.fb.g(fb.java:140)
at com.ibm.db2.jcc.t4.fb.a(fb.java:40)
at com.ibm.db2.jcc.t4.t.a(t.java:32)
at com.ibm.db2.jcc.t4.ub.i(ub.java:135)
at com.ibm.db2.jcc.am.zm.fb(zm.java:1963)
at com.ibm.db2.jcc.am.zm.a(zm.java:2983)
at com.ibm.db2.jcc.am.zm.a(zm.java:652)
at com.ibm.db2.jcc.am.zm.executeQuery(zm.java:636)
at com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:247)
2012-07-27 00:31:58,741 ERROR com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:262) - Unable to verify that the operations database functions have been installed into the database.
Please check that you have run all the required manual post installation scripts following any update such as a patch or feature pack installation.
Any help would be highly appreciated. Thanks in advance