AnsweredAssumed Answered

Error creating task

Question asked by tonydilger on Nov 17, 2014
Latest reply on Nov 19, 2014 by martin.grofcik
Hello.

We've recently started implementing activiti into a spin application and everything has seemed to go quite smoothly up until the point of start a process.

We are using sqlserver as the back end database and upon the application launching the process are deployed correctly to the database.

In the java code we are running the below lines of code to kick off a simple process.


Map<String, Object> variables = new HashMap<String, Object>();
variables.put("record_id", 100);
variables.put("table_name", "Asset");
RuntimeService runtimeService = ProcessEngines.getDefaultProcessEngine().getRuntimeService();
ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("testProcess", variables);


Upon the last line running the below error is shown in the logs and the process is not started.


### Error updating database.  Cause: java.sql.SQLException: Only dates between January 1, 1753 and December 31, 9999 are accepted.
### The error may involve org.activiti.engine.impl.persistence.entity.TaskEntity.insertTask-Inline
### The error occurred while setting parameters
### SQL: insert into ACT_RU_TASK (ID_, REV_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, PRIORITY_, CREATE_TIME_, OWNER_,                       ASSIGNEE_, DELEGATION_, EXECUTION_ID_, PROC_INST_ID_, PROC_DEF_ID_, TASK_DEF_KEY_, DUE_DATE_, CATEGORY_, SUSPENSION_STATE_, TENANT_ID_, FORM_KEY_)     values (?,             1,             ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?            )
### Cause: java.sql.SQLException: Only dates between January 1, 1753 and December 31, 9999 are accepted.




Can anyone be of assistance working out why the process cannot be started?

Cheers

Tony

Outcomes