Article ID: 128605, created on Apr 1, 2016, last review on Apr 1, 2016

  • Applies to:
  • Operations Automation
  • APS

Symptoms

For an APS 1.2 application, General and Instances screens load very slowly, up to several minutes, sometimes leading to a Service Unavailable error.

At the same time, there is a postmaster PostgreSQL process eating close to 100% CPU usage on OA MN.

The application has a big amount of versions imported to OA and thousands of instances.

Cause

Slow database queries for APS applications with big amount of versions and instances. The issue is recognized under internal ID APS-34611.

Resolution

Remove the old versions of the application that contain 0 instances.

Search Words

general

tab

slow

screen

service unavailable

instances

717db81efe94e616312b74fb03a5d474 5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF