[CAM-2445] HumanTasks older than 24 days in stored in MSSQLServer lost forever

Type: Bug Report
Resolution: Cannot Reproduce
Priority: L3 - Default
Fix Version/s: None
Affects Version/s: None
Component/s: engine
Labels:
- AD
- EasyPick

When accessing HumanTasks older than 24 days stored in an Microsoft SQL Server you end up getting such an exception:

The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.. Stacktrace follows:
com.microsoft.sqlserver.jdbc.SQLServerException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.

Microsoft's DATEDIFF function returns an INT, which explains the ~ 24 days limit, cf.:

http://msdn.microsoft.com/de-de/library/ms189794.aspx

Could this be fixed by overriding/adding values to databaseSpecificDateDiff[123] in:

https://github.com/camunda/camunda-bpm-platform/blob/master/engine/src/main/java/org/camunda/bpm/engine/impl/db/DbSqlSessionFactory.java

This is the controller panel for Smart Panels app

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List
  - Download All

camunda-datediff-exception.txt
3 kB
08/Jul/14 11:31 AM

Robert Gimbel added a comment - 08/Jul/14 12:55 PM

Hi Matthias,

Thanks for your Bug Report.

We will look into this in Kontext of our 7.2 Release.

Cheers
Robert

Robert Gimbel added a comment - 08/Jul/14 12:55 PM Hi Matthias, Thanks for your Bug Report. We will look into this in Kontext of our 7.2 Release. Cheers Robert

Thorben Lindhauer added a comment - 08/Aug/14 5:18 PM

Hi Matthias,

I am not able to reproduce your problem in an isolated test case.
Furthermore, I do not know how the "datediff" function is called because the engine in its current state always uses "<" and ">" operators to compare dates.

Thus, I close this issue. Should you still have this problem, feel free to reopen the issue and please provide more details on what calls the "datediff" function or a failing test case.

Cheers,
Thorben

Thorben Lindhauer added a comment - 08/Aug/14 5:18 PM Hi Matthias, I am not able to reproduce your problem in an isolated test case. Furthermore, I do not know how the "datediff" function is called because the engine in its current state always uses "<" and ">" operators to compare dates. Thus, I close this issue. Should you still have this problem, feel free to reopen the issue and please provide more details on what calls the "datediff" function or a failing test case. Cheers, Thorben

Knut Petter Meen added a comment - 24/Oct/14 3:33 PM

Hello,

We have just encountered the same issue as well in our production environment. We are using version 7.0.0-Final. Is this problem fixed in 7.1? Or will we have to wait for version 7.2?

regards
-KP

Knut Petter Meen added a comment - 24/Oct/14 3:33 PM Hello, We have just encountered the same issue as well in our production environment. We are using version 7.0.0-Final. Is this problem fixed in 7.1? Or will we have to wait for version 7.2? regards -KP

Einar added a comment - 24/Oct/14 3:41 PM

I'm adding the stack trace from our env:

