Unable to Sync Analytics after upgrade to 10500
Issue description:
The issue occurs when the user has upgraded from 9427 to 1050X builds and then tries the sync for the first time. The sync will fail because we are still maintaining the AMOUNT PAID column in billhistory table in sync xmls even though the column is removed from the table in the database.
So, technically for a customer who has upgraded and tried to sync, it will fail.
Resolution:
Remove the configuration (using the remove option under Analytics Page in Admin)
Navigate to PROD_HOME\zreports\sync\conf
Edit the file ZRMEModules.xml and remove the entry <column alias="Amount Paid" name="AMOUNTPAID"/> present under BillDetails module and save
Add the configuration back in the Analytics page and resync it should work.
Note: This step is applicable for both Zoho Reports (cloud) and Zoho Analytics (On-Prem).
New to ADSelfService Plus?
Related Articles
ZOHO Reports - Analytics Plus Sync issue
Description: The issue is because of the API call limit exceeding. Error Trace on the logs: ServerException (HttpStatusCode 400 Error Code: 6045 , Action: GETDATABASENAME, Message: API request could not be processed. The number of requests received ...Inputs required for Analytics Plus or Zoho Analytics sync issue
1. Recreate the issue by saving the page under Admin->Advanced Analytics Plus configuration from the user interface. 2. Zip the complete Zreports folder present under ManageEngine\ServiceDeskPlus MSP. 3. Also zip the complete logs folder present ...AD Sync issue_Rootpath failure
Error trace: 09:48:46:989]|[10-31-2019]|[com.adventnet.servicedesk.asset.util.WorkStationDiscoverUtil]|[INFO]|[62064]: Log message from WMI task : mwc-dc-01 - LDAP Search : Root Path Failure. (0x8007052e)| ...Upgrade failure to 10500 - Linux platforms
You may experience an upgrade failure in linux platforms when upgrading to 10500. Here are the traces from logs, Feb 21, 2020 4:55:03 PM [com.adventnet.tools.update.installer.Unzipper] [SEVERE] : ERRUnexpected Error. Please click View Log>> for ...10.5 Linux Upgrade failure and solutions
Traces in logs : 1. java.lang.Exception: InitPgsqlScript exited with value :: 1 at com.adventnet.persistence.PostgresPreProcessor.executeInitPgsqlScript(PostgresPreProcessor.java:1733) 2. PGSQL Permission related errors. 3. SDP MSP installed as root ...