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

Deletion of Overalapping requests from Cube added in BIA

Hi All,

We have a cube in which we are deleting the overlapping request everyday.

Now this cube is added in BIA and after this the deletion of overlapping request step is failing in the process chain every time, but when we repeat this step it is getting executed successfully.

Following is the error message:

A communication error occured, with the TREX Tcplp

Error when deleting from BIA index reconstruction required

please let me know sollution for this issue such that i dont need to repeat the step every time.

Thanks and Regards,

RK

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2011 at 06:17 AM

    When you are deleting overlapping request from the cube , u need to do Initial Activation and Filling of BIA Indexes which is available in process variant .

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 22, 2011 at 02:31 PM

    Hello,

    I haven't seen this before but these are things I would do;

    1) What does it say in the Job error log? I am thinking that you are getting an error message but the job finishes susccessfully. Also check the OSS notes to see if there is anything for this message.

    2) You can also create a message for SAP but untill then you can just change the process chain to continue even if it's failure to the next step, which is rebuilding BWA indexes.

    3) Just to let you know that when you regularly delete data packages the number of unused records in BWA will increase(BWA deletes them logically) hence you will have poor memory consumption. So it's better to drop and rebuild this cube after each load.

    4) If this will take a long time to load each night you can use this trick; create a cube with the major master data only (Z_MD_BWA 😊 - the largest MDs that take long time to BWA index. Then put this cube to BWA. Since these MD already in BWA, it will take no time to index. Then when you want to drop and reload the cube you're mentioning, it won't take long to rebuilt it - It will just create the fact table indexes.

    Cheers

    Tansu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 04, 2011 at 11:17 AM

    Hi,

    you can try , deleting the indexes and then deleting the overlapping req, loading the data nd then filling the indexes.

    Regards,

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 24, 2011 at 09:01 AM

    Hi Ram,

    Kindly replace the "delete overlapping request" with new variant in process chain and check.

    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.