"Complete Deletion of Data Target Contents" fails on an empty ODS

[Former Member]

Hi all,

in a process chain, when I use a proces of type "Complete Deletion of Data Target Contents" to remove all data from an ODS,

it fails when the ODS is already empty...

Then I get this error:

Drop_cube failed in data target XXX

Is this standard behaviour of BW, do others have this behaviour as well? Or is there something specificly wrong with our system?

Can I add something like "if not empty then" in the process chain?

kind regards,

Edwin Jacobs

[Former Member · Accepted solution]

Hi,

Its failing because it dosen't find any data to delete. You can maybe write a small ABAP to check if its empty then mark it successful instead of failure.

Cheers,

Kedar

[Former Member · Accepted solution]

Kedar and all others who read this,

shouldn't this check be coded into the proces by SAP???

and if SAP forgot this basic programming technique, everyone should be experiencing the same behaviour when trying to empty an already empty ODS via a process chain.

If you have a moment of free time please test this and post the result here if you please.

greetings,

Edwin

[Former Member · Accepted solution]

Hi Edwin,

Even if ODS is empty, the "Complete deletion of Datatarget" step <b>WILL</b> work. There has been some serious mis-understandings in the previous posts.

There is some other reason for the failure.

Did you try Deleting the ODS Data manually? Does it work?

IF not what error messages do you see?

Do you mind sending me screen shots of your process chain and the job log of your Deletion job failure? (praveen.mathew@aoa.nestle.com)

Lets not give up !

Regards,

Praveen.

[Former Member · Accepted solution]

Hi Mathew,

I have sent a Word doc to your mail...

For all who are reading this thread:

I will post the result here for you to find out what was wrong.

best regards,

Edwin

[Former Member · Accepted solution]

OSS note 623667 seems related, in regard of the symptoms...

however this note is for up until BW 310

and we are on BW 350.

Also, as far as I know, there are no InfoPackages still scheduled that want to load into the data target.

regards,

Edwin

[Former Member · Accepted solution]

Thanks for your Email.

Checking the word document that you have sent, I have a few questions.

1) Does your Process Chain ZPV_START_VB4 have only "Deletion of ODS Contents"?

2) When you Right click and Maintain Variant on the "Deletion ODS Contents step" what do you see?

ODS object or Execute Infopackage?

3) When ever you Double Click on the ODS do you get the Short dump? If yes, I would ask you to use the RSRV transaction and get the ODS checked for consistency.

under "All Elementary Tests" -> "ODS Objects" -> "Foreign Key Relationship of Reporting-Relevant ODS Object and SID Table Characteristics " and "Check the Status of the Generated Program of an ODS Object "( Even otherwise it would be better to check the ODS).

If you find inconsistencies, then correct it. After this pls try Double clicking the ODS.

Can you also Check if the Process Chain has errors in RSPC transaction ->Menu -> Goto ->Checking View....Let me know if you see errors.

Please let me know how this goes.....

We are on BW 350 too, this is our Support Pack level

SAP_BW 350 0014 SAPKW35014 SAP_BW 350

I have tried deleting an Empty ODS multiple times and it works fine for me, I DONOT get "Action Cancelled" instead I get the following message :

Content Of Data Target ODSNAME Successfully Deleted

Message no. RSMPC095

Can you check if you are at the same level, if not would request you to raise this issue with SAP.

Regards,

Praveen.

[Former Member · Accepted solution]

Hi Mathew,

we had a visit from one of our SAP basis specialists, and it appears some tablespaces on Oracle had run out of space during an upload of Dutch language packages.

We are not sure yet if this has to do with it, or that it has to do with the ODS being created by a user who was logged in with language english. (When we log into the system in english, the index is there, tcode DB02, when we log into system with Dutch language setting, there is no index name!)

One thing we know for sure is that there is a problem with the index of the said ODS. When this index is rebuild, the ODS can be opened in RSA1 and the chain runs correctly, also when ODS is already empty.

Deleting manually (right-click and "Delete data") also gives standard behavious now.

I still have to get to the bottom of this.

kind regards,

Edwin

[Former Member · Accepted solution]

Hi all,

just wanted to say that this problem is caused by a faulty index table (when activating the data of this ODS we got a ORA-01502 error)...

We opened a message for this and SAP is working on it:

ORA-01502: index or partition in unusable state

( 0000600021/2006 )

kind regards,

Edwin

[Former Member]

Dear Edwin,

If you look at the following link:

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a65a8e07211d2acb80000e829fbfe/content.htm

it says, the option "Complete Deletion of Data Target Contents" is only for Infocube.

also see:

http://help.sap.com/saphelp_nw04/helpdata/en/2d/677b3c513d3311e10000000a114084/content.htm

Thanks,

Raj

[Former Member]

Dear Raj,

If this process is only for InfoCubes, then why can we select "ODS-object" as Type in the procesvariant?

And why it works with an ODS(when the ODS has data)?

If this indeed isn't the correct way, then what is the correct way to delete all data from an ODS within a process chain? (I cannot make it out from the help).

kind regards,

Edwin

[Former Member]

Hi,

it definitely works also for ods.

/manfred

[Former Member]

Thisfunction should work; anyway you can try by writing an abap routine that delete data:

delete from /BIC/Ayourodsname

Hope it helps.

Regards

[Former Member]

Hi Edwin,

Complete deletion of Data target contents works for ODS and CUBE.

Do you see any other messages in the Failed/Cancelled Job?

Please also check for Short Dumps in ST22 while the process step is failing.

Check if the ODS is consistent using RSRV.

Please try to get more information on the failure.

Regards,

Praveen.

[Former Member]

Hi Praveen,

no, no other messages and no runtime errors.

ODS consistency (with regard to SIDs) is only for reportable ODS (BEx enabled) ... my ODS is not so the RSRV checks are not that important I guess(?)

I'm gonna try the ABAP solution when I have the time, for now I have removed the process from my chains (ODS overwrite records anyway so no big impact in functionality).

Thanks Praveen for your suggestions.