'Job Server test failed' error when testing job server communication

Troubleshooting

Problem

'Job Server test failed' error when testing job server communication in the Contributor Administration Console.

Symptom

Job Server 'servername' test failed.
Error Details:

Communication to Job Server Enterprise Planning Service was Successful.

The Job Server's Enterprise Planning Service failed to load data from the data store publishdatastorename.Error Details:
Database Errors: Source: OraOLEDB Description: ORA-00942: table or view does not exist Number: -2147217865 SQLState: NativeError:942

The Job Server's Enterprise Planning Service failed to call COM+ job components for application publishdatastorename. COM+ Error Details:
Unable to execute the statement.

The SQL was:
SELECT jobtypeid, description, implprogid, notificationprogid FROM publishdatastorename.jobtype

ORA-00942: table or view does not exist

[{"Product":{"code":"SS9S5U","label":"Cognos 8 Planning"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSPN2D","label":"Cognos Planning"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1034686

Was this topic helpful?

Document Information

Modified date:
09 May 2025

UID

swg21347286

Tips