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