Problem updating infoobject master data from a dso.

[#1]

Hi all,

i'm updating the master data of an infoobject from another ods, the two table have the same key.

When i update the infoobject with full repair i get errors about duplicate records and the data load stops, when i delete the request and launch the infopackage again all goes well but it seems it doesn't insert any new record in the master data, what could be the problem?

If you need more info ask me.

Thanks a lot.

Stefano

[Former Member]

Hi Sadeesh,

it shoudn't be automatic to get the data from tha active table when doing a full update?

Also i'm using update rule, not transformation because it's a 3.5 system.

What i do not explain is way after launching again the infopackage the data is ok...

Thanks

Stefano

[Former Member]

Hi

Yep you are correct. It will automatically select the active table for full repair request. After running the infopackage for second time, please run the attribute change run and then check whether master data records have been added or not.

Regards

Sadeesh

[Former Member]

Hi Sadeesh,

i checked the master data table and it seems it has been updated, i check some order number with recordmode N added today in the dso and the entries were in the infoobject, though i don't know why in the request tab it shows 0 added records.

To be completely sure tomorrow i will check again the number of entries in the 'p' table of the infoobject.

Anyway this is the exact error message i get:

7 duplicate record found. 6478 recordings usedin table /BIC/XZDOCDSO

7 duplicate record found. 6478 recordings usedin table /BIC/PZDOCDSO

After that i run the change run for the IO and when i launch again tha data load it goes well.

Regards

Stefano

[Former Member]

HI

Plz check the transformation whether you have any routines to delete the data before loading to the master data object.

Regards

Sadeesh

[Former Member]

Yes, i have a delete from data_package if a date field is greater than sy-datum.

I could alse remove it, i put it in the first place to avoid loading data i didn't need but it's not really necessary.

Regards

Stefano