Error with indexes in SAP BW 7.4 SP6

[Former Member]

Hi all,

We have faced an issue today while loading data into one of our COPA cubes. The error message is, "

'Error reading the

data of InfoProvider Y5CO1*****X' which indicates problem with cube index.

I went to listcube and gave the Infocube and on executing I got an error message that said, "Infoprovider not activated correctly. An error occurred when getting data from the processor"

I went to transaction DB02 and checked the indexes status for consistency check. And I find that the indexes for a lot of tables are inconsistent (X mark before the inforprovider name X /BIC/DY3WR7ZA0P) The attached document has the screen shot of the inconsistencies from DB02 transaction.

Now my question is how do I remove these inconsistencies for all these InfoProviders? Do I have to recreate the indexes? How do I do it?

Please advise.

Regards,

Pavan.

[former_member186053 · Accepted solution]

Hi Pavan,

Try to check the cube in RSRV and repair it if required.

You can also activate a cube by using RSDG_CUBE_ACTIVATE program.

Take the help of DB team to fix these.

Regards,

Vengal.