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 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 ...
                      • 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 ...
                      • How to upgrade SupportCenter Plus instance ?

                        Users who wants to upgrade the Supportcenter Plus instance needs to proceed with the following steps :  Building a test environment is must while upgrading SupportCenter Plus. It is highly advisable to try the upgrade on the test environment first so ...