Error of datatime conversion
The CPU of our server is at 100% because of msql & Java. The probl�me seems to come from an error of datatime conversion see below:
SELECT Task_Input.INSTANCE_ID,Task_Input.SCHEDULE_ID,Task_Input.WORKFLOW_TEMPLATE_ID,Task_Input.SCHEDULE_TIME,Task_Input.EXECUTION_START_TIME,Task_Input.EXECUTION_FINISH_TIME,Task_Input.WORKENGINE_ID,Task_Input.ADMIN_STATUS,Task_Input.OPERATIONAL_STATUS,Task_Input.SERVER_ID,Task_Input.CRID FROM Task_Input INNER JOIN Scheduled_WorkFlow ON Task_Input.SCHEDULE_ID=Scheduled_WorkFlow.SCHEDULE_ID AND Task_Input.WORKFLOW_TEMPLATE_ID=Scheduled_WorkFlow.WORKFLOW_TEMPLATE_ID LEFT JOIN Default_Task_Input ON Task_Input.INSTANCE_ID=Default_Task_Input.INSTANCE_ID WHERE ((((((((Task_Input.WORKENGINE_ID IN (1,1,2,2,3,3,4,4,1,2,3,4)) AND (Task_Input.SERVER_ID = -1)) AND (Task_Input.ADMIN_STATUS = 3)) AND (Task_Input.OPERATIONAL_STATUS = 3)) AND (Task_Input.SCHEDULE_TIME < '03-Jan-2008 05:48:29 PM')) AND (Scheduled_WorkFlow.ADMIN_STATUS = 3)) AND (Scheduled_WorkFlow.OPERATIONAL_STATUS = 3)) AND (Task_Input.SCHEDULE_TIME IS NOT NULL))
Erreur de syntaxe lors de la conversion d'une valeur datetime � partir d'une cha�ne de caract�res. (Traduction: Syntax error in the conversion of a datetime value from a string)
SELECT Task_Input.INSTANCE_ID,Task_Input.SCHEDULE_ID,Task_Input.WORKFLOW_TEMPLATE_ID,Task_Input.SCHEDULE_TIME,Task_Input.EXECUTION_START_TIME,Task_Input.EXECUTION_FINISH_TIME,Task_Input.WORKENGINE_ID,Task_Input.ADMIN_STATUS,Task_Input.OPERATIONAL_STATUS,Task_Input.SERVER_ID,Task_Input.CRID FROM Task_Input INNER JOIN Scheduled_WorkFlow ON Task_Input.SCHEDULE_ID=Scheduled_WorkFlow.SCHEDULE_ID AND Task_Input.WORKFLOW_TEMPLATE_ID=Scheduled_WorkFlow.WORKFLOW_TEMPLATE_ID LEFT JOIN Default_Task_Input ON Task_Input.INSTANCE_ID=Default_Task_Input.INSTANCE_ID WHERE ((((((((Task_Input.WORKENGINE_ID IN (1,1,2,2,3,3,4,4,1,2,3,4)) AND (Task_Input.SERVER_ID = -1)) AND (Task_Input.ADMIN_STATUS = 3)) AND (Task_Input.OPERATIONAL_STATUS = 3)) AND (Task_Input.SCHEDULE_TIME < '03-Jan-2008 05:48:29 PM')) AND (Scheduled_WorkFlow.ADMIN_STATUS = 3)) AND (Scheduled_WorkFlow.OPERATIONAL_STATUS = 3)) AND (Task_Input.SCHEDULE_TIME IS NOT NULL))
Erreur de syntaxe lors de la conversion d'une valeur datetime � partir d'une cha�ne de caract�res. (Traduction: Syntax error in the conversion of a datetime value from a string)