topic Error creating task in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-creating-task/m-p/186029#M139159 <HTML><HEAD></HEAD><BODY><SPAN>Hello.</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>We are using sqlserver as the back end database and upon the application launching the process are deployed correctly to the database.</SPAN><BR /><BR /><SPAN>In the java code we are running the below lines of code to kick off a simple process.</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />Map&lt;String, Object&gt; variables = new HashMap&lt;String, Object&gt;();<BR />variables.put("record_id", 100);<BR />variables.put("table_name", "Asset");<BR />RuntimeService runtimeService = ProcessEngines.getDefaultProcessEngine().getRuntimeService();<BR />ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("testProcess", variables);<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Upon the last line running the below error is shown in the logs and the process is not started.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />### Error updating database.&nbsp; Cause: java.sql.SQLException: Only dates between January 1, 1753 and December 31, 9999 are accepted.<BR />### The error may involve org.activiti.engine.impl.persistence.entity.TaskEntity.insertTask-Inline<BR />### The error occurred while setting parameters<BR />### SQL: insert into ACT_RU_TASK (ID_, REV_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, PRIORITY_, CREATE_TIME_, OWNER_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ASSIGNEE_, DELEGATION_, EXECUTION_ID_, PROC_INST_ID_, PROC_DEF_ID_, TASK_DEF_KEY_, DUE_DATE_, CATEGORY_, SUSPENSION_STATE_, TENANT_ID_, FORM_KEY_)&nbsp;&nbsp;&nbsp;&nbsp; values (?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<BR />### Cause: java.sql.SQLException: Only dates between January 1, 1753 and December 31, 9999 are accepted.<BR />…<BR />…<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Can anyone be of assistance working out why the process cannot be started?</SPAN><BR /><BR /><SPAN>Cheers</SPAN><BR /><BR /><SPAN>Tony</SPAN></BODY></HTML> Mon, 17 Nov 2014 05:10:10 GMT tonydilger 2014-11-17T05:10:10Z Error creating task https://connect.hyland.com/t5/alfresco-archive/error-creating-task/m-p/186029#M139159 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 Mon, 17 Nov 2014 05:10:10 GMT https://connect.hyland.com/t5/alfresco-archive/error-creating-task/m-p/186029#M139159 tonydilger 2014-11-17T05:10:10Z Re: Error creating task https://connect.hyland.com/t5/alfresco-archive/error-creating-task/m-p/186030#M139160 <HTML><HEAD></HEAD><BODY><SPAN>Hi Tony,</SPAN><BR /><BR /><CODE><BR />### Cause: java.sql.SQLException: Only dates between January 1, 1753 and December 31, 9999 are accepted.<BR /></CODE><BR /><SPAN>One of the dates is wrong (CREATE_TIME,DUE_DATE). Did you try to debug it to find which of the dates it is? After that it should be easier to find the reason why is it so.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Wed, 19 Nov 2014 07:45:27 GMT https://connect.hyland.com/t5/alfresco-archive/error-creating-task/m-p/186030#M139160 martin_grofcik 2014-11-19T07:45:27Z