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 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 ...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 ...Advanced Analytics - FAQ & Troubleshooting tips
Troubleshooting tips This document is listing of customer facing issues, Advanced analytics is common name for both Zoho reports and Analytics plus. First setup we have to get with customer that recreate issue and generate support log ...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 ...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 ...