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

DSO activation fails????

hi experts,

when i execute the DTP the request is green, and i am able to see the data in new data table. but when i activate the request it is becoming red. plz suggest me what is the problem..

regards

vadlamudi

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Jun 19, 2008 at 09:56 AM

    Hi,

    There are a couple of places where you can see the activation progress.

    1) To start with SM37 job log > (give BI_PROCESS_ODSACTIVAT or BI_ODSA*)

    and it should give you the details about the activation job. If its active make sure that the job log is getting updated at frequent intervals. If its completed check the log for ODS activation.

    2) For very huge number of records SM37 job log may not get update frequently. In that case you have a workaround.

    Go to contents > Active Data table > No. of entries > This will keep on increasing at frequent intervals.

    3) SM66 > Get the job details (server name PID etc from SM37) and see in SM66 if the job is running or not. See if its accessing/updating some tables or is not doing anything at all.

    4) Go to Activate button in Target > Request tab. Inside you can see a job log button. It will also show some log regarding the last activation.

    5) If the Reporting icon has appeared near the request id in ODS. If it appears that may indicate that request is available for reporting

    6) Check the request status in these tables.

    Table RSICCONT table contains the requests that are actually loaded in a target.

    Table RSMONICDP contains the request id of the fact table.

    Table RSODSACTREQ contains information if an ODS is available for reporting/deleting inactive requests also possible.

    Table RSODSACTUPDTYPE.

    Check and confrim.

    Hope this helps.

    Thanks,

    JituK

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 19, 2008 at 08:07 AM

    Hi Venu,

    Just analyze the error in logs/ Details tab in RSMO, might be due to invalid chars. just edit the request in PSA and update to DSO and load the data.

    Thanks=Points in SDN

    Rgs,

    I.R.K

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Venu,

      Try to check is there any Dump in St22 or any error noticed in SM21 on this..

      If u dont find anything then u can try reconstruct the data again and check if the activation works fine for u or not??

      Or u can even check the request in RSODSACTREQ.. where u can trace is there any issue in any of the data packet of the load.... If the status is 0 for all the data packets then there is no issue in load and activation .....

      if so then u can turn ur request to Green and then proceed further...

      If u find any the status as wrong then u need to analyze where the issue is..

      Post the results here for more assistance..

      thanks

      Assign points if this helps

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 09:10 AM

    Hi Venu,

    ODS activation fails due to following reasons,

    1) Duplicate records

    2) while activating , SID has changed from 000023...00034 like this

    If you want to load with dupliate records means in ods settings uncheck Unique data records and activate and load it.

    For second one while activating ODS request choose activate records in parallel and try to activate it.

    One more thing check in RSADMINA table for background user (ALEREMOTE) available or not.

    Go to SE14

    Give the active table name..

    Click on Edit

    Click on activate and adjust database.

    Load again and try to activate.

    Also check this link:

    [https://forums.sdn.sap.com/click.jspa?searchID=13085942&messageID=5125079]

    Hope it helps you. Assign points if it helps you.

    Regards,

    Yokesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 09:21 AM

    There must be some error in the activation job. Go to RSA1-ur DSO-manage---> Log of the activation job (not the data load job, as there will be two log sysmbols). Analyze the log to see the error.

    Thanks...

    Shambhu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 10:11 AM

    The data load must have failed....plz see the data load monitor screen for error message.

    SID generation takes place at the time og cube loading also.

    Thanks..

    Shambhu

    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.