update statistic error "BR0301E SQL error -904 at location ..."

[Former Member]

How do I fix this error in when running update statistics in DB13?

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

BR0886E Checking/collecting statistics failed for index SAPEWD./BIC/DZEW_C0055~01

BR0280I BRCONNECT thread 2: time stamp: 2007-08-10 07.24.29

BR0850I 6 of 87 objects processed - 0.051 of 0.745 units done

BR0204I Percentage done: 6.90%, estimated end time: 7:24

BR0001I ***_______________________________________________

BR0280I BRCONNECT thread 2: time stamp: 2007-08-10 07.24.29

BR0301E SQL error -904 at location stats_ind_collect-2

ORA-00904: : invalid identifier

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

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

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for index SAPEWD./BIC/DZEW_C0056~0

BR0280I BRCONNECT thread 2: time stamp: 2007-08-10 07.24.29

BR0301E SQL error -904 at location stats_ind_collect-2

ORA-00904: : invalid identifier

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

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

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for index SAPEWD./BIC/DZEW_C0056~01

BR0280I BRCONNECT thread 2: time stamp: 2007-08-10 07.24.29

BR0301E SQL error -904 at location stats_ind_collect-2

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

[Former Member · Accepted solution]

Hi,

it is probably a bug with dbms_stats, check the oss notes below.

for 9i: Note 898244 - ORA-904 with the DBMS_STATS package

for 10g: Note 896992 - Oracle Database 10g: ORA-00904 for GATHER_INDEX_STATS

Thanks

[Former Member]

Hi,

with 9.2.0.7 there is a bug with dbms_stats you should then apply the note

Note 898244 - ORA-904 with the DBMS_STATS package

you have to install the patch 4627335 or patchset 9.2.0.8 and run @?/rdbms/admin/prvtstat.plb afterwhile

Thanks

[Former Member]

Hi,

Which SAP version? Which Oracle version?

Thanks

[Former Member]

BW 3.5

Oracle 9.2.0.7