Inventory Delta load failure
Hello Gurus, I have a production problem with the Inventory delta load, please help!!!
we load our material movements into 2 cubes and 1 ODS in parallel into BW from R/3, last night there were some invalid characters so the delta load failed(05/04 @ 00:04:21), so I made the request as red in the monitor and deleted them from the 2 cubes and ODS then corrected the errored records in the PSA but instead of manually scheduling from the scheduler I did a repeat in the process chain on the failed step, this failed again loading to the data targets(05/04 @ 10:46:28).
Then I made the failed request red and backed it out from the data targets and now went back to the PSA and manually scheduled the original load into the data targets(05/04 @ 00:04:21) after which the step finished and the process chain completed alhtough the request was still red as I had made it red so I made the request green in the monitor.
after this I still had the repeat of the delta as red(05/04 @ 10:46:28) in the process chain and the PSA had 1 request which was red, now tonight we got another delta load failure(05/05 @ 00:04:46) with the same error message again so now there are 2 errored requests in PSA one from today and the other from last night's repeat.
so it looks like its pulling the same data from yesterday again,how do I fix this, here is an image of the PSA