OBIEE - The server responded with: Inconsistent job ids

Obi Edition

About

This is a troubleshooting article over the error: “The server responded with: Inconsistent job ids”

Steps

The error

[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Inconsistent job ids.  Scheduler job id 30 points to ibot 
/shared/path/To/Ibot" with job id 375.  A catalog update has been 
made without updating the scheduler tables.  The Administrator should consider deleting the old scheduler job.
Error Codes: C8TDLG6P
Location: saw.delivers.rpc.getMetadata, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
.
Error Codes: AGEGTYVF
    AgentID: /shared/path/To/Ibot
    ...Trying main Agent loop again.... Sleeping for 7 seconds.[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Inconsistent job ids.  Scheduler job id 30 points to ibot 
/shared/path/To/Ibot" with job id 375.  A catalog update has been 
made without updating the scheduler tables.  The Administrator should consider deleting the old scheduler job.
Error Codes: C8TDLG6P
Location: saw.delivers.rpc.getMetadata, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
.
Error Codes: AGEGTYVF
    AgentID: /shared/path/To/Ibot
    ...Trying main Agent loop again.... Sleeping for 5 seconds.[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Inconsistent job ids.  Scheduler job id 30 points to ibot 
/shared/path/To/Ibot" with job id 375.  A catalog update has been 
made without updating the scheduler tables.  The Administrator should consider deleting the old scheduler job.
Error Codes: C8TDLG6P
Location: saw.delivers.rpc.getMetadata, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
.
Error Codes: AGEGTYVF
    AgentID: /shared/path/To/Ibot
    Exceeded number of request retries for method RuniBot.

The Why

The Job Id are not consistent between:

  • The Ibot in OBIEE
  • And the Scheduler table in the database

The Ibot has the following JobID. Just open the XML file in the catalog. (375)

Jobid Ibot Obiee

But in the biplatform database, the job 30 points to it. The job Ids are then not consistent.

Jobid Ibot Nq Job Param Obiee

Solution

  • Verify that the job 375 exists in the database and points to the good Ibot file.
  • Suppress the bad job Id with the job manager (in our case the job 30)

Jobid Jo Manager Remove







Share this page:
Follow us:
Task Runner