OBIEE - The server responded with: Inconsistent job ids

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics)

1 - About

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

2 - Steps

2.1 - 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.

2.2 - 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)

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

Advertising

2.3 - 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)