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 ...
                      • Failed to upgrade to build 5300/5301

                        Issue: Upgrade fails while attempting to upgrade to the build 5300/5301. Cause: Upgrade fails due to a necessary system property required for logging slow queries is missing. This issue will arise while attempting to upgrade to the ...
                      • 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 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 ...