ZOHO reports or Analytics Plus Tables reference / issues troubleshooting

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 ADManager Plus?

          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 ...
            • How to take a connection dump for analyzing performance issues?

              For Performance/slowness issues instead of taking Threaddump manually or instead of invoking PerformanceTool make use of the below URL when the issue occurs, http://servername:portnumber/servlet/PerformanceDebug Note: The above URL works even when ...
            • 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 ...