We have problem after procedure "changedbserver" from MS SQL to another MS SQL, when we launch command run service AdventNetServiceDesk have state [FAILED]. We revert previous configuration but this service again have state failed. Than we trying restore data from backup, which was created before all changes, procedure restore finished successful, but service again failed to start. The log file serverout0.log contain this information
[com.adventnet.workengine.scheduler.internal.RefreshController]|[INFO]|[16]|: taskInputs :: <WritableDataObject>
<Tables>
[] </Tables>
SelectQuery Object:
Select columnNames=[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]
Criteria=((((((((Task_Input.WORKENGINE_ID IN ('1','1','2','2','1','2')) AND (Task_Input.SERVER_ID = '-1')) AND (Task_Input.ADMIN_STATUS = '3')) AND (Task_Input.OPERATIONAL_STATUS = '3')) AND (Task_Input.SCHEDULE_TIME < '2015-05-11 22:07:50.067')) AND (Scheduled_WorkFlow.ADMIN_STATUS = '3')) AND (Scheduled_WorkFlow.OPERATIONAL_STATUS = '3')) AND (Task_Input.SCHEDULE_TIME != NULL ))
Number of Objects=0
Starting row=1
Order by columnNames=[]
Table List=[Task_Input AS Task_Input, Scheduled_WorkFlow AS Scheduled_WorkFlow]
Joins= Join := Task_Input AS Task_Input INNER JOIN Scheduled_WorkFlow AS Scheduled_WorkFlow ON Task_Input.SCHEDULE_ID=Scheduled_WorkFlow.SCHEDULE_ID AND Task_Input.WORKFLOW_TEMPLATE_ID=Scheduled_WorkFlow.WORKFLOW_TEMPLATE_ID
SetLock= false
<JoinsInDO>
Join := Task_Input AS Task_Input INNER JOIN Scheduled_WorkFlow AS Scheduled_WorkFlow ON Task_Input.SCHEDULE_ID=Scheduled_WorkFlow.SCHEDULE_ID AND Task_Input.WORKFLOW_TEMPLATE_ID=Scheduled_WorkFlow.WORKFLOW_TEMPLATE_ID
</JoinsInDO>
<Operations>
</Operations>
<Rows>
</Rows>
</WritableDataObject>
Exception while checking server status.Connection refused: connect
Can you help us to resolve this problem. Thanks in advance