ZOHO reports or Analytics Plus Tables reference / issues troubleshooting
When you face an issue in ZOHO reports or Analytics Plus issue, please send the below details for troubleshooting the same.
Save the ZOHO reports / Analytics plus configuration once and gather the below files :
1. zip the log folder present under <supportcenter>/server/default -> log and send it to us.
2. Also zip the uploadtool folder present under SupportCenter\zreports and send it to us.
3. send SCP and ZOHO reports or analytics Plus build numbers
4. send the below query reports output. Ask them to send the PDF format of it.
select * from uvhvalues where pattern like '%zrdynamicvalues%'
select * from SERVICECONFIG where SERVICEID in (select SERVICEID from SERVICES where servicename='zrsyncinfo');
select * from zrsharedusers
5. send ZOHO reports / Analytics plus the snapshot of the configuration page.
6. Click Support -> Schedule Activities and send details related to ZReportsScheduleSync and ZReportsCleanUp .
New to ADSelfService Plus?
Related Articles
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 ...Inputs required for analyzing Performance Issues
We need a couple of details to analyze Performance issue. So, please send the below details : Below mentioned details should be gathered before restarting the application. 1. Let us know whether you are taking Scheduled full backup or backup without ...Steps for deleting/modifying the reports created by other techs:
Steps for deleting/modifying the reports created by other techs: Connect to your database To connect to your database please refer http://www.manageengine.com/products/support-center/faq-general.html Execute the below query which will give you the ...Inputs required for analyzing Mail fetching or Notification issues
In case you face mail fetching or mail notification issues, please follow the steps below and send the necessary files for analysis. Usually, mail fetching issue will occur when the mail thread is locked. It will be resolved once the restart the ...Assessment reports
Datebase: MSSQL Status wise: select wo.workorderid, sd.statusname,convert(varchar(5),(sum(wsi.timespent))/60)+':'+convert(varchar(5),((sum(wsi.timespent))%60))'timespent' from workorder wo join wo_assessment wa on wo.workorderid=wa.workorderid join ...