Error on Sync for Analytics Pluss

Error on Sync for Analytics Pluss


We recently upgraded the Service Desk.  At that time the password was missing for Analytics.  That was put back and the system was asked to sync.  Now have had another complaint on no new data and I see the error above.


FAILURE :We are sorry to inform you that data Synchronization is failed.
Data have not been completely synchronized in ManageEngine Analytics Plus due to an unknown error.
Please find the root cause referring the logs under SDP_HOME\zreports\uploadtool\logs

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.

File contents.  I could not attach


2017/06/07 23:04:23 EDT:####################  ERROR OCCURRED WHILE USING UpladFromDB Tool ####################

2017/06/07 23:04:23 EDT:Query Node :: <Query dbname="ME ServiceDesk Plus MSP Analytics" id="601" importtype="TRUNCATEADD" matchingcols="SRequestID" selectcols="" skiptop="" tablename="SR Facilities / Maintenance Custom Fields">SELECT "ServiceReq_1501"."UDF_CHAR2" AS "Facility", "ServiceReq_1501"."WORKORDERID" AS "SRequestID", "WorkOrder"."CREATEDTIME" AS "Request Created Time"  FROM "ServiceReq_1501" LEFT JOIN "WorkOrder" ON "ServiceReq_1501"."WORKORDERID"="WorkOrder"."WORKORDERID" where Workorder.WORKORDERID is not null and WorkOrder.CREATEDTIME&gt;=1420139400000</Query>

2017/06/07 23:04:23 EDT:Error is :: null

2017/06/07 23:04:23 EDT:More Information :: ServerException (HttpStatusCode 400 Error Code: 400 , URI: , Action: , Message: )
 at com.zoho.client.report.BaseClient.sendRequest(BaseClient.java:156)
 at com.zoho.client.report.ReportClient.sendRequest(ReportClient.java:2229)
 at com.zoho.client.report.ReportClient.sendImportRequest(ReportClient.java:2073)
 at com.zoho.client.report.ReportClient.importTblData(ReportClient.java:2056)
 at com.zoho.client.report.ReportClient.importDataInBatches(ReportClient.java:1827)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.uploadData(ZOHOReportUploadDataFromDB.java:962)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:822)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:575)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.main(ZOHOReportUploadDataFromDB.java:160)

2017/06/07 23:04:23 EDT:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2017/06/07 23:04:23 EDT:Query Node :: <Query dbname="ME ServiceDesk Plus MSP Analytics" id="602" importtype="TRUNCATEADD" matchingcols="SRequestID" selectcols="" skiptop="" tablename="SR Finance / Claims Custom Fields">SELECT "ServiceReq_1201"."UDF_CHAR3" AS "Denial Reason", "ServiceReq_1201"."UDF_CHAR2" AS "Provider", "ServiceReq_1201"."WORKORDERID" AS "SRequestID", "WorkOrder"."CREATEDTIME" AS "Request Created Time"  FROM "ServiceReq_1201" LEFT JOIN "WorkOrder" ON "ServiceReq_1201"."WORKORDERID"="WorkOrder"."WORKORDERID" where Workorder.WORKORDERID is not null and WorkOrder.CREATEDTIME&gt;=1420139400000</Query>

2017/06/07 23:04:23 EDT:Error is :: null

2017/06/07 23:04:23 EDT:More Information :: ServerException (HttpStatusCode 400 Error Code: 400 , URI: , Action: , Message: )
 at com.zoho.client.report.BaseClient.sendRequest(BaseClient.java:156)
 at com.zoho.client.report.ReportClient.sendRequest(ReportClient.java:2229)
 at com.zoho.client.report.ReportClient.sendImportRequest(ReportClient.java:2073)
 at com.zoho.client.report.ReportClient.importTblData(ReportClient.java:2056)
 at com.zoho.client.report.ReportClient.importDataInBatches(ReportClient.java:1827)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.uploadData(ZOHOReportUploadDataFromDB.java:962)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:822)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:575)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.main(ZOHOReportUploadDataFromDB.java:160)

2017/06/07 23:04:23 EDT:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2017/06/07 23:04:46 EDT:
============================================================================================================================================
2017/06/26 12:04:42 EDT:####################  ERROR OCCURRED WHILE USING UpladFromDB Tool ####################

2017/06/26 12:04:42 EDT:Query Node :: <Query dbname="ME ServiceDesk Plus MSP Analytics" id="601" importtype="TRUNCATEADD" matchingcols="SRequestID" selectcols="" skiptop="" tablename="SR Facilities / Maintenance Custom Fields">SELECT "ServiceReq_1501"."UDF_CHAR2" AS "Facility", "ServiceReq_1501"."WORKORDERID" AS "SRequestID", "WorkOrder"."CREATEDTIME" AS "Request Created Time"  FROM "ServiceReq_1501" LEFT JOIN "WorkOrder" ON "ServiceReq_1501"."WORKORDERID"="WorkOrder"."WORKORDERID" where Workorder.WORKORDERID is not null and WorkOrder.CREATEDTIME&gt;=1420088400000</Query>

