Question:
One of my infopackages has been failing last three weeks e.g. I have 44 red requests in last 3 months (this is scheduled process chain so I was not aware).
I have deleted data from cube/ods and deleted init then resubmitted the init and delta but I am getting a "last delta still running" and delta does not seem to extract all records expected.
Now I am thinking that a job is stuck somewhere and going into the past red requests to change the total status to red (if it is in delete status; back to request status). Looked in sm37 and did not see a job with that infopack name?
Is there a better way? e.g. How to automatically make all these requests red? or how to kill last delta that is still running?
Thanks for sharing,
Matt
Answer:
I have deleted data from cube/ods and deleted init then resubmitted the init and delta but I am getting a "last delta still running" and delta does not seem to extract all records expected.
Goto your InfoPackage you want to schedule (where you are getting this error).
Go to the Menu -> Scheduler -> Initialization options for Source system
Here select your request and click on the “delete Chosen Initial Selection” button.
Now Schedule your init InfoPackage.
_________________
Regards,
Parin