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 ...
                    • 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 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) ...