ORA-12012: error on auto execute of job SYS.BSLN_MAINTAIN

#Error Message Errors in file /u01/app/oracle/diag/rdbms/dcl/DC1/trace/DC1_j008_6097.trc: ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-06502: PL/SQL: numeric or value error ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073 ORA-06512: at line 1

Cause:
This is because, the table DBSNMP.BSLN_BASELINES contains one of the schedule maintenance tasks which has invalid values. 

Solution: To get the status of failed execution attempts of the job: SQL> select log_date,status from dba_scheduler_job_run_details where job_name='BSLN_MAINTAIN_STATS_JOB';      LOG_DATE                              STATUS ------------------------------------- -------- 06-DEC-14 11.00.05.595559 PM -06:00   FAILED 18-DEC-14 11.00.06.554385 PM -06:00   FAILED 23-NOV-13 11.01.05.966337 PM -06:00   FAILED 02-MAY-16 03.36.50.995888 PM -06:00   FAILED 4 rows selected. #Look for the values on the table. Also detect the invalid values and remove them. SQL> select * from DBSNMP.BSLN_BASELINES;       DBID INSTANCE_NAME BASELINE_ID BSLN_GUID                        TI A STATUS LAST_COMPUT ---------- ------------- ----------- -------------------------------- -- - ------ ----------- 3038864366 dcl                     0 0A03A0424F06F7E6B3841C6CC0999F7C NW N ACTIVE 131027:0000 3038864366 DC1                     0 176C36D62D62855075AD0BBD90B2DA30 ND Y ACTIVE 131228:2300 3038864366 DC2                     0 A396EEB2AB3A39AF477DC4A1AEE70CC9 ND Y ACTIVE 131228:2300 #You must know exactly which row you're deleting. Use DELETE command to remove corrupted row: SQL> DELETE FROM DBSNMP.BSLN_BASELINES WHERE INSTANCE_NAME ='dc1'; 1 row deleted. SQL> commit; Commit complete. #Manually re-execute the job and check the execution log, it must show the job executed successfully.  It takes a couple of minutes after execution to show the results in the log table. SQL> exec dbms_scheduler.run_job('BSLN_MAINTAIN_STATS_JOB',false); PL/SQL procedure successfully completed. #Execute below command to get the status of execution attempts of the job. SQL> select log_date,status from dba_scheduler_job_run_details where job_name='BSLN_MAINTAIN_STATS_JOB';      LOG_DATE                              STATUS ------------------------------------- --------- 06-DEC-14 11.00.05.595559 PM -06:00   FAILED 18-DEC-14 11.00.06.554385 PM -06:00   FAILED 23-NOV-13 11.01.05.966337 PM -06:00   FAILED 02-MAY-16 03.36.50.995888 PM -06:00   FAILED 02-MAY-16 03.41.20.714453 PM -06:00   SUCCEEDED

Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get next blog updates !