* some of the bots didnt run.
it looks like there is an inconsistency between the agents and the metadata in the DB RCU tables. Quickest way to resolve this would be to delete the jobs and recreate them. Alternatively, you could look at job ids and ensure via the job manager and update the RCU tables but this isn't a straightforward task as there are several tables that would need to be aligned.
I have seen this link.
I have only one job id in the table.
where should i check if its consistent or not?
I have faced this issue before. In my case there were two jobs with same id. If you check in your S_NQ_JOB you should be able to figure out something wrong there.
If you go through all the above you find how to get rid of message.
The question is: is that message really related to your issue?
Farrukh Nasir wrote:
Yesterday what happens that some of the users didnt get the email.
Does this mean that for one given agent only some of the recipients got the email? Because that would be totally unrelated to the error message you posted. If it's the case you maybe want to either use the Job Manager tool to check the logs of the agent or look into the table S_NQ_ERR_MSG directly (that's where the Job Manager is going).
And there you will find the real reason of why some users got their email and others not.
For your inconsistent ID message you maybe want to find out the root cause of it: OBIEE generally manage to keep the ID in sync in a weak but working way. Even with a duplicate ID into the XML of the agent etc. when you save it, it will replace the ID and update the scheduler tables as required. So you maybe want to make sure you don't have a cowboy-style process moving agents around environments or things like that.