Skip to Content
Author's profile photo Former Member

How to resolve “error in running BEx report – BIA/BWA Index is corrupted”

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.

Assigned tags

      19 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice document.

      Is there any other ways we get error in running BEx associated with BWA.

      Share more docs.

      thnx,

      Arun Yadhav

      Author's profile photo Former Member
      Former Member
      Blog 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

      Author's profile photo Former Member
      Former Member

      thank you Jaya,

      Author's profile photo Umashankar Poojar
      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member

      Nice document. Thanks for sharing

      Regards,

      Reshma M.

      Author's profile photo Sivaramakrishnan M
      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

      Author's profile photo Kamal Mehta
      Kamal Mehta

      Thanks.

      How to make sure that Master data associated to the cube is not deleted.

      Author's profile photo Former Member
      Former Member
      Blog 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

      Author's profile photo Former Member
      Former Member

      Good Document Bharath.clear screen shots to  solve issue  for index corrupted In BWA.Helpful one,.

      Author's profile photo Former Member
      Former Member

      Niece Piece of INFO 🙂 🙂 .

      Regards,
      Giri

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili

      Hello Jay Bharat,

      Great read.. Indeed, Very helpful... Awesome article.... Thank you.

      Author's profile photo Former Member
      Former Member

      Nice..

      Author's profile photo Former Member
      Former Member

      Thanks for the informative post Bharath!

      Author's profile photo Former Member
      Former Member

      Good work.

      Regards,

      Sushant

      Author's profile photo Phani KV
      Phani KV

      Nice document thanks for sharing.

      KV.

      Author's profile photo Anshu Lilhori
      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

      Author's profile photo Satendra Mishra
      Satendra Mishra

      nicely documented and step by step thanks for sharing 🙂

      Goodone 🙂

      Regards,

      SM

      Author's profile photo Phani KV
      Phani KV

      Hi,

      Good Work and nice presentation.

      Thanks,

      Phani.