Getting this error: ORA-12012: error on auto execute of job 9

Products

• CA Business Service Insight

Issue/Introduction

You start to get this error:

ORA-12012: error on auto execute of job 9 

ORA-02289: sequence does not exist 

ORA-06512: at "OBLICORE.PART_MNG_PKG", line 16 

ORA-06512: at "OBLICORE.PART_MNG_PKG", line 440 

ORA-02289: sequence does not exist 

ORA-01403: no data found 

 

Environment

Release:
Component: OBLCRE

Cause

It’s trying to run one of the scheduled jobs and the job is not created properly. Normally this gets created during the install as long as the Oracle job scheduling service is installed. It may be that they only added the service after the fact or something went wrong during the job creation.

Resolution

You should be able to recreate it from the installation media (it’s a simple job that then reads a table for what to clear, but the job is always there).

 

Run: Select * from user_jobs;

To see the job.

Please make sure:

1. The database package Part_Mng_Pkg is compiled.

2. The raw data job exists, scheduled and unbroken

 

The job can be recognized by What= Part_Mng_Pkg.G_TABLE_NAME :='T_RAW_DATA';Part_Mng_Pkg.raw_data_purge;

Additional Information

The Part_Mng_Pkg.sql can be found under the DVD:

DVD:\SetupDB\InstallDB\Build_Schema\Packages