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

Problem deleting active data in ODS

Hi all,

I have an issue trying to delete requests from an ODS. Full loads are done to this ODS. Here is the complete log for the deletion job from SM37.

Job started

Step 001 started (program RSDELPART1, variant 0000000008909, user ID XXXXXX)

Delete running: ODS object INVAFBF, from 278,367 to 278,367

Delete is scheduled; Selection conditions were substituted

FB RSM1_CHECK_DM_GOT_REQUEST called from PRG RSSM_PROCESS_REQUDEL_ODSO; row 000396

Request '278,382'; DTA 'INVAFBF'; action 'D'; with dialog ''

Leave RSM1_CHECK_DM_GOT_REQUEST in row 70; Req_State ''

No records found for request ODSR_49W5QUVSVR4SF6YHGEMCJVTTH in change log /BIC/B0002870000 in ODS INVAFBF

Deletion of request REQU_49W4883C5Q2JY4MHJQ20MC8FP from data target INVAFBF failed

Deletion of request REQU_49W4883C5Q2JY4MHJQ20MC8FP from data target INVAFBF failed

No records found for request ODSR_49W5QUVSVR4SF6YHGEMCJVTTH in change log /BIC/B0002870000 in ODS INVAFBF

Job finished

I have checked the changelog table for this ODS and it has no records.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 27, 2008 at 04:50 AM

    Hi,

    You did it other way round. You have to make the QM RED before deletion an all the cases. DO it now making the QM red.

    When you delete the active request from the ODS, the data gets deleted from the Active table. In case of full load, I guess there is no data in the change log.

    Check this:

    http://help.sap.com/saphelp_nw04/helpdata/en/6d/1fd53be617d524e10000000a11402f/frameset.htm

    Thanks...

    Shambhu

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Sorry to have come back so late.. But here is what I did.

      I don't know how to explain this but when I did a load to the cube above this ODS in the data flow and then attempted to delete the same request in the ODS, it worked!!

      Also I could reproduce this two other times. Loading the data to the cube and then getting rid of the request. It worked all the three times.

      Can somebody explain this?? thanks in advance

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

    Hi Arun,

    Are u trying to delete the whole cotent of the ODS or u are trying to delete only one request from the ODS?

    And also let us know if ur ODS is getting feeded by mutiple data sources or by only one data souce?

    if its multiple then let me know all are full or full and delta types from different DS's..!!!

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 26, 2008 at 05:15 PM

    make sure that the requests have not been updated to any targets...

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 27, 2008 at 12:26 AM

    Are you trying to delete data package by package from Manage screen?

    Edited by: Arjun Ale on Jun 27, 2008 2:26 AM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Arun Vardarajan,

      Here are ur answers

      1. I am trying to delete requests one by one.

      2. This ODS is fed by one another ODS. The loads are full loads.

      Hi Arjun,

      The data mart status is not there for this request and this is not the last infoprovider in the dataflow. Since this is a QA system I want to check the health of the data on this ODS. That is why I am loading data to the infoprovider at each level and checking . Also I am trying to delete the data by request in the manage screen for the ODS.

      Hope this helps.

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

    Arun,

    In case you have to delete the whole content of the DSO, go to RSA1>your DSO>right click and say "delete data".

    However, deleting the request, make sure to make the QM red before you start the deletion job. Since, datamart status is not there, I think you will be able to delete the request now.

    Thanks..

    Shambhu

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Shambu,

      I followed the same steps to get rid of the previous data. And am reloading data into this ODS.

      But this is my concern.

      From the log for the deletion job that I posted, it seems that there is no data in the Changelog table of this ODS.

      1. I want to know how Change log table behaves in full loads?

      2. What happens when an active request in an ODS is deleted from the manage screen?

      This is because I changed the QM status from red to green for a particular request in this ODS and tried to delete the data. But the job completes without deleting the data and it says that there is no record for that particular request in the changelog table.

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.