Skip to Content

Are you facing error while running your BEx report saying “BWA index corrupted”(displayed in image below).

BIA.png

Steps to check & resolve the Issue:-


1. Check your reporting cube is in BWA Server.

2. If yes, Right Click the cube -> select “maintain BWA Index” or can be accessed through the T-Code “RSDDB”. You wil get the screen lik below,

BIA1.png

3. Give your Infocube name for which you want to check for the BWA Index status and press “Display”. you will reach the below screen,

/wp-content/uploads/2013/08/bia2_263525.png

4. Now, check for the status for the cube and then press “log” -> goto “Inital filling” -> check the history logs — to confirm “Initial fill for the cube is success(No “Yellow” status in log).

5. If Initial fill is success, then check the “log” -> goto “rollup request” -> check the history logs — to ensure the rollup for the cube is running fine.

/wp-content/uploads/2013/08/bia3_263526.png

Give the date range two weeks (dependents upon how frequently you are running rollup for your cube)

/wp-content/uploads/2013/08/bia4_263527.png

If you get the status as showed in below snapshot, then your cube’s index is corrupted.

/wp-content/uploads/2013/08/bia5_263528.png

How to fix:-

1. Remove the cube from BIA / BWA and rebuild it.

Note: While deleting the Cube from BIA “Do not delete Master data associated to the cube”(Removing master data will cause rebuilding master data index again which will basically takes more time).

How to test/ensure BIA is causing the problem :-

1. run the same query using RSRT t-code and select “without BIA”.  If your query runs fine then, the above mentioned was the cause for your issue.

To report this post you need to login first.

19 Comments

You must be Logged on to comment or reply to a post.

    1. JayaBharath S Post author

      Hi Arunkumar,

      For now, I came across such error and found solution to fix the issue.

      Sure will be posting documents for “error in running BEx associated with BWA” if i encounter any.

      Thanks for ur comment.

      Bharath. S

      (0) 
  1. Umashankar Poojar

    Good one, helpful to find the root cause and fix the issue. Looking for other issues due to BIA and fix. Hope you will share soon 🙂

    Thanks for sharing!

    Umashankar

    (0) 
  2. Manna Das

    This one is good about Bex error. But there could be many reasons of “No applicable data found”. Though there is a error on screen which you described how to solve. Thanks for sharing this.

    Kind Regards

    Manna Das

    (0) 
  3. Sivaramakrishnan M

    Hi JB,

    Useful stuff thanks for sharing 🙂 I’ve one doubt say for instance that there his 10 cubes in BIA and in that 2 cubes index got corrupted in such thing we delete and rebuild index for that 2 cubes may i know reason like why particularly that 2 cubes got corrupted and why its so

    (0) 
    1. JayaBharath S Post author

      Hi Mehta,

      Once you proceed with removing the cube from BIA, there will be a prompt message ask your confirmation to delete index for master data associate to the cube. There you have to say “NO”.

      Thanks,

      Bharat

      (0) 
  4. Anshu Lilhori

    I faced this once and i need to accept that i forgot how we solved it so great that you have documented this information with all the possible steps to be followed to resolve it.

    Good job.

    Regards,

    AL

    (0) 

Leave a Reply