“System.AsyncException: could not store job” while scheduling job

We have a business processing where we are scheduling a job(To send welcome SMS) to be run after 2 hours when a high volume opportunity reaches a certain stage.

We are scheduling that job from the trigger. The job is running properly since last few months. Today all of a sudden that job failed with below message in Apex Job Queue

    System.AsyncException: could not store job: RunVerificationChecksInScheduler2546161332018 orgId: 00D9E0000001OFL common.exception.SqlDupValOnIndexException: ORA-00001: unique constraint (CORE.AKCRON_JOB_DETAIL) violated
ORA-06512: at "GRUMPY.UDDDMLCRONJOBDETAIL", line 32
ORA-06512: at "GRUMPY.CCRONJOBDETAIL", line 95
ORA-06512: at line 1


{call cCronJobDetail.insert_detail(?,?,?,?,?,?,?,?,?,?,?)}

{call cCronJobDetail.insert_detail(?,?,?,?,?,?,?,?,?,?,?)}
16:45:26.90 (3090828642)|FATAL_ERROR|System.AsyncException: could not store job: RunVerificationChecksInScheduler2546161332018 orgId: 00D9E0000001OFL common.exception.SqlDupValOnIndexException: ORA-00001: unique constraint (CORE.AKCRON_JOB_DETAIL) violated
ORA-06512: at "GRUMPY.UDDDMLCRONJOBDETAIL", line 32
ORA-06512: at "GRUMPY.CCRONJOBDETAIL", line 95
ORA-06512: at line 1


{call cCronJobDetail.insert_detail(?,?,?,?,?,?,?,?,?,?,?)}

{call cCronJobDetail.insert_detail(?,?,?,?,?,?,?,?,?,?,?)}

Am damm sure, it has nothing to do with Scheduler code, can anyone put some light on this. I don’t think its GACK, can someone let me know what is its root cause and how can we make sure this does not happen again.

Thanks.

Answer

Attribution
Source : Link , Question Author : Pranay Jaiswal , Answer Author : Community

Leave a Comment