AWA: Memory usage extremely high on Java Processes after upgrade.
book
Article ID: 191151
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
After upgrading the Automic system, the memory usage of the Java processes (Communication (JCP), Worker(JWP)) are much higher than expected, ending in a crash of the process.
Environment
Release : 12.3
Component : AUTOMATION ENGINE
Cause
Improper configuration
Resolution
Confirm that the [JDBC] section of the ucsrv.ini is configured correctly to allow the JCP and JWP to utilize the thin connection versus a thick connection.
[JDBC] ; ; sqlDriverConnect: The JDBC connection string to connect JAVA based worker processes (JWP) to the database. ; jdbc:sqlserver://localhost:1433;databaseName=AUTOMIC - MS SQL Server ; jdbc:db2://localhost:50000/AUTOMIC - DB2 ; jdbc:oracle:thin:@//localhost:1521/AUTOMIC - ORACLE ; jdbc:postgresql://localhost:5432/AUTOMIC - PostgreSQL ; ;sqlDriverConnect=
The sqlDriverConnect= needs to be uncommented and setup to point to your Automic database.