Update optimizer statistics is failed with RC:0005 for cehfvssm

[Former Member]

we are getting the below log from DB14 for ECC system for the BR command brconnect -u .... -c -f stats -t ALL.

=================================

BR0301E SQL error -1410 in thread 1 at location stats_tab_collect-20, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"EDI40"', ESTIMATE_PERCENT => 1, METHOD_OPT => 'FOR ALL COLUMNS SIZE

ORA-01410: invalid ROWID

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

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

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for table SAPSR3.EDI40

======================================================

Please help me to find the solution.

[sunny_pahuja2 · Accepted solution]

Hi,

Check SAP Note 633914 - Error when executing DBMS_STATS and point number 3 in this note.

Thanks

Sunny

[Former Member · Accepted solution]

Hi,

We also had similar kind of issue fortunately it was Training system. It was corrupt block in our case as per note 633914 (As Sunny suggested). We identified the corrupt table, truncated it and deallocated the space.. Run DBCHECK on the data file just to check if the corruption exists.

[Former Member]

Hello,

Looks like stats job was run on table EDI40 when it was being used by another process. Please make sure no other process is using this table and run the stats again.

Thanks,

Siva Kumar