DB13 - Update stats error

[former_member759680]

Hello,

In our BI 7.0 system, I received the following error in update stats log:

BR0301E SQL error -1760 at location stats_tab_collect-16, SQL statement:
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BIC/FZBBP_C03"', PARTNAME => '"/BIC/FZBBP_C030000003754"', ESTIMATE_PERCENT => 6, METHOD_OPT => 'FOR COLUMNS SIZE 150 "KEY_ZBBP_C03P" FOR COLUMNS SIZE 75 "KEY_ZBBP_C033","KEY_ZBBP_
ORA-01760: illegal argument for function
ORA-06512: at "SYS.DBMS_STATS", line 13437
ORA-06512: at "SYS.DBMS_STATS", line 13457
ORA-06512: at line 1
BR0886E Checking/collecting statistics failed for table SAPSR3./BIC/FZBBP_C03

Kindly help resolve this error

[Former Member · Accepted solution]

Hi Gautam,

Can you please let us know what version of Oracle you are using, If you are on oracle 9 patchset8 (9.2.0.8), the syntax of the parameter METHOD_OPT of the package DBMS_STATS was changed by Oracle and is now incompatible. This leads to the following error in the BRCONNECT statistics function.

Pls check the below SAPnote and revert if its usefull to you.

Note 1013000 - Corrections for ORA-06502 in DBMS_STATS in Oracle 9.2.0.8

Also try to get the latest level of BRTOOLS and also if that doesnot work try to start the BRCONNECT using Cron Job/At Job, and not using DB13. You can use the SYSTEM Oracle user here with the corresponding password that has the necessary authorizations (DBA role).

All the best !

Edited by: prateek_y on Aug 10, 2010 10:21 PM

[former_member759680 · Accepted solution]

Apologies for the delay.

We are using Oracle 10.2.0.4.

And we are still getting this error. Only difference its a different index everytime.

[fjhernanz · Accepted solution]

Hi,

I would firstly suggest to make sure you are on latest brtools version (SAP note 12741). In case problem persist, I think it would be a good idea to open a message in SAP Support (Component BC-DB-ORA-DBA) since a Trace level 3 would be needed for troubleshoot this issue. You can check note 29321 about how to increase trace level for Brtools

Br,

Javier