error on dbms_job

[ams-jamali]

hi,
when i set dbms_job to execute statspack.snap it throws following err.
if i run manually it works.

ORA-12012: error on auto execute of job 70
ORA-00001: unique constraint (PERFSTAT.STATS$UNDOSTAT_PK) violated
ORA-06512: at "PERFSTAT.STATSPACK", line 2228
ORA-06512: at "PERFSTAT.STATSPACK", line 91
ORA-06512: at line 1

how to overcome,pls help

thanks.

[davey23uk]

whats in your job

[ams-jamali]

i set statspact to execute at 7am

begin
DBMS_JOB.SUBMIT ( :jobno , 'statspack.snap;', trunc(sysdate+7/24), 'sysdate+1' );
commit;
end;

when the time comes it throws err in log file. The same code i can run in my personal pc.

Thanks.

[PAVB]

The same code i can run in my personal pc.

Just to be sure, is your personal PC acting as a client of the database where STATSPACK is failing or you have a local test database in you personal PC?

[ams-jamali]

No, my personal PC not acting as client to test database.It fails in testDB so i tried that in my local PC(both are separate DB).

[davey23uk]

so you have a messed up statspack install, re-install it

[ams-jamali]

if i had messed up it should not work when i run statspack manually.
ok i will re-install it.,