Back in 2007 I faced an issue with inconsistent ODS object. We were not able to activate some queue requests, And considering data reloading was a herculean task.
The error message was similar to one below;
“DSO XXX inconsistent; request REQU_XXX only exists in RSODSACTREQ”
“ODS Activation failed with status :5”
We faced a similar scenario today, that’s why I thought about noting this down. You will get ample material in internet explaining about this.
One solution is to delete the request from request queue (manage screen) and also from the table RSODSACTREQ (Activation table of M-requests to change-log requests) and try to activate the data in ODS.
Or
Use Transaction RSRV (Analysis and repair for BI objects) -> All Elementary Tests-> ODS Objects -> Check the Status of the Generated Program of a Data Store Object -> give ODS name->Execute.
If it fails, then click Correct Error Tab & execute again. Check once more and activate ODS object
