delta updates whith mistake

[Former Member]

Hello everybody!

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

[former_member345199 · Accepted solution]

Hi,

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.

thanks,

JituK

[Former Member · Accepted solution]

very thanks to all

jose

[Former Member]

Goto RSMO,choose PSA option & modify the incorrect data.Do a manual update from PSA...

OR

Identify error records in PSA & request user to change the data in source & then have it pulled into BW.

In order to avoid such errors,have validations setup in the source system via User Exits in the transaction in which the user enters data.

[former_member453731]

Hi,

To proceed with the load what you can do is, Delete the bad request from the data target and search for the particular request in PSA.From PSA select the particular record and edit it(Blank the 0SOLD_TO field).Once you have edited the record from PSA save it. After that right click on the request from PSA and select schedule the update. This will take you to the infopackage from where you can push the load from PSA to the datatarget(Infocube).This time it will work.

Inorder to avoid this type of error you have to edit the records from the R/3 table( you have to delete the value 5405 from MSEGK-WEMPF field).