2017/06/26 12:04:42 EDT:Error is :: null

2017/06/26 12:04:42 EDT:More Information :: ServerException (HttpStatusCode 400 Error Code: 400 , URI: , Action: , Message: )
 at com.zoho.client.report.BaseClient.sendRequest(BaseClient.java:156)
 at com.zoho.client.report.ReportClient.sendRequest(ReportClient.java:2229)
 at com.zoho.client.report.ReportClient.sendImportRequest(ReportClient.java:2073)
 at com.zoho.client.report.ReportClient.importTblData(ReportClient.java:2056)
 at com.zoho.client.report.ReportClient.importDataInBatches(ReportClient.java:1827)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.uploadData(ZOHOReportUploadDataFromDB.java:962)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:822)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:575)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.main(ZOHOReportUploadDataFromDB.java:160)

2017/06/26 12:04:42 EDT:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2017/06/26 12:04:43 EDT:Query Node :: <Query dbname="ME ServiceDesk Plus MSP Analytics" id="602" importtype="TRUNCATEADD" matchingcols="SRequestID" selectcols="" skiptop="" tablename="SR Finance / Claims Custom Fields">SELECT "ServiceReq_1201"."UDF_CHAR3" AS "Denial Reason", "ServiceReq_1201"."UDF_CHAR2" AS "Provider", "ServiceReq_1201"."WORKORDERID" AS "SRequestID", "WorkOrder"."CREATEDTIME" AS "Request Created Time"  FROM "ServiceReq_1201" LEFT JOIN "WorkOrder" ON "ServiceReq_1201"."WORKORDERID"="WorkOrder"."WORKORDERID" where Workorder.WORKORDERID is not null and WorkOrder.CREATEDTIME&gt;=1420088400000</Query>

2017/06/26 12:04:43 EDT:Error is :: null

2017/06/26 12:04:43 EDT:More Information :: ServerException (HttpStatusCode 400 Error Code: 400 , URI: , Action: , Message: )
 at com.zoho.client.report.BaseClient.sendRequest(BaseClient.java:156)
 at com.zoho.client.report.ReportClient.sendRequest(ReportClient.java:2229)
 at com.zoho.client.report.ReportClient.sendImportRequest(ReportClient.java:2073)
 at com.zoho.client.report.ReportClient.importTblData(ReportClient.java:2056)
 at com.zoho.client.report.ReportClient.importDataInBatches(ReportClient.java:1827)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.uploadData(ZOHOReportUploadDataFromDB.java:962)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:822)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:575)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.main(ZOHOReportUploadDataFromDB.java:160)

2017/06/26 12:04:43 EDT:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2017/06/26 12:05:07 EDT:
============================================================================================================================================
2017/06/26 12:10:49 EDT:####################  ERROR OCCURRED WHILE USING UpladFromDB Tool ####################

2017/06/26 12:10:49 EDT:Query Node :: <Query dbname="ME ServiceDesk Plus MSP Analytics" id="601" importtype="TRUNCATEADD" matchingcols="SRequestID" selectcols="" skiptop="" tablename="SR Facilities / Maintenance Custom Fields">SELECT "ServiceReq_1501"."UDF_CHAR2" AS "Facility", "ServiceReq_1501"."WORKORDERID" AS "SRequestID", "WorkOrder"."CREATEDTIME" AS "Request Created Time"  FROM "ServiceReq_1501" LEFT JOIN "WorkOrder" ON "ServiceReq_1501"."WORKORDERID"="WorkOrder"."WORKORDERID" where Workorder.WORKORDERID is not null and WorkOrder.CREATEDTIME&gt;=1420088400000</Query>

2017/06/26 12:10:49 EDT:Error is :: null

2017/06/26 12:10:49 EDT:More Information :: ServerException (HttpStatusCode 400 Error Code: 400 , URI: , Action: , Message: )
 at com.zoho.client.report.BaseClient.sendRequest(BaseClient.java:156)
 at com.zoho.client.report.ReportClient.sendRequest(ReportClient.java:2229)
 at com.zoho.client.report.ReportClient.sendImportRequest(ReportClient.java:2073)
 at com.zoho.client.report.ReportClient.importTblData(ReportClient.java:2056)
 at com.zoho.client.report.ReportClient.importDataInBatches(ReportClient.java:1827)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.uploadData(ZOHOReportUploadDataFromDB.java:962)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:822)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:575)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.main(ZOHOReportUploadDataFromDB.java:160)

2017/06/26 12:10:49 EDT:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2017/06/26 12:10:49 EDT:Query Node :: <Query dbname="ME ServiceDesk Plus MSP Analytics" id="602" importtype="TRUNCATEADD" matchingcols="SRequestID" selectcols="" skiptop="" tablename="SR Finance / Claims Custom Fields">SELECT "ServiceReq_1201"."UDF_CHAR3" AS "Denial Reason", "ServiceReq_1201"."UDF_CHAR2" AS "Provider", "ServiceReq_1201"."WORKORDERID" AS "SRequestID", "WorkOrder"."CREATEDTIME" AS "Request Created Time"  FROM "ServiceReq_1201" LEFT JOIN "WorkOrder" ON "ServiceReq_1201"."WORKORDERID"="WorkOrder"."WORKORDERID" where Workorder.WORKORDERID is not null and WorkOrder.CREATEDTIME&gt;=1420088400000</Query>

