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 com.manageengine.framework.sqlbuilder.QueryGenerator.addSelectColumnDetails(QueryGenerator.java:586)
at com.manageengine.framework.sqlbuilder.QueryGenerator.getSelectQuery(QueryGenerator.java:258)
at com.manageengine.framework.sqlbuilder.QueryGenerator.getSelectQuery(QueryGenerator.java:125)
at com.manageengine.zrmeinteg.sync.ZRMEUploadData.uploadDataToAdvancedAnalytics(ZRMEUploadData.java:192)
at com.manageengine.zrmeinteg.sync.DataSyncer.invokeSync(DataSyncer.java:492)
at com.manageengine.zrmeinteg.sync.DataSyncer.startUploadData(DataSyncer.java:302)
at com.manageengine.zrmeinteg.sync.ZRScheduleDataUploader.executeTask(ZRScheduleDataUploader.java:67)
at com.adventnet.taskengine.internal.SchedulerBean.executeTask(SchedulerBean.java:698)
Workaround:
- Kindly replace the <MSP_Home>\zreports\reference\sync\conf\ZRMEModules.xml with the attached file.
- Repopulate and re-sync once to resolve the issue.
Note:
Compatible for MSP/SCP 14730 only.
New to ADSelfService Plus?
Related Articles
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 ...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 ...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 ...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 ...