When Predictive Diagnostic feature is enabled, the following errors are found in Oracle ALERT LOG
ORA-12012: error on auto execute of job <job_id>
ORA-02291: integrity constraint (QUEST.SYS_C<auto_gen_id>) violated - parent key not found
ORA-06512: at "QUEST.QUEST_PPCM_SNAPSHOT_PKG", line 903
ORA-06512: at "QUEST.QUEST_PPCM_SNAPSHOT_PKG", line 1032
ORA-06512: at "QUEST.QUEST_PPCM_SNAPSHOT_PKG", line 1040
Product defect.
WORKAROUND 1:
Disable the Oracle job.
1. Go to File | Oracle User Wizard. Follow through the wizard until the "Setting Predictive Diagnostics" screen is reached.
2. Set both intervals (SQL Performance Collection and Bottleneck Collection interval) to zero. A warning is displayed, and click Next up to the end of the wizard. Refer to attached screenshot1.
Note : This will prevent the error in the alert.log. The predictive diagnostic feature will be disabled, and the Spotlight console shows an alarm regarding non-running job in the predictive diagnostics component screen.
WORKAROUND 2:
1. Drop the Spotlight on Oracle user.
2. Go to File | Oracle User Wizard to create a new user
3. Answer "No" to 'Do you want Predictive Diagnostics?', which will disable the feature.
STATUS:
Waiting for fix in a future release of Spotlight on Oracle.
To confirm that this is due to Predictive Diagnostic:
Run this query:
select * from user_jobs where job=<job_id>;
The result should indicate the following:
BEGIN /*Quest SOO PPCM job */ quest_ppcm_snapshot_pkg.take_snapshot; END;
