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
Advanced Analytics Sync Failure
A+ Sync fails post 14730 upgrade. Error Trace: Exception occured while advanced analytics data upload| java.lang.Exception: No select column(s) found. at ...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)| ...Analytics - SupportCenter Plus integration PKIX path building failed (for SCP 11.0)
While syncing Analytics Reports, this error may appear where the self-signed certificate to sync both Analytics Reports and SCP will be missing. These traces (mentioned below) can be viewed in the file zrmeinteglog0.txt under the location ...