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

book

Article ID: 4243

calendar_today

Updated On:

Products

OBLICORE GUARANTEE

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 

 

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.

Environment

Release:
Component: OBLCRE

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