[ERROR] - 2014-10-24 09:38:46,761 -  org.camunda.bpm.engine.impl.interceptor.CommandContext: Error while closing command context
org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.
### The error may involve org.camunda.bpm.engine.impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstanceEvent_mssql-Inline
### The error occurred while setting parameters
### SQL: update ACT_HI_TASKINST set       EXECUTION_ID_ = ?,       NAME_ = ?,       PARENT_TASK_ID_ = ?,       DESCRIPTION_ = ?,       OWNER_ = ?,       ASSIGNEE_ = ?,       DELETE_REASON_ = ?,       TASK_DEF_KEY_ = ?,       PRIORITY_ = ?,       DUE_DATE_ = ?                        , END_TIME_ = ?                                                             , DURATION_ = DATEDIFF(ms, HTI.START_TIME_, ?)                       FROM        ACT_HI_TASKINST HTI                  where        ID_ = ?
### Cause: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.camunda.bpm.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:699) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:500) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:211) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:154) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49) [org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42) [org.camunda.bpm.camunda-engine-spring-7.0.0-Final.jar:na]
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) [org.springframework.spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
	at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40) [org.camunda.bpm.camunda-engine-spring-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:38) [org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:159) [org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at controllers.camunda.TaskController.complete(TaskController.java:246) [no.joint.interaxo.actionbase-services-1.2.2.jar:1.2.2]
	at Routes$$anonfun$routes$1$$anonfun$applyOrElse$105$$anonfun$apply$105.apply(routes_routing.scala:1654) [no.joint.interaxo.actionbase-services-1.2.2.jar:na]
	at Routes$$anonfun$routes$1$$anonfun$applyOrElse$105$$anonfun$apply$105.apply(routes_routing.scala:1654) [no.joint.interaxo.actionbase-services-1.2.2.jar:na]
	at play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.mvc.Security$AuthenticatedAction.call(Security.java:44) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na]
	at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at scala.concurrent.impl.Future$.apply(Future.scala:31) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.Future$.apply(Future.scala:485) [org.scala-lang.scala-library-2.10.4.jar:na]
	at play.core.j.JavaAction$class.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.utils.Threads$.withContextClassLoader(Threads.scala:21) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at scala.Option.map(Option.scala:145) [org.scala-lang.scala-library-2.10.4.jar:na]
	at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na]
	at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.10-2.3.6.jar:na]
	at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.10-2.3.6.jar:na]
	at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.10.4.jar:na]
Caused by: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	... 50 common frames omitted

[ERROR] - 2014-10-24 09:38:46,764 -  controllers.camunda.exceptions.ExceptionMapper: An exception was thrown and mapped to a UniZoneError...
org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception
	at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:193) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42) ~[org.camunda.bpm.camunda-engine-spring-7.0.0-Final.jar:na]
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) ~[org.springframework.spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
	at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40) ~[org.camunda.bpm.camunda-engine-spring-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:38) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:159) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at controllers.camunda.TaskController.complete(TaskController.java:246) ~[no.joint.interaxo.actionbase-services-1.2.2.jar:1.2.2]
	at Routes$$anonfun$routes$1$$anonfun$applyOrElse$105$$anonfun$apply$105.apply(routes_routing.scala:1654) [no.joint.interaxo.actionbase-services-1.2.2.jar:na]
	at Routes$$anonfun$routes$1$$anonfun$applyOrElse$105$$anonfun$apply$105.apply(routes_routing.scala:1654) [no.joint.interaxo.actionbase-services-1.2.2.jar:na]
	at play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.mvc.Security$AuthenticatedAction.call(Security.java:44) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na]
	at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at scala.concurrent.impl.Future$.apply(Future.scala:31) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.Future$.apply(Future.scala:485) [org.scala-lang.scala-library-2.10.4.jar:na]
	at play.core.j.JavaAction$class.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.utils.Threads$.withContextClassLoader(Threads.scala:21) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at scala.Option.map(Option.scala:145) [org.scala-lang.scala-library-2.10.4.jar:na]
	at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5]
	at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na]
	at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.10-2.3.6.jar:na]
	at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.10-2.3.6.jar:na]
	at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.10.4.jar:na]
	at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.10.4.jar:na]
Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.
### The error may involve org.camunda.bpm.engine.impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstanceEvent_mssql-Inline
### The error occurred while setting parameters
### SQL: update ACT_HI_TASKINST set       EXECUTION_ID_ = ?,       NAME_ = ?,       PARENT_TASK_ID_ = ?,       DESCRIPTION_ = ?,       OWNER_ = ?,       ASSIGNEE_ = ?,       DELETE_REASON_ = ?,       TASK_DEF_KEY_ = ?,       PRIORITY_ = ?,       DUE_DATE_ = ?                        , END_TIME_ = ?                                                             , DURATION_ = DATEDIFF(ms, HTI.START_TIME_, ?)                       FROM        ACT_HI_TASKINST HTI                  where        ID_ = ?
### Cause: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.camunda.bpm.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:699) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:500) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:211) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:154) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na]
	... 46 common frames omitted
