on 10-19-2015 9:52 AM
Hi,
The datastore 0PM_DS11 was activated from business content,no issue with that process.
The data update process fails from an unknown reason, the transformation return a duplicate entries message when try to update dso 0PM_DS11 from 0PM_DS12
Doing debugging in the end routine the result_package has no duplicate records, in the end routine the function RS_BW_BCT_KEYFIGURE_ARRAY_GET, returns all the information with the 0PM_D11 key fields populated no duplicate records there, but the error message is triggered.
Another extra information, system version SAP BW 7.4 SP 9
Business content version 757 SP 4
Please let me know what could I be missing.
Hi Luis,
Did not realize that the load was to a DSO. can you please load sample data just by giving a selection in the DTP filter. If that works then we can conclude that the issue is caused by some set of records.
Meanwhile i will try to get more information on the same
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Luis
Could you please check the key fields of the target DSO and compare it against the source DSO to see if there are duplicates.
In your first screenshot, there is only one record coming into the filter level. Is that a test data or the source DSO contains only that much data?
Do you have any filters in the DTP?
Regards
Karthik
Hi Karthik,
Thanks for your reply. Regarding the number of records, the image displays just one because I've filtered for a specific equipment for debugging purpose , the data package has some thousands of records.
Also I checked the key fields, but there is a counter of outages per day that should create the unique key in target DSO.
All the structure is business content standard we haven't made any changes.
Hi Luis
I am trying to get the exact reason. Meanwhile, could you please run the DTP with semantic group enabled.
Is there any code in end routine which writes data into the DSO?
Could you please check the temp storage after start routine and end routine? to see if there is any duplicate records gets generated from nowhere.
Regards
Karthik
Hi Luis,
Can you please enable the option "Handle Duplicate records" in the DTP level and try loading again ?
Regards
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.