Skip to Content

DSO: error on activation, SID generation

Hi,

I am loading the datasource 0PU_IS_PS_32 (FI Line Items in Funds Management) into a DSO (0PU_O32). This load has been working fine till a few days ago. The execution of the infopackage and the DTP is ok. But on the activation of the DSO there are several errors in the logging of the DSO (manage DSO > logging button for the concerned request). The most important seems to me:

- request 1: error on SID generation > Process 000002 for determining SID for InfoObject 0PSTNG_SEQ started > Process 000002 returned with errors

- request 2+3: error on SID generation > Process 000034 for determining SID for InfoObject 0ACDOC_NO_P started > Process 000034 returned with errors

- request 2+3: error on SID generation > Process 000037 for determining SID for InfoObject 0ACDOC_NO_P started > Process 000037 returned with errors

- request 2+3: error on SID generation > Process 000057 for determining SID for InfoObject 0ACDOC_NO_P started > Process 000057 returned with errors

How can I solve this errors ? These mentioned info objects are objects without any master data. Settings are :

- DSO: SIDs generation upon activation = yes.

- DTP: further processing without master data = yes.

How can I activate the concerned requests again ? If I want to activate the DSO again, only new requests are shown and not the requests, which went in error and I can not select them ? Do I have to delete the concerning requests from the DSO and then reload again ? It is a delta load.

Thanks, Guy Verschueren

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Jun 14, 2012 at 11:53 AM

    i think you have a issue with data quality. you need to delete the request from the dso, correct the data in the psa and reload again to the dso. activation should be ok now.

    check if you have more info about the error in ST22 or in the joblog in sm37

    M.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 14, 2012 at 12:00 PM

    Hi,

    Try RSRV option.

    Path: RSRV->All elementary text->Master data->SID Values in X and Y Tables

    Regards,

    Aravind.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      Thx for the answers.

      - M Tibollo: I will later today (cause there are some other loads running now) delete the 4 concerned requests on the DSO and execute the delta DTP again. Then I will check the logs/dumps.

      But when you say to correct the corrupted data in the psa, what should i correct ? Can I find somewhere which records in the psa are causing the problems ? It is a delta of ca 160.000 records.

      - Aravind Nag M: I have done the RSRV check for the 3 concerned infoobjects 0PSTNG_SEQ, 0ACDOC_NO_P, 0ACDOC_NO_F) , but I get the messages 'Test does not apply for characteristic 0PSTNG_SEQ (see long text)'. I guess this is because these objects contain no master data tables ? Should I do this check also for the othere objects in the DSO ?

      Kr, Guy Verschueren

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2012 at 12:12 PM

    Hi Guy,

    Could you explain the step in SID generation which got failed?

    Br,

    H

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2012 at 03:40 PM

    Hi Guy,

    Take a look into this link, hope it help you.

    http://wiki.sdn.sap.com/wiki/display/BI/SID+generation+during+DSO+request+activation

    Regards.

    Gonzalo Fernandez

    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.