mugs

Job DEFAULT.queueServiceJob threw an unhandled Exception

Jul 20th, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.45 KB | None | 0 0
  1. 2017-07-17 09:30:23,104 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-9] u:/d: ERROR org.quartz.core.JobRunShell :: Job DEFAULT.queueServiceJob threw an unhandled Exception:
  2. org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'republishQueues' on target class [class za.org.kuali.kfs.integration.queue.QueueServiceImpl] failed; nested exception is org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into PUBLISH_QUEUE_ARCHIVE (select * from publish_queue where published = 1)]; ORA-00001: unique constraint (KULDEV.PUBLISH_QUEUE_ARCHIVE) violated
  3. ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KULDEV.PUBLISH_QUEUE_ARCHIVE) violated
  4.  
  5.     at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:308)
  6.     at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:111)
  7.     at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
  8.     at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
  9. Caused by: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into PUBLISH_QUEUE_ARCHIVE (select * from publish_queue where published = 1)]; ORA-00001: unique constraint (KULDEV.PUBLISH_QUEUE_ARCHIVE) violated
  10. ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KULDEV.PUBLISH_QUEUE_ARCHIVE) violated
  11.  
  12.     at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)
  13.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  14.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
  15.     at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)
  16.     at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:834)
  17.     at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:260)
  18.     at za.org.kuali.kfs.integration.queue.QueueRepositoryImpl.archiveQueueForPublishedIds(QueueRepositoryImpl.java:110)
  19.     at za.org.kuali.kfs.integration.queue.QueueServiceImpl.archiveQueueForPublishedIds(QueueServiceImpl.java:62)
  20.     at za.org.kuali.kfs.integration.queue.QueueServiceImpl.republishQueues(QueueServiceImpl.java:83)
  21.     at sun.reflect.GeneratedMethodAccessor555.invoke(Unknown Source)
  22.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  23.     at java.lang.reflect.Method.invoke(Method.java:606)
  24.     at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
  25.     at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:299)
  26.     ... 3 more
  27. Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KULDEV.PUBLISH_QUEUE_ARCHIVE) violated
  28.  
  29.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  30.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  31.     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  32.     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  33.     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  34.     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  35.     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
  36.     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
  37.     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
  38.     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
  39.     at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
  40.     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
  41.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
  42.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
  43.     at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)
  44.     at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)
  45.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
  46.     ... 14 more
Add Comment
Please, Sign In to add comment