Caused by: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1]
	... 50 common frames omitted

Einar added a comment - 24/Oct/14 3:41 PM I'm adding the stack trace from our env: [ERROR] - 2014-10-24 09:38:46,761 - org.camunda.bpm.engine.impl.interceptor.CommandContext: Error while closing command context org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart. ### The error may involve org.camunda.bpm.engine.impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstanceEvent_mssql-Inline ### The error occurred while setting parameters ### SQL: update ACT_HI_TASKINST set EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ? , END_TIME_ = ? , DURATION_ = DATEDIFF(ms, HTI.START_TIME_, ?) FROM ACT_HI_TASKINST HTI where ID_ = ? ### Cause: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.camunda.bpm.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:699) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:500) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:211) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:154) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49) [org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42) [org.camunda.bpm.camunda-engine-spring-7.0.0-Final.jar:na] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) [org.springframework.spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40) [org.camunda.bpm.camunda-engine-spring-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:38) [org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:159) [org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at controllers.camunda.TaskController.complete(TaskController.java:246) [no.joint.interaxo.actionbase-services-1.2.2.jar:1.2.2] at Routes$$anonfun$routes$1$$anonfun$applyOrElse$105$$anonfun$apply$105.apply(routes_routing.scala:1654) [no.joint.interaxo.actionbase-services-1.2.2.jar:na] at Routes$$anonfun$routes$1$$anonfun$applyOrElse$105$$anonfun$apply$105.apply(routes_routing.scala:1654) [no.joint.interaxo.actionbase-services-1.2.2.jar:na] at play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.mvc.Security$AuthenticatedAction.call(Security.java:44) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na] at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at scala.concurrent.impl.Future$.apply(Future.scala:31) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.Future$.apply(Future.scala:485) [org.scala-lang.scala-library-2.10.4.jar:na] at play.core.j.JavaAction$class.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.utils.Threads$.withContextClassLoader(Threads.scala:21) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at scala.Option.map(Option.scala:145) [org.scala-lang.scala-library-2.10.4.jar:na] at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na] at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.10-2.3.6.jar:na] at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.10-2.3.6.jar:na] at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.10.4.jar:na] Caused by: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] ... 50 common frames omitted [ERROR] - 2014-10-24 09:38:46,764 - controllers.camunda.exceptions.ExceptionMapper: An exception was thrown and mapped to a UniZoneError... org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:193) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42) ~[org.camunda.bpm.camunda-engine-spring-7.0.0-Final.jar:na] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) ~[org.springframework.spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40) ~[org.camunda.bpm.camunda-engine-spring-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:38) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:159) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at controllers.camunda.TaskController.complete(TaskController.java:246) ~[no.joint.interaxo.actionbase-services-1.2.2.jar:1.2.2] at Routes$$anonfun$routes$1$$anonfun$applyOrElse$105$$anonfun$apply$105.apply(routes_routing.scala:1654) [no.joint.interaxo.actionbase-services-1.2.2.jar:na] at Routes$$anonfun$routes$1$$anonfun$applyOrElse$105$$anonfun$apply$105.apply(routes_routing.scala:1654) [no.joint.interaxo.actionbase-services-1.2.2.jar:na] at play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.mvc.Security$AuthenticatedAction.call(Security.java:44) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na] at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at scala.concurrent.impl.Future$.apply(Future.scala:31) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.Future$.apply(Future.scala:485) [org.scala-lang.scala-library-2.10.4.jar:na] at play.core.j.JavaAction$class.apply(JavaAction.scala:82) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.utils.Threads$.withContextClassLoader(Threads.scala:21) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at scala.Option.map(Option.scala:145) [org.scala-lang.scala-library-2.10.4.jar:na] at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121) [com.typesafe.play.play_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) [com.typesafe.play.play-iteratees_2.10-2.3.5.jar:2.3.5] at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) [org.scala-lang.scala-library-2.10.4.jar:na] at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.10-2.3.6.jar:na] at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.10-2.3.6.jar:na] at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.10.4.jar:na] at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.10.4.jar:na] Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart. ### The error may involve org.camunda.bpm.engine.impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstanceEvent_mssql-Inline ### The error occurred while setting parameters ### SQL: update ACT_HI_TASKINST set EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ? , END_TIME_ = ? , DURATION_ = DATEDIFF(ms, HTI.START_TIME_, ?) FROM ACT_HI_TASKINST HTI where ID_ = ? ### Cause: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.camunda.bpm.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:699) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:500) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:211) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:154) ~[org.camunda.bpm.camunda-engine-7.0.0-Final.jar:na] ... 46 common frames omitted Caused by: java.sql.SQLException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784) ~[net.sourceforge.jtds.jtds-1.3.1.jar:1.3.1] at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145) ~[org.mybatis.mybatis-3.1.1.jar:3.1.1] ... 50 common frames omitted

