Skip to Content

Issue activating DSO

Since last week a certain DSO refuses to activate. It is a standard DSO (BW system runs on NW 7.01, but this still is a 3.5 dataflow).

As far as I know, no changes were made in the source system or BW system.

See the errorlog below.

SID determination finished

Process started

Error while inserting data records for data package 1 (see long text)

Data records are in the data package more than once

Technical key: 00702217 / 00000001 / 00018329

Technical key: 00702217 / 00000002 / 00000001

Process 000001 returned with errors

Data pkgs 000001 ; Added records 1- ; Changed records 0 ; Deleted records 0

Log for activation request ODSR_DE1JIQ47OQA2CXZNZ2JFT1DT2 data package 000001...000001

Errors occured when carrying out activation

Analyze errors and activate again, if necessary

Activation of M records from DataStore object DH0009_1 terminated

When I look into the PSA, I don't see any similar data records. Can I look up the technical key somewhere?

Any suggestions how to fix this?

Thanks,

Bert-Jan

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2012 at 05:36 PM

    Hi Bert,

    check if you can find the records in the newdata table of DSO. key of this table will sid of request + datapackageid + record no. Goto manage of DSO to open the table.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2012 at 05:34 AM

    Hello Bert,

    Can you please check the setting Unique data reacords is checked ? in DSO settings tab.

    If it is checked :

    Overwriting data records not permitted

    Definition

    The DataStore object can be used for loading unique data records.

    Use

    With this flag, you define whether only unique data records are posted to the DataStore object. This is recommended if you are sure that the active table does not contain any records with the same key. During activation, the system does not need to read the data again, to check whether records with this key already exist. This means the activation runtime is reduced, especially in cases where the active tables contains a large number of records.

    If the loaded request contains data that is already in the DataStore object however, activating the request will produce an error

    Regards,

    Deepak Chavan.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 15, 2012 at 09:08 AM

    After deleting the content of the DSO twice, the issue was resolved. The data activated.

    Thanks for your input though.

    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.