consistency check errors

[Former Member]

Hi Friends,

I am very new to business Intelligence Accelerator when i am doing concentency check (TN: RSRV)

Compare data in BI tables and BIA indexes : I have this error ('32' records missing from index in DB table '/BI0/F0CSAL_C01'; index must be rebuilt)

when I am rebuild this index using program RSDDTREX_SINGLE_TABLE_INDEX, here i given the table name as well as cube name

but it's showing "Background process '1' complete: number of records '19'" after selecting ok i got "Background process '2' complete: number of records '22'" this popups.

After that i gone through RSRV Compare data in BI tables and BIA indexes i got same error how can i resolve this issue.

I have delted the indexes and filled the indexes after that also i got same error please help me this issue

Thanks,

Naveen.

[Former Member]

I don't normally use the program, but wantd to make sure I understood how you were using it:

For the Infocube you put in: 0CSAL_C01

Reason you put in: "MIssing records"

Table Names you put in /BI0/F0CSAL_C01

Mike

[Former Member]

Hi,

when I check the message long text I found procedure to solve this they given the program name that's why I using it.

I put in both the infocube and table name why becuase I have missing records for the table that means f table that table belongs to that cube that's why I given the cube name as well as table name and I execute it, it gives same error messages.

next time I have given only cube name and I execute it, it gives same error messages.

and next time I given only table name and I execute it, it gives same error messages.

My statistics are upto date for that cube.

Thanks,

Naveen