ODBQueryApp fails with error checking availability of database operation function DSODB.RunMajorStatus after applying 8.7 FP2, 8.7 FP1 or Operations Console Rollup patch on IIS 8.7 server

Technote (troubleshooting)


Problem(Abstract)

ODBQueryApp is a server process of the IBM InfoSphere DataStage and QualityStage Operations Console which provides information from the operations database to the Operations Console. There are cases where ODBQueryApp fails to run, following the application of 8.7 FP2 (fixpack_FP2_IS87_[platform]_8700-1, 8.7 FP1 (fixpack_FP1_IS87_[platform]_8700) or 8.7 Operations Console Rollup patch (rollup_RU1_OpsConsole_[platform]_8700).

Cause

After the 8.7 FP2, 8.7 FP1 or 8.7 Operations Console rollup patch installation, a manual step is required to update the operations database schema content. This update adds some new database functions that are required by the patch. If the step is not performed, ODBQueryApp will fail with the error as it cannot find the required functions in the database.

Environment

8.7.0.0, 8.7.0.1 or 8.7.0.2 engine tier system running Operations Console.

Diagnosing the problem

The ODBQueryApp process shows as "STOPPED" or as "Not Running" when using the ./DSAppWatcher.sh -status command.

The following errors can be found in the relevant ODBQueryApp log file (InformationServerRoot/Server/DSODB/logs/odbqapp-***.log)

1. When operations database schema is in DB2 database

ERROR com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:261) - Error checking
availability 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)
... 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.

2. When operations database schema is in Oracle database

ERROR com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:261) - Error checking availability of database operation functions.
java.sql.SQLException: [IBM][Oracle JDBC Driver][Oracle]ORA-06564: object DSODB.RunMajorStatus does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 156
ORA-06512: at line 1
at com.ibm.isf.jdbc.oraclebase.dda4.b(Unknown Source)
...
at com.ibm.isf.jdbc.oraclebase.ddb_.execute(Unknown Source)
at com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:256)
... 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.

3. When operations database schema is in SQL Server database

ERROR com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:261) - Error checking availability of database operation functions.
java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Could not find stored procedure 'DSODB.RunMajorStatus'.
at com.ibm.isf.jdbc.sqlserverbase.dda4.b(Unknown Source)
...
at com.ibm.isf.jdbc.sqlserverbase.ddb9.execute(Unknown Source)
at com.ibm.datastage.runtime.odbqapp.server.ODBQueryAppSocketServer.main(ODBQueryAppSocketServer.java:256)
...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.


Resolving the problem

Perform the manual step required after the patch installation.

For 8.7 FP2 (fixpack_FP2_IS87_[platform]_8700-1)* and 8.7 FP1 (fixpack_FP1_IS87_[platform]_8700), please follow the instructions for JR41540 in
http://www-01.ibm.com/support/docview.wss?uid=swg27024855

For the 8.7 Operations Console rollup patch (rollup_RU1_OpsConsole_[platform]_8700), please follow the instructions in README.txt included in the patch.

After running this manual upgrade to the database, the AppWatcher process will need to be restarted.
On Unix, this can be done by running the following command as the datastage administration user (e.g. dsadm)
.../IBM/InformationServer/Server/DSODB/bin/DSAppWatcher.sh -stop
.../IBM/InformationServer/Server/DSODB/bin/DSAppWatcher.sh -start

On window, this can be done from the Control Panel services menu or from a command
net stop "DataStage AppWatcher Service"
net start "DataStage AppWatcher Service"

* The manual step is only required for 8.7 FP2 if neither 8.7 FP1 nor 8.7 Ops Console rollup patch has been applied before.

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere DataStage

Software version:

8.7, 8.7.0.1, 8.7.0.2

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1617361

Modified date:

2014-05-12

Translate my page

Machine Translation

Content navigation