Index status check in BIA & BIA fills failing

[former_member189845]

Hi All,

I'm gonna explain about what is that red alert 'Index status check' in BIA and also BIA fills failing

Index status check

Today morning i just noticed that BIA monitor throws red alert with index status check.

So what does it mean?

It simple as a newbie to BIA you can come to know what does the system says for the red alert, when you click on the details icon you can come to know that one of cube has some problem with BIA and the below check details shows you that in how many blades the indexes of that cube has problem.When ever you place any cube in BIA/when you create indexes for cube that indexes will be shared across all blades available in BIA,

So its say the index for cube has been corrupted for all blades avaliable in BIA. So we need to do re-building of BIA index for that cube.

To make sure you can also check in trex admin tool under index landscape /index admin for that particular cube

So first we have delete cube from BIA using RSDDB t-code and didn't touch the master data table started rebuilding index for the cube for which the index is corrupted, in most of cases the rebuilding index will be success but in our case its fails

BIA fills failing

The index build failed for the cube with error says BWA error code 1110 and SQL ERROR 8901.

Reason for BIA fills failing

Filling of BWA index fails due to a not valid date format.

we have checked the data in cube and underlying DSO that during loading data from DSO to the cubes if the date filed is initial in DSO, incorrect data “, ,0” is being updated into the cube for some of the info objects like date fields and  In the cube the date fields are key figures based on date which are mapped to date characteristic fields from DSO.

Cube:

DSO:

And in most of times its not being properly updated and DATE key figures that have blank values like ',0.'

So clean up of data is indeed.

Please let me know for your comments/doubts.

Regards,

Siva