2018-10-23 11:05:09.687+0530 [info] 2018-10-23 11:05:09.687+0530 [info] Order createDailyPlan - Protocol starts in C:/ProgramData/sos-berlin.com/jobscheduler/ka0054_4444/logs/order.sos,dailyplan,CreateDailyPlan.createDailyPlan.log 2018-10-23 10:47:39.838+0530 [info] SCHEDULER-891 Configuration file 'C:/ProgramData/sos-berlin.com/jobscheduler/ka0054_4444/config/live/sos/dailyplan/CreateDailyPlan,createDailyPlan.order.xml' (2018-10-23 05:11:04.000+0530) is going to be be loaded into this new Standing_order 2018-10-23 10:47:42.112+0530 [info] SCHEDULER-938 Order will be processed at 2018-10-23 18:31:00.000Z 2018-10-23 10:47:42.112+0530 [info] SCHEDULER-893 Standing_order is 'active' now 2018-10-23 11:05:09.703+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) SCHEDULER-842 Task is going to process Order sos/dailyplan/CreateDailyPlan:createDailyPlan, state=Create, on JobScheduler 'http://DESKTOP-K55VAR2:40444', Order's Process_class 2018-10-23 11:05:09.718+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) 2018-10-23 11:05:09.718+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) Task sos/dailyplan/CreateDailyPlan:8368 - Protocol starts in C:/ProgramData/sos-berlin.com/jobscheduler/ka0054_4444/logs/task.sos,dailyplan,CreateDailyPlan.log 2018-10-23 11:05:09.728+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) SCHEDULER-726 Task runs on this JobScheduler 'http://DESKTOP-K55VAR2:40444' 2018-10-23 11:05:09.728+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) SCHEDULER-918 state=starting (at=never) 2018-10-23 11:05:11.824+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] 23 11:05:10.836 [INFO ] (JobSchedulerJobAdapter.java:82) - 1.12.7-SNAPSHOT (2018-10-22 23:27, revision 053775081dcf686fac8bbaaae898e37a65f2aa0b) Copyright 2003-2018 SOS GmbH Berlin 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] 23 11:05:20.873 [ERROR] (SqlExceptionHelper.java:131) - ORA-00001: unique constraint (JOBSCHEDULER.DAILY_PLAN_UNIQUE) violated 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] 23 11:05:20.889 [ERROR] (Calendar2DB.java:112) - could not execute statement: 1 ORA-00001: unique constraint (JOBSCHEDULER.DAILY_PLAN_UNIQUE) violated 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] com.sos.hibernate.exceptions.SOSHibernateQueryException: could not execute statement: 1 ORA-00001: unique constraint (JOBSCHEDULER.DAILY_PLAN_UNIQUE) violated 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] [update com.sos.jitl.dailyplan.db.DailyPlanDBItem set state='PLANNED', schedulerId=:schedulerId where state='PLANNEDFORUPDATE'][schedulerId=KA0054_4444] 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.hibernate.classes.SOSHibernateSession.executeUpdate(SOSHibernateSession.java:397) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.db.DailyPlanDBLayer.updateDailyPlanList(DailyPlanDBLayer.java:299) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.db.Calendar2DB.store(Calendar2DB.java:532) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.db.Calendar2DB.store(Calendar2DB.java:105) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.job.CreateDailyPlan.Execute(CreateDailyPlan.java:50) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.job.CreateDailyPlanJSAdapterClass.doProcessing(CreateDailyPlanJSAdapterClass.java:65) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.job.CreateDailyPlanJSAdapterClass.spooler_process(CreateDailyPlanJSAdapterClass.java:28) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:90) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:59) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:428) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:374) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.internal.StatelessSessionImpl.executeUpdate(StatelessSessionImpl.java:350) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.query.internal.AbstractProducedQuery.doExecuteUpdate(AbstractProducedQuery.java:1522) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1500) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.hibernate.classes.SOSHibernateSession.executeUpdate(SOSHibernateSession.java:392) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] ... 6 more 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (JOBSCHEDULER.DAILY_PLAN_UNIQUE) violated 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:384) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] ... 14 more 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] 23 11:05:21.174 [ERROR] (CreateDailyPlanJSAdapterClass.java:31) - could not execute statement: 1 ORA-00001: unique constraint (JOBSCHEDULER.DAILY_PLAN_UNIQUE) violated 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] com.sos.hibernate.exceptions.SOSHibernateQueryException: could not execute statement: 1 ORA-00001: unique constraint (JOBSCHEDULER.DAILY_PLAN_UNIQUE) violated 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] [update com.sos.jitl.dailyplan.db.DailyPlanDBItem set state='PLANNED', schedulerId=:schedulerId where state='PLANNEDFORUPDATE'][schedulerId=KA0054_4444] 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.hibernate.classes.SOSHibernateSession.executeUpdate(SOSHibernateSession.java:397) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.db.DailyPlanDBLayer.updateDailyPlanList(DailyPlanDBLayer.java:299) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.db.Calendar2DB.store(Calendar2DB.java:532) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.db.Calendar2DB.store(Calendar2DB.java:105) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.job.CreateDailyPlan.Execute(CreateDailyPlan.java:50) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.job.CreateDailyPlanJSAdapterClass.doProcessing(CreateDailyPlanJSAdapterClass.java:65) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.jitl.dailyplan.job.CreateDailyPlanJSAdapterClass.spooler_process(CreateDailyPlanJSAdapterClass.java:28) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:90) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:59) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:428) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:374) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.internal.StatelessSessionImpl.executeUpdate(StatelessSessionImpl.java:350) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.query.internal.AbstractProducedQuery.doExecuteUpdate(AbstractProducedQuery.java:1522) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1500) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.sos.hibernate.classes.SOSHibernateSession.executeUpdate(SOSHibernateSession.java:392) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] ... 6 more 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (JOBSCHEDULER.DAILY_PLAN_UNIQUE) violated 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:384) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204) 2018-10-23 11:05:21.190+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stdout] ... 14 more 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] com.sos.hibernate.exceptions.SOSHibernateQueryException: could not execute statement: 1 ORA-00001: unique constraint (JOBSCHEDULER.DAILY_PLAN_UNIQUE) violated 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] [update com.sos.jitl.dailyplan.db.DailyPlanDBItem set state='PLANNED', schedulerId=:schedulerId where state='PLANNEDFORUPDATE'][schedulerId=KA0054_4444] 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at com.sos.hibernate.classes.SOSHibernateSession.executeUpdate(SOSHibernateSession.java:397) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at com.sos.jitl.dailyplan.db.DailyPlanDBLayer.updateDailyPlanList(DailyPlanDBLayer.java:299) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at com.sos.jitl.dailyplan.db.Calendar2DB.store(Calendar2DB.java:532) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at com.sos.jitl.dailyplan.db.Calendar2DB.store(Calendar2DB.java:105) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at com.sos.jitl.dailyplan.job.CreateDailyPlan.Execute(CreateDailyPlan.java:50) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at com.sos.jitl.dailyplan.job.CreateDailyPlanJSAdapterClass.doProcessing(CreateDailyPlanJSAdapterClass.java:65) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at com.sos.jitl.dailyplan.job.CreateDailyPlanJSAdapterClass.spooler_process(CreateDailyPlanJSAdapterClass.java:28) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:90) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:59) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:428) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:374) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.internal.StatelessSessionImpl.executeUpdate(StatelessSessionImpl.java:350) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.query.internal.AbstractProducedQuery.doExecuteUpdate(AbstractProducedQuery.java:1522) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1500) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at com.sos.hibernate.classes.SOSHibernateSession.executeUpdate(SOSHibernateSession.java:392) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] ... 6 more 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (JOBSCHEDULER.DAILY_PLAN_UNIQUE) violated 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:384) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204) 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) [stderr] ... 14 more 2018-10-23 11:05:21.205+0530 [info] (Task sos/dailyplan/CreateDailyPlan:8368) SCHEDULER-843 Task has ended processing of Order sos/dailyplan/CreateDailyPlan:createDailyPlan, state=Create, on JobScheduler 'http://DESKTOP-K55VAR2:40444' 2018-10-23 11:05:21.205+0530 [info] set_state error 2018-10-23 11:05:21.205+0530 [info] SCHEDULER-944 End state reached - order will be repeated at 2018-10-23 18:31:00.000Z with state=Create 2018-10-23 11:05:21.205+0530 [info] SCHEDULER-962 Protocol ends in C:/ProgramData/sos-berlin.com/jobscheduler/ka0054_4444/logs/order.sos,dailyplan,CreateDailyPlan.createDailyPlan.log