DB13 - 'Analayze Tables' job gets errors

[Former Member]

How do I fix the following errors when running the DB13 job Analyze Statistics:

BR0301E SQL error -1 at location stats_tab_collect-20

ORA-00001: unique constraint (SAPR3.DBSTATTORA0) violated

BR0886E Checking/collecting statistics failed for table SAPR3.GLPCT

Oracle 9.2.0.7

Kernel release 46D

OS: HP Tru64

Thanks in advance.

[Former Member · Accepted solution]

Go to transaction SM37 and check whether there were two jobs with name DBA:CHECKDB* running at the same time, maybe from two different users.

[Former Member · Accepted solution]

All the DBA jobs are run by one user.

The job ANALYZETAB is onlt run by one user.

The job ANALYZETAB fails with the errors, the other jobs run okay.

[former_member524429 · Accepted solution]

Hi,

Do the following:

SVRMGR> connect internal
SVRMGR> delete from sapr3.dbstattora;
SVRMGR> commit

After executing the above commands , re-run that DB Statistic Job from DB13. The contents of the table dbstattora will be created again.

Please refer SAP Note 421697 and 458872 to get more detailed information.

Regards,

Bhavik G. Shroff