Skip to Content

Request Deletion

Hi Friends,

I have a Delete overlapping req step in Process chain and it has failed with the below error,

Error when deleting requests for comparison request DTPR_*****

Deletion of request DTPR_4****** from data target *******failed

Error while processing aggregate

reqdel_infocube_with_aggr****** RSDDK_AGGREGATES_FILL

Deletion of request DTPR_*******(2291417) from InfoCube ******* terminated. Reason X_MESSAGE

Error deleting request DTPR_4N608WEXAWS00EMXINX8ZGPSY from InfoCube /SIE/EF_CFIT. Exception: Unknown error

Could you please help me to know the exact reason for this above errors.

Many Thanks!!!

Regards,

Syed

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2011 at 03:32 PM

    hi,

    Are the aggregates compressed after the rollup?

    If you compress the request after aggregate creation the Request you are trying to delete is no longer identifiable once it is in the compressed E fact table (since it throws away the Request ID).

    So you need to change the aggregate so that it the most recent Requests remain in the uncompressed the F fact table.

    Goto manage, aggregates tab. Uncheck the box compress after rollup.

    Then the Request deletion should work.

    regards,

    Arvind.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2011 at 05:57 AM

    Hi,

    As I know the sequence for delete overlapping request should be ,

    1) Delete index

    2) load data

    3) build index

    4) delete overlapping request

    5) roll up aggregates.

    What is the sequence you are maintaining?

    Regrads,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 14, 2011 at 06:06 AM

    Hi Shameer,

    It seems that you are performing the compression of aggregates after the request is being loaded. Please remove the compression of request after the load. Also check if the steps for request deletion have been maintained correctly.

    Please refer the below thread it wil be helpful to you in determinging the correct sequence of steps:

    Delete Overlapping Requests from Cube not deleting old full requests

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 14, 2011 at 07:50 AM

    Hi,

    Pl check below points

    1. If the cube is getting compressed then you left with only one recent request only and you left with option of selective deletion only. If you want to delete individual request you have to remove /stop the compression job so it will stop both the compression and aggregate compression activity and requests will be free to delete.

    2. You also need to delete index and recreate that will improve your performance in loading and deleting requests.

    Pl check following link as well

    Thanks and regards

    Kiran

    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.