Thorben Lindhauer added a comment - 24/Oct/14 3:44 PM

Hi Knut Petter,

As my previous comment states, I was not able to reproduce the problem reported in this ticket so we were not able to fix anything. If you are having this problem it would be great if you could provide a failing test case so we can reproduce it and have a look at it.

Best regards,
Thorben

Thorben Lindhauer added a comment - 24/Oct/14 3:44 PM Hi Knut Petter, As my previous comment states, I was not able to reproduce the problem reported in this ticket so we were not able to fix anything. If you are having this problem it would be great if you could provide a failing test case so we can reproduce it and have a look at it. Best regards, Thorben

Thorben Lindhauer added a comment - 24/Oct/14 3:50 PM

Hi Einar,

Thanks for the stack trace which helped me understanding the issue. It appears that the problem was fixed with ~~CAM-1346~~ which is part of 7.1.0-Final and upwards.

Cheers,
Thorben

Thorben Lindhauer added a comment - 24/Oct/14 3:50 PM Hi Einar, Thanks for the stack trace which helped me understanding the issue. It appears that the problem was fixed with CAM-1346 which is part of 7.1.0-Final and upwards. Cheers, Thorben

Einar added a comment - 24/Oct/14 3:57 PM

Great - thanks Thorben - we will upgrade to 7.1 .

Einar added a comment - 24/Oct/14 3:57 PM Great - thanks Thorben - we will upgrade to 7.1 .

Assignee:: Thorben Lindhauer

Reporter:: Matthias Schmidt

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Created:: 08/Jul/14 11:31 AM

Updated:: 24/Oct/14 3:57 PM

Resolved:: 08/Aug/14 5:18 PM

camunda BPM

Details

Description

mgm-controller-panel

This is the controller panel for Smart Panels app

Attachments

Attachments

Activity

Collapse comment: Robert Gimbel added a comment - 08/Jul/14 12:55 PM

Expand comment: Robert Gimbel added a comment - 08/Jul/14 12:55 PM

Collapse comment: Thorben Lindhauer added a comment - 08/Aug/14 5:18 PM

Expand comment: Thorben Lindhauer added a comment - 08/Aug/14 5:18 PM

Collapse comment: Knut Petter Meen added a comment - 24/Oct/14 3:33 PM

Expand comment: Knut Petter Meen added a comment - 24/Oct/14 3:33 PM

Collapse comment: Einar added a comment - 24/Oct/14 3:41 PM

Expand comment: Einar added a comment - 24/Oct/14 3:41 PM

Collapse comment: Thorben Lindhauer added a comment - 24/Oct/14 3:44 PM

Expand comment: Thorben Lindhauer added a comment - 24/Oct/14 3:44 PM

Collapse comment: Thorben Lindhauer added a comment - 24/Oct/14 3:50 PM

Expand comment: Thorben Lindhauer added a comment - 24/Oct/14 3:50 PM

Collapse comment: Einar added a comment - 24/Oct/14 3:57 PM

Expand comment: Einar added a comment - 24/Oct/14 3:57 PM

People

Dates

Salesforce