Hi all
We have an infosource 0FI_AR_3 that loads to an infoobject 0BILL_NUM and to an ODS 0FI_AR_O03. Yesterday, the load to the ODS was fine but the load to the InfoObject 0BILL_NUM has failed giving me the following error;
"128 duplicate record found. 4115 recordings used in table /BI0/XBILL_NUM"
"128 duplicate record found. 4115 recordings used in table /BI0/PBILL_NUM"
Is there a way I could fix this error. Could some one help me please.
Regards,
S.P
Hi,
did ou try with setting 'Ignore double records' in InfoPackage under Processing tab?
regards
Hi SP,
Since you are using a transactional datasource to load to master data, you will not have the Ignore Duplicate records option. You can try to prevent such errors in the future by setting error handling in the InfoPackage Update tab.
Hope this helps...
Hi Everybody,
Thank you for responding. I already have the setting in my InfoPackage as "PSA Only, Update subsequently into Data targets".
Since I have this infopackage loading to both Master Data and an ODS, I will not have the option of selecting "Ignore Double Data records" in the infopackage.
So this boils down to the problem I have in the data load today.
What other option do I have to fix this issue.
~S.P
Hi SP:
THis is just an idea. What if you try to load MD from ODS. THis way, depending on your ODS keys, the ODS already aggregates and then your MD load should be OK.
Ofcourse, it all depends on ODS Key Fields.
Good luck
Ram C.
Add a comment