Update Statistic get Fail in BW system

[Former Member]

Hi,

I am facing some Update Statistic related problem in my BW/BI system.

I have schedule update statistic for every morning on BW system, which is getting fail every day due to missing indexs.

Becuase of this i have rebuild the index and restart the update statistic which is getting succesful after that.

When i analyis the i found that at same time some BI process chain has been schedule ( BI data upload ).

for that reason i change my update statistic schedule , but again same problem , everytime update statistic get fail becuase of missing index , which need to rebuild everytime and rerun the update statistic.

Need help , any faced the same problem.

Thanks

Anil

[Former Member · Accepted solution]

Afaik problems with index on /BIC/* tables happen quite often in BW systems. That's somehow related to rebuilds of infocubes. There are a few SAP notes about it, like 1042182 and 157918.

hope this helps

[former_member227283]

Hi Guatam,

JEO is right , my problem also resolved by using SAP note :- 10421812

Pls follow the below procedure to solve your problem.

1. Execute program RSAR_PSA_PARTITION_CHECK from SE38.

2. Execute the u2018RSAR_PSA_PARTITION_CHECKu2019 program in repair mode ( REPAIR = u2018Xu2019 ) if you are prompted to do so in the

second row of the log. We recommend that you execute the u2018RSAR_PSA_PARTITION_CHECKu2019 program in the background.

3. Check again without ticking Repair box. If you see everything in green then it works, otherwise please consult

with your BW consultant.

Thanks

Anil

Edited by: Anil Bhandary on Dec 17, 2009 12:41 PM

Edited by: Anil Bhandary on Dec 17, 2009 12:41 PM

[former_member227283]

Hi Juan,

Some time i need to rebuild the index using brtools.

Thanks

Anil

[former_member759680]

Hello,

I too get update stats failure in BW, but mostly because of just one index.

I just run the update again for the missing ones (brconnect -u / -c -f stats -t missing)

BR0301E SQL error -20000 at location stats_tab_collect-20, SQL statement:
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BIC/B0001106000"', ESTIMATE_PERCENT => 10, METHOD_OPT =>
ORA-20000: index "SAPSR3"."/BIC/B0001106000KE"  or partition of such index is in unusable state
ORA-06512: at "SYS.DBMS_STATS", line 13159
ORA-06512: at "SYS.DBMS_STATS", line 13179
ORA-06512: at line 1
BR0886E Checking/collecting statistics failed for table SAPSR3./BIC/B0001106000

Of course it would be better to get a permanent solution like Anil has said above.

[former_member227283]

Hi Juan,

Generly i create the index and re-run the update statistic , which get succesful.

But, when in next-day schedule it again fail with some other missing index.

Then again i create index.

it become daily acitivty.

Any idea , how can i solve it permanently.

Thanks

Anil

[JPReyes]

If you create the indexes at DB level they shouldn't disapper...

Regards

Juan

[former_member227283]

Hi Juan,

No , it is not present in DB.

Thanks

Anil

[JPReyes]

I think your need to create those indexes at DB level... You can use SE11/SE14

Regards

Juan

[JPReyes]

Does the indexes exist on the DB?...

Regards

Juan