Unable to Sync Analytics after upgrade to 10500

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)| ...
                    • solution for postgres 11 upgrade issues

                      When Supportcenter Plus is upgraded to 14300 or later, postgres is also upgraded to 11.17. If you are using bundled postgres, data migration through pgdump and restore mechanism also happens. To ensure efficiency in Postgres 11.17, make sure your ...