on 03-22-2010 3:42 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.