Question Re: Problem updating infoobject master data from a dso. in Technology Q&A

Problem updating infoobject master data from a dso.

Former Member — Wed, 22 Apr 2009 08:01:31 GMT

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

Re: Problem updating infoobject master data from a dso.

Former Member — Wed, 22 Apr 2009 08:37:14 GMT

When you run the full repair request, Plz get the data from the active data table not from change log table.

The reason why you are getting the duplicate entries is that the change log table contains the same records with different 0recordmode status.

Hope it helps.

Regards

Sadeesh

Re: Problem updating infoobject master data from a dso.

Former Member — Wed, 22 Apr 2009 08:48:40 GMT

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

Re: Problem updating infoobject master data from a dso.

Former Member — Wed, 22 Apr 2009 08:55:43 GMT

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

Re: Problem updating infoobject master data from a dso.

Former Member — Wed, 22 Apr 2009 10:32:14 GMT

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

Re: Problem updating infoobject master data from a dso.

Former Member — Wed, 22 Apr 2009 10:56:55 GMT

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

Regards

Sadeesh

Re: Problem updating infoobject master data from a dso.

mansi_dandavate — Wed, 22 Apr 2009 11:01:42 GMT

Hi Stefano,

I faced the same error while updating the data from DSO to InfoObject. But I am using 7.0 flow. So I checked the setting in DTP for handle duplicate keys. So it worked.

I dont know if in infopackage you will get the same setting.

Regards,

Mansi

Re: Problem updating infoobject master data from a dso.

Former Member — Wed, 22 Apr 2009 11:03:12 GMT

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

Re: Problem updating infoobject master data from a dso.

Former Member — Wed, 22 Apr 2009 12:54:54 GMT

Hi Mansi,

i can't use that option because i inserted the infoobject as an infoprovider, i couldn't assign the datasource i needed in the infosource section of rsa1.

I don't know, maybe it's because the ods was already mapped with other infoproviders...

Regards

Stefano