Zoho Reports Sync Issue.

Error:

FAILURE: Initial data synchronization failed.

TRACE IN LOGS:

java.lang.RuntimeException: Exception occured while executing queries and uploading data
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:840)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:552)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.main(ZohoReportUploadDataFromDB.java:171)
Caused by: java.lang.RuntimeException: Exception occured while uploading data: Database not found! Please check whether the database exists in {0}.
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:822)
… 2 more
Caused by: java.lang.RuntimeException: Database not found! Please check whether the database exists in {0}.
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.uploadData(ZohoReportUploadDataFromDB.java:971)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:799)
… 2 more
Caused by: ServerException (HttpStatusCode 400 Error Code: 7103 , URI: /api/itreg@xenith.co.uk/ME%20ServiceDesk%20Plus%20MSP%20Analytics/Request, Action: IMPORT, Message: Database not found! Please check whether the database exists in {0}.)
at com.adventnet.zoho.client.report.BaseClient.sendRequest(BaseClient.java:110)
at com.adventnet.zoho.client.report.ReportClient.sendRequest(ReportClient.java:1643)
at com.adventnet.zoho.client.report.ReportClient.sendImportRequest(ReportClient.java:1533)
at com.adventnet.zoho.client.report.ReportClient.importTblData(ReportClient.java:1516)
at com.adventnet.zoho.client.report.ReportClient.importDataInBatches(ReportClient.java:1301)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.uploadData(ZohoReportUploadDataFromDB.java:938)
… 3 more

2016/07/13 19:19:13 BST:
============================================================================================================================================
2016/07/13 19:26:15 BST:#################### ERROR OCCURRED WHILE USING UpladFromDB Tool ####################

2016/07/13 19:26:15 BST:Query Node :: <Query dbname=”ME ServiceDesk Plus MSP Analytics” id=”1″ importtype=”TRUNCATEADD” matchingcols=”RequestID” selectcols=”” skiptop=””

 

CAUSE: The database name in Zoho Reports could be changed.

If it is changed please rename it back to “ME ServiceDesk Plus MSP Analytics” which will fix the issue.

 

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500