2017/06/26 12:10:49 EDT:Error is :: null

2017/06/26 12:10:49 EDT:More Information :: ServerException (HttpStatusCode 400 Error Code: 400 , URI: , Action: , Message: )
 at com.zoho.client.report.BaseClient.sendRequest(BaseClient.java:156)
 at com.zoho.client.report.ReportClient.sendRequest(ReportClient.java:2229)
 at com.zoho.client.report.ReportClient.sendImportRequest(ReportClient.java:2073)
 at com.zoho.client.report.ReportClient.importTblData(ReportClient.java:2056)
 at com.zoho.client.report.ReportClient.importDataInBatches(ReportClient.java:1827)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.uploadData(ZOHOReportUploadDataFromDB.java:962)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:822)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:575)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.main(ZOHOReportUploadDataFromDB.java:160)

2017/06/26 12:10:49 EDT:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2017/06/26 12:11:13 EDT:
============================================================================================================================================
2017/07/06 13:58:11 EDT:####################  ERROR OCCURRED WHILE USING UpladFromDB Tool ####################

2017/07/06 13:58:11 EDT:Query Node :: <Query dbname="ME ServiceDesk Plus MSP Analytics" id="601" importtype="TRUNCATEADD" matchingcols="SRequestID" selectcols="" skiptop="" tablename="SR Facilities / Maintenance Custom Fields">SELECT "ServiceReq_1501"."UDF_CHAR2" AS "Facility", "ServiceReq_1501"."WORKORDERID" AS "SRequestID", "WorkOrder"."CREATEDTIME" AS "Request Created Time"  FROM "ServiceReq_1501" LEFT JOIN "WorkOrder" ON "ServiceReq_1501"."WORKORDERID"="WorkOrder"."WORKORDERID" where Workorder.WORKORDERID is not null and WorkOrder.CREATEDTIME&gt;=1420088400000</Query>

2017/07/06 13:58:11 EDT:Error is :: null

2017/07/06 13:58:11 EDT:More Information :: ServerException (HttpStatusCode 400 Error Code: 400 , URI: , Action: , Message: )
 at com.zoho.client.report.BaseClient.sendRequest(BaseClient.java:156)
 at com.zoho.client.report.ReportClient.sendRequest(ReportClient.java:2229)
 at com.zoho.client.report.ReportClient.sendImportRequest(ReportClient.java:2073)
 at com.zoho.client.report.ReportClient.importTblData(ReportClient.java:2056)
 at com.zoho.client.report.ReportClient.importDataInBatches(ReportClient.java:1827)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.uploadData(ZOHOReportUploadDataFromDB.java:962)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:822)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:575)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.main(ZOHOReportUploadDataFromDB.java:160)

2017/07/06 13:58:11 EDT:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2017/07/06 13:58:11 EDT:Query Node :: <Query dbname="ME ServiceDesk Plus MSP Analytics" id="602" importtype="TRUNCATEADD" matchingcols="SRequestID" selectcols="" skiptop="" tablename="SR Finance / Claims Custom Fields">SELECT "ServiceReq_1201"."UDF_CHAR3" AS "Denial Reason", "ServiceReq_1201"."UDF_CHAR2" AS "Provider", "ServiceReq_1201"."WORKORDERID" AS "SRequestID", "WorkOrder"."CREATEDTIME" AS "Request Created Time"  FROM "ServiceReq_1201" LEFT JOIN "WorkOrder" ON "ServiceReq_1201"."WORKORDERID"="WorkOrder"."WORKORDERID" where Workorder.WORKORDERID is not null and WorkOrder.CREATEDTIME&gt;=1420088400000</Query>

2017/07/06 13:58:11 EDT:Error is :: null

2017/07/06 13:58:11 EDT:More Information :: ServerException (HttpStatusCode 400 Error Code: 400 , URI: , Action: , Message: )
 at com.zoho.client.report.BaseClient.sendRequest(BaseClient.java:156)
 at com.zoho.client.report.ReportClient.sendRequest(ReportClient.java:2229)
 at com.zoho.client.report.ReportClient.sendImportRequest(ReportClient.java:2073)
 at com.zoho.client.report.ReportClient.importTblData(ReportClient.java:2056)
 at com.zoho.client.report.ReportClient.importDataInBatches(ReportClient.java:1827)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.uploadData(ZOHOReportUploadDataFromDB.java:962)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:822)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.parseXMLAndImportData(ZOHOReportUploadDataFromDB.java:575)
 at com.zoho.client.report.tool.ZOHOReportUploadDataFromDB.main(ZOHOReportUploadDataFromDB.java:160)

2017/07/06 13:58:11 EDT:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2017/07/06 13:58:37 EDT:
============================================================================================================================================





                New to ADSelfService Plus?