intermittent statistics failure for F fact tables.

[Former Member]

Hello,

We are running our BI 7.0 EHP1 on Oracle 11.2.0.4 on AIX 6.1.  We are getting itermittent statistics failure on F fact tables. Does anybody know why we face such issues. The F fact tables get changed everytime when such issue occur so the issue is not specific to any table.

BR0301E
SQL error -20000 in thread 1 at location stats_tab_collect-89, SQL statement:

'EXECUTE
stmt_1x'

'BEGIN
DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME
=> '"/BIC/FRSC_C20"', ESTIMATE_PERCENT => 1, METHOD_OPT =>
'FOR COLUMNS SIZE 150 "KEY_RSC_C20P" FOR COLUMNS SIZE 75
"KEY_RSC_C201","KEY_RSC_C202","KEY_R

ORA-20000:
partition "/BIC/FRSC_C200000012791" of index
"SAPSR3"."/BIC/FRSC_C20~040" does not exist or insufficient
privileges

ORA-06512:
at "SYS.DBMS_STATS", line 23902

ORA-06512:
at "SYS.DBMS_STATS", line 23953

ORA-06512:
at line 1

BR0886E
Collecting statistics failed for table SAPSR3./BIC/FRSC_C20

Thanks,

Dnyandev

[thiago_cavalheiro]

Hello Dnyandev,

Please take a look at the note bellow regarding this error:

  633914 - Error when executing DBMS_STATS

Regards,

Thiago

[Former Member]

Hi Thiago,

Thanks but we are using BRCONNECT for running statistics. we do not use DBMS_STATS so the note is not applicable for us.

Thanks,

Dnyandev

[thiago_cavalheiro]

Hi Dnyandev,

I know, BRCONNECT calls DBMS_STATS underneath. So actually you are using DBMS_STATS, but from a BR*Tools interface. So you can follow the recommendations on the note.

Regards,

Thiago