Problem with Master Data Load

[Former Member]

Dear Experts,

If somebody can help me by the following case, please give me some solution. Iu2019m working in a project BI 7.0 were needed to delete master data for an InfoObject material. The way that I took for this was through tcode u201CS14u201D. After that, I have tried to load again the master data, but the process was broken and the load done to half data.

This it is the error:

Second attempt to write record 'YY99993' to /BIC/PYYYY00006 failed

Message no. RSDMD218

Diagnosis

During the master data update, the master data tables are read to determine which records of the data package that was passed have to be inserted, updated, or modified. Some records are inserted in the master data table by a concurrently running request between reading the tables at the start of package processing and the actual record insertion at the end of package processing.

The master data update tries to overwrite the records inserted by the concurrently running process, but the database record modification returns an unexpected error.

Procedure

u2022 Check if the values of the master data record with the key specified in this message are updated correctly.

u2022 Run the RSRV master data test "Time Overlaps of Load Requests" and enter the current request to analyze which requests are running concurrently and may have affected the master data update process.

u2022 Re-schedule the master data load process to avoid such situations in future.

u2022 Read SAP note 668466 to get more information about master data update scheduling.

Other hand, the SID table in the master data product is empty.

Thanks for you well!

Luis

[Former Member]

Sent a OSS note

[shawn_ling]

would you please let me know the number of the oss note?

[Former Member]

Dear Daya,

Thank for your help, but I was applied your suggesting. I sent to OSS with the following details:

We are on BI 7.0 (system ID DXX)

While loading Master Data for infoobject XXXX00001 (main characteristic in our system u2013 like material) we are facing the following error:

Yellow warning u201CSecond attempt to write record u20182.347.263u2019 to BIC/ XXXX00001 was successfulu201D

We are loading the Master data from data source ZD_BW_XXXXXXX (from APO system) through the DTP ZD_BW_XXXXX / XXX130 -> XXXX00001

The Master Data tables (S, P, X) are not updated properly.

The following reparing actions have been taken so far:

1. Delete all related transactional and master data, by checking all relation (tcode SLG1 à RSDMD, MD_DEL)

2. Follow instructions from OSS 632931 (tcode RSRV)

3. Run report RSDMD_CHECKPRG_ALL from tcode SE38 (using both check and repair options).

After deleting all data, the previous tests were ok, but once we load new master data, the same problem appears again, and the report RSDMD_CHECKPRG_ALL gives the following error.

u201CCharacteristic XXXX00001: error fund during this test.u201D

The RSRV check for u201CCompare sizes of P and X and/or Q and Y tables for characteristic XXXX00001u201D is shown below:

Characteristic XXXX00001: Table /BIC/ PXXXX00001, /BIC/ XXXXX00001 are not consistent 351.196 derivation.

It seems that our problem is described in OSS 1143433 (SP13), even if we already are in SP16.

Could somebody please help us, and let us know how to solve the problem?

Thank for all,

Luis

[former_member207028]

Hi,

test the master data infoobject, with T-code RSRV and select test option "Time Overlaps of Load Requests" and give infoobject and click on execute.

check the data for the forst load and load for secon set of data.

Regards

Daya Sagar