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.
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>=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>=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>=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>=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>=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>=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>=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>=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:
============================================================================================================================================