My Oracle Support Banner

Receive Following Error When Creating Scheduled TN Recall Job "ORA-02291: integrity constraint (JOB.FK_JO_QU__JO_SE) violated - parent key not found" (Doc ID 1291407.1)

Last updated on MAY 14, 2018

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.15 and later
Information in this document applies to any platform.

Symptoms

Users report receiving a "ORA-02291: integrity constraint (JOB.FK_JO_QU__JO_SE) violated - parent key not found" error in the Telephone Number Recall Scheduler window when attempting to "Save and Close" a scheduled TN Recall job.

Screenshot of error




Error text

The server encountered the following Exception: java.sql.SQLException: ORA-02291: integrity constraint (JOB.FK_JO_QU__JO_SE) violated - parent key not found
   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
   at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
   at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
   at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:630)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1081)
   at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
   at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2977)
   at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:147)
   at com.metasolv.jdbc.MSVPreparedStatement.executeUpdate(MSVPreparedStatement.java:85)
   at MetaSolv.persistent.jdbc.JDSC.issueUpdate(JDSC.java:621)
   at MetaSolv.persistent.jdbc.JDSC.issueInsert(JDSC.java:716)
   at MetaSolv.persistent.jdbc.JDSC.issueInsert(JDSC.java:861)
   at com.mslv.core.api.internal.scheduler.importData.ScheduleJob.add(ScheduleJob.java:67)
   at com.mslv.ejb.scheduler.modifier.AddScheduledJobModifier.initiateModification(AddScheduledJobModifier.java:43)
   at com.mslv.ejb.MSLVSessionBean.initiateModification(MSLVSessionBean.java:771)
   at com.mslv.ejb.scheduler.TNRecallSchedulerBean.addScheduledJob(TNRecallSchedulerBean.java:87)
   at com.mslv.ejb.scheduler.TNRecall_i6jyvp_EOImpl.addScheduledJob(TNRecall_i6jyvp_EOImpl.java:154)
   at com.mslv.ejb.scheduler.TNRecall_i6jyvp_EOImpl_CBV.addScheduledJob(Unknown Source)
   at com.mslv.ejb.scheduler.TNRecallSchedulerHandler.addScheduledJob(TNRecallSchedulerHandler.java:93)
   at com.mslv.webapp.scheduler.action.LaunchJobCriteria.saveJob(LaunchJobCriteria.java:816)
   at com.mslv.webapp.scheduler.action.LaunchJobCriteria.perform(LaunchJobCriteria.java:181)
   at org.apache.struts.action.Action.execute(Action.java:420)
   at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
   at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
   at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
   at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
   at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
   at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
   at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348)
   at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6981)
   at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
   at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
   at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
   at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
   at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
   at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.