Skip to Content

DTP: Record filtered in advance as error records with the same key exist

Hi,

I have a transformation from one DSO to the same DSO. The aim is to update all data records in the DSO with the information provided by other InfoProviders/characteristics. The data are updated in the DSO through a Data Transfer Process (DTP) in full mode. Such a DTP extracts data from the Active Table (with Archive) of the DSO.

When I run the DTP, many error messages RSM2 722 (Record filtered in advance as error records with the same key exist) are sent to the monitor, and so the loading is unsuccessful.

I can't figure out why this happens. How is it that duplicate records are extracted from the active table (not the change log!) of a DSO?

Thanks & Regards,

Davide

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Apr 30, 2010 at 07:15 AM

    Create an error DTP, so all the error records will be collected in error stack which you can correct and load.

    If error DTP is already available then delete existing records from error stack. Also delete the PSA.

    If the DSO you are using is a write optimized DSO then set the checkbox "Do not check uniqueness" to ON.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello,

      now my question is: from the Data Warehouse Workbench, how can I visulise all the records in a DTP's error stack--i.e. related to all the requests? Because it's tediuos to go to the monitor for every request and check whether there are records for that request in the corresponding error stack!

      I'm using transaction SE16 to get such information, but is a more direct and intuitive way from the Workbench?

      Thanks, Davide

  • author's profile photo Former Member
    Former Member
    Posted on Apr 30, 2010 at 04:19 AM

    Go to transaction RSRV and do all the elementary tests and combinations tests for your source DSO and Cube. If any SID problem or any other, you can correct ther error ( button in the header)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2015 at 09:04 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

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.