Problem deleting active data in ODS

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[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.

[former_member372548]

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

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

[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.

[former_member184494]

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

Arun

[Former Member]

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