SD6.0 + MSSQL + Russian - Errors

SD6.0 + MSSQL + Russian - Errors

Windows XP Pro Russian
AdventNet_ManageEngine_ServiceDesk_Feb_02_2007_windows.exe
MSSQL2005 Developer Edition English

In C:\AdventNet\ME\ServiceDesk\server\default\log\serverout*.txt I have lot of cycled errors like this:


[12:25:36:070]|[02-09-2007]|[com.adventnet.workengine.scheduler.internal.RefreshController]|[SEVERE]|[17]|: |com.adventnet.persistence.DataAccessException: java.sql.SQLException: Conversion failed when converting datetime from character string.
...




The java.exe process eat 100% of processor all the time.

In MSSQL Profiler I see cycled group of sql-requests:

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 < '09-���-2007 12:44:51 PM')) AND (Scheduled_WorkFlow.ADMIN_STATUS = 3)) AND
(Scheduled_WorkFlow.OPERATIONAL_STATUS = 3)) AND (Task_Input.SCHEDULE_TIME IS NOT NULL))










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 < '09-���-2007 12:44:51 PM')) AND (Scheduled_WorkFlow.ADMIN_STATUS = 3)) AND
(Scheduled_WorkFlow.OPERATIONAL_STATUS = 3)) AND (Task_Input.SCHEDULE_TIME IS NOT NULL))










SELECT AdventNetErrorCode.ERRORCODE FROM AdventNetErrorCode, MssqlErrorCode WHERE
MssqlErrorCode.ADVERRORCODE=AdventNetErrorCode.ERRORCODE AND MssqlErrorCode.ERRORCODE=241




SELECT AdventNetErrorCode.ERRORCODE FROM AdventNetErrorCode, MssqlErrorCode WHERE
MssqlErrorCode.ADVERRORCODE=AdventNetErrorCode.ERRORCODE AND MssqlErrorCode.ERRORCODE=241




IF @@TRANCOUNT > 0 COMMIT TRAN



The '09-���-2007 12:44:51 PM' in russian means 9-feb-2007.
















                  New to ADSelfService Plus?