A few days ago , my sdp+ can not work any more, the CPU load was very high, ereryone of us can't login SDP, So I uninstall it and reinstall a new one ,Restore data use the fullback-date that create by the SDP system 4 hours before it down.
Then, the problem was coming:
1、I can't backup data use the script "backdata.bat" in [SDPHOME]\bin, the Key ponit in the log file show that:"Unable to get the data from [ServiceReq_605] table"
2、All technicians can't merge request ,the error message:
FAILURE :Problem while trying to merge this threaded request with the selected request.
Please report the problem to the system administrator. Support file will have the error trace to analyze the problem and which can be created at Support -> Create Support File.
------------------------------------------------------------------------------------------------------------------------
And i found someone have the same problem , I follow the steps of below link:
https://forums.manageengine.com/topic/merge-request-error
After Execute the query for MSSQL, Step 1 Query output is as below:
ARC_ServiceReq_605
ServiceReq_605
After i did the rest of the steps.
The result is that:
The first problem is fixed,I can backup data use the script,~!~
But we still can't merge the request
Please refer to the Attachment,it's the support-file.
Thank you very much!