AWA: Memory usage extremely high on Java Processes after upgrade.

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.