Slowness in accessing dashboards after an upgrade to 4000

Slowness in accessing dashboards after an upgrade to 4000

Analysis:

CPU spikes to 100% and the pgsql.exe processes consuming more memory.

The phantom server which used to generate the snapshots for all the reports is enabled by default after the upgrade. This process creates load and causes the performance issue.

Solution:

1. Disable the generation of snapshots by modifying the property 'zrop

.snapshots.enabled' to false in ZROPAdvancedSettings table.

2. Restart the service.

Query:
  1. update ZROPAdvancedSettings set val='false' where key='zrop.snapshots.enabled'.





                  New to ADSelfService Plus?

                    • Related Articles

                    • Upgrade issue in build 3200

                      Upgrade issue in build 3200 The below cases were identified in local system and couple of customer's system during 3200 upgrade. Issue 1: PGSQL migration fails: Since this upgrade will upgrade pgsql version, pgsql has its own upgrade prior to ...
                    • Upgrade failure

                      Issue: Upgrade fails with error - "Error occurred :: Irrevertable exception occurred" Analysis: Tried to start database manually, but it fails to start. Antivirus has been disabled/uninstalled. Log Traces: Aug 10, 2016 4:02:37 PM ...
                    • Upgrade to AnalyticsPlus 5400 Fails for Users with Missing zsoid Values

                      Issue Upgrading from builds between 5301 and 5360 to build 5400 fails because the zsoid field for some users is null. Error Trace java.sql.SQLException: This column [ZSOID] has some null values, hence it cannot be modified as not-null. Cause The ...
                    • Upgrade Key steps

                      Key steps that must be followed without which the upgrade may fail.  All Analytics Plus Services must be stopped. AnalyticsPlus folder must be given "Everyone" folder permission with "Full Control" before upgrade (Can be revoked after upgrade) ...
                    • Unexpected error prompted for while accessing reports for Servicedesk Plus MSP integrated setup

                      Issue : Unexpected error prompt while accessing reports Analysis: The exception caused is due to a syntax problem faced in the query formed while the user filter drop down is used on the SLA deviation report. The logs shared helped us to find the ...