Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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:
- 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
- ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KULDEV.PUBLISH_QUEUE_ARCHIVE) violated
- at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:308)
- at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:111)
- at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
- at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
- 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
- ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KULDEV.PUBLISH_QUEUE_ARCHIVE) violated
- at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
- at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)
- at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:834)
- at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:260)
- at za.org.kuali.kfs.integration.queue.QueueRepositoryImpl.archiveQueueForPublishedIds(QueueRepositoryImpl.java:110)
- at za.org.kuali.kfs.integration.queue.QueueServiceImpl.archiveQueueForPublishedIds(QueueServiceImpl.java:62)
- at za.org.kuali.kfs.integration.queue.QueueServiceImpl.republishQueues(QueueServiceImpl.java:83)
- at sun.reflect.GeneratedMethodAccessor555.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:606)
- at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
- at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:299)
- ... 3 more
- Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KULDEV.PUBLISH_QUEUE_ARCHIVE) violated
- at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
- at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
- at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
- at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
- at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
- at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
- at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
- at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
- at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
- at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
- at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
- at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
- at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
- at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
- at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)
- at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
- ... 14 more
Add Comment
Please, Sign In to add comment