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

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2006 at 03:12 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2006 at 10:06 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

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.