Update stats failed with ORA-20000

[Former Member]

Hi,

In our BW prod system update stats failed with the below error.

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

'EXECUTE stmt_1x'

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BIC/FZPS_C041"', ESTIMATE_PERCENT => 1, METHOD_OPT => 'FOR COLUMNS SIZE 150 "KEY_ZPS_C041P" FOR COLUMNS SIZE 1 "/BIC/ZAMOU

NT","/BIC/ZAMOUNT1","/BIC/ZAMOUNT3","/BIC/ZAMOUNT4","/BIC/ZKF_LEHR2","/BIC/ZKF_LEHRS","/BIC/ZQUANTY1","/BIC/ZQUANTY2","/BIC/ZROPAMT1","/BIC/ZROPAMT2","AMOUNT","AMOUNTDP","AMOUNTPP","KEY_ZPS_C0411",

"KEY_ZPS_C0412","KEY_ZPS_C0413","KEY_ZPS_C0414","KEY_ZPS_C0415","KEY_ZPS_C0416","KEY_ZPS_C0417","KEY_ZPS_C0418","KEY_ZPS_C0419","KEY_ZPS_C041A","KEY_ZPS_C041B","KEY_ZPS_C041T","KEY_ZPS_C041U","OPR_

ACTWRK","OPR_PLDWRK","QUANTITY","QUANT_AVRG"', DEGREE => NULL, GRANULARITY => 'ALL', CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

ORA-20000: partition "/BIC/FZPS_C0410000025043" of table "SAPSR3"."/BIC/FZPS_C041" 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/FZPS_C041

And when i re executed, it is successful.

Please help me finding out the cause for this.

Thanks

Padmini

[Sriram2009]

Hi Sivaji

1. Could you share the  SAP BI & Kernel version details?

2. Could you refer the SAP Note

1901062 - ORA-20000

BR

SS

[former_member182921]

Hi Padmini ,

Please check

It has all your answers

Update me once issue is resolved

1. Please make sure that all oracle executables has permission as per

the note mentioned below.

583861 UNIX: Errors due to Oracle executable

(chmod 6751 oracle) Owner ORA<SID>

2. If the problem is not solved with this, please download the latest

patch level of the BR*tools as per SAP note 12741.

" Check the owner, the group and the permissions for sapdba and the br*

tools as described in Note 113747.