Skip to Content
author's profile photo Former Member
Former Member

Full loads fails due to old requests in the PSA

For updating our master data, we load the data into the PSA using an InfoPackage and from there into the InfoObjects using a DTP (running on NW2004s, SP11).

Executing the IP and DTP the first time works fine. When running these steps a second time, the DTP fails because of duplicate records. It turns out that the old request from the PSA got loaded again which lead to the duplicate records even though this data loaded successfully before and we are performing a "full load".

Can someone explain this behavior and tell me how to resolve it? When I manually delete the old requests in the PSA, the DTP runs without any errors (updating existing data in the InfoObjects).

Thank you,

Dennis

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 04:35 AM

    Don't know if things are different with 2004s, but what you describe certainly doesn't sound right. The InfoObject should know wha it has loaded form the PSA and not load it again unless you have some sort of Repair option set. I wouldn't think the Duplicate Keey setting is teh appropraite resolution. Hopefully some more folks running 2004s will post.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 04:06 PM

    Checking "Handle Duplicate Record Keys" on the DTP works around the problem (together with Delta loading), but we will now loose the ability to actually identify duplicate records as the system silently resolves it.

    Is there a better solution?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I think your note describes exactly my problem. As I said, turning the "handle duplicate records" setting on works, but it only looks like a temporary solution to me. Loading master data without this setting always fails (if there is more than 1 request in the PSA).

      For now, I assume this is the only way to get around it without reverting to a 3.5 update/transformation?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.