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]

Hi,

Did you try out the 'Correct Error' option available in RSRV.

Once you perform the check, you get into an internal screen which displays the error messages. Come back to the main screen of RSRV using the back button and click on the correct error button available at the top. This should help.

Regards,

Shyam.

[Former Member]

Hi,

I already tried 'Correct Error' option available in RSRV.

I got "No automatic correction possible."

Thanks,

Naveen

[Former Member]

If it was me ... I would take the cube out, then put it back in.

From what I understand all these checks compare the indexes with the statistics so making sure they are up to date is important. Before I take the index out of BWA I always make sure that the cube index is renewed, then exe the index checks on RSRV and renew the stats.

I had a problem once with results in a query being wrong and taking the cube out and putting it back did not solve the issue. The weekend before we had hardware issues with a couple of baldes being down. I blamed the shared master being wrong (right, which one is wrong) so only alternative was to take all the cubes out and re-index them.

Mike

[Former Member]

Hi,

I have done like this i am not taken the cube out but I go to Bi accelerator monitor in that biaccelerator-> maintenance Functions-> delete all data for bi accelerator, it will delete the data in bi accelerator and i build all the indexes then i got to rsrv and I select Compare data in BI tables and BIA indexes after that also i got same error ('32' records missing from index in DB table '/BI0/F0CSAL_C01'; index must be rebuilt)

then i will go to Bi accelerator monitor and i select rebuild bia indexes after that also i got same error.

In your scenario query being wrong data you taking the cube out but my scenario indexes are missing in bia. i checked indexes in cube (right click cube ->manage->select performance->check db indexes)

Thanks,

Naveen

[Former Member]

Naveen,

Are you telling me you

1) "remove the cube" from BWA

2) go to rsrv

3) run the check "Compare data in BI tables and BIA indexes"

That does not make sence because you would get an error message like "HPA Indedx for Infocube xxx_xxxx is not active"

Additionally, if you run this check know that:

If you execute this check, you have to change the value for the maximum number of records. To do this, make an entry for the table RSDDTREXADMIN. In the object field, enter 'MAXLINES' and in the value field, enter the maximum number of records per table/index. The default value, which is the value if there is an initial entry or no entry in RSDDTREXADMIN, is 10,000. The system limit is 100,000 - more than that cannot be compared. If this is the case, choose other, quicker tests.

Note the LAST sentence .... the system limit is 100,000 and more than that can not be compared.

I have VERY FEW cubes with this minimal number of records which make this test not practical.

Mike