delta updates whith mistake
I have a problem whith delta updates in a meta-chain of.
The data source is 2LIS_03_BF
The data is updated to PSA but not to the infocube.
The mistake is: The info-object 0SOLD_TO contains the value 5405 do not agree with the rules of update.
The mistake is produced because the user of R/3 enters a value in a field that should be empty.
The field in R/3 is: MSEGK-WEMPF and in data source is 0SOLD_TO
What can I do to arrange the load?
What can I do in order that this does not happen again?
Thanks in advance! Jose
This issue can be resolved by correcting the error records in PSA and updating it into the target. for that the first step should be to identify if all the records are there in PSA. you can find out this from checking the job log in source system, details in RSMO etc. Once its confirmed force the request to red and delete the particular request from the target cube. then go to PSA and edit the incorrect records (in your case blanking out the particular field) and save it. Once all the incorrect records are edited go to RSA1>PSA find the particular request and update to target manually (right click on PSA request > Start update immediately).
This should solve your problem for now.
As a long term you can apply some user exit in source system side or change your update rules to ensure that this field is getting blanked out before getting loaded in cube.