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

Request is already (partially) activated; activate or delete the request

Hi,

after start activate the request its follow the message:

Request is already (partially) activated; no further QM action possible

Message no. RSM1533

How can I activate or delete the request in the DSO?

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 Jan 22, 2008 at 09:52 AM

    Hi,

    Can you find reporting symbol for this request in manage tab? check is there any activation job is running in SM37 for this ODS.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      Can u confrim a few things.

      1. All the requests in ODS have green status.

      2. All the requests have reporting icon available.

      3. Records have been added to ODS tables (Active and change log).

      4. Are there pending requests to be activated?

      In case you want to delete an active request try these steps.

      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

      Delete requests manually from the ODS tables.

      1. tcode se16.

      2. delete the request in these tables : RSICCONT (delete activated requests OR

      Make the selective deletion of the contents of that request), RSMONICDP, RSODSACTREQ (give the name of the ODS and the request ID and delete all the entries pertaining to this selection in that table.), RSODSACTUPDTYPE,

      You can refer to this notes: 947481

      The request will be removed from your ODS.

      But be very careful with this steps.

      Thanks,

      JituK

  • Posted on Jan 22, 2008 at 11:31 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.

    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.

    Thanks,

    JituK

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 10, 2019 at 03:55 PM

    I had the same issue, the ready for reporting tag is appearing and it is partially partially activated with error..

    what i did is ..

    1) go to Sm37 - find the job which is ended with error for the same job.

    2) copy the job, trigger it immediately, t(he partially completed job will be executed with successful)

    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.