Sync with Analytics

Unable to Sync Analytics after upgrade to 9417

Description:

The issue occurs because of fix breakage of this issue.

Issue arises when Cx has versions before 9413 and has synced with Zoho Reports previously and recently migrated to any of the versions after 9413. Issue can be seen in ZohoReports Configuration page. When he navigates to Admin-> Advanced Analytics the value for the data center will not populated in the Select box.

Cause:

Because of discrepancy in the reports url in [PROD_HOME]/zreports/uploadtool/conf/common_params.conf file and the entry for the url present in the table ZohoReportsConfiguration in the database.

Before upgrade:



Resolution:

Run the below query to update the URL value in the database and then proceed to Admin -> Advanced Analytics to see that the data center has been populated. Below image contains both the value after the upgrade and the value after running the query.

update zohoreportsconfiguration set param_value='https://analytics.zoho.com' where id=(select id from zohoreportsconfiguration where category='ZROPInfo' and param_name='URL');




P.S Also attaching the common_params file before and after the upgrade
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                      • Related Articles

                      • 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 ...
                      • 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 ...
                      • Active directory unable to sync

                        Error in logs : Error trace : 15:24:14:746]|[02-09-2022]|[com.adventnet.servicedesk.asset.discovery.IpUtil]|[INFO]|[640]: Java PING Result for the workstation : 10.64.72.13. Result of ping : false.| ...
                      • Unable to open update manager

                        Issue: When updatemgr.bat command is executed the pop up does not appear Cause: This issue might occur due to the space insufficiency. Hence we need to decrease the space. Workaround: 1. Go to ManageEngine\service1msp\bin\scripts, take a copy of ...