JWP and JCP won't start - ORA-12899 on MQWP_SYSTEM

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

The JWP and JCP won't start, usually after a new installation.  A trace is created with a name like:

CPsrv_trc_20220503_140722_20ec_00.txt

The trace has lines like:

20220502/092340.814 - 37               ----------------------- Stack Trace -----------------------
20220502/092340.814 - 37               com.automic.database.api.DBException: INSERT INTO MQ1WP (MQWP_BAcv,MQWP_BAddr,MQWP_BSRName,MQWP_BTable,MQWP_CAcv,MQWP_CAddr,MQWP_CSRName,MQWP_DRole,MQWP_FAddr,MQWP_Len,MQWP_Msg,MQWP_PK,MQWP_Priority,MQWP_SchedTime,MQWP_Status,MQWP_System) VALUES (?,?,?,?,?,?,?,?,?,?,?,SQ_MQ1WP.nextval,?,sys_extract_utc(systimestamp(0)),?,?)
20220502/092340.814 - 37                at com.automic.database.impl.DBConnectionImpl.executeInternal(DBConnectionImpl.java:438)
20220502/092340.814 - 37                at com.automic.database.impl.DBConnectionImpl.insert(DBConnectionImpl.java:342)
...
20220502/092340.815 - 37               Caused by: java.sql.SQLException: ORA-12899: value too large for column "DB_USER"."MQ1WP"."MQWP_SYSTEM" (actual: 9, maximum: 8)
20220502/092340.815 - 37
20220502/092340.815 - 37                at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
...

Environment

Release : 12.2, 12.3, 21.0

Cause

As this points to the MQWP_SYSTEM, this is caused by the system= setting being too many characters in the ucsrv.ini file

Resolution

The error message:

Caused by: java.sql.SQLException: ORA-12899: value too large for column "DB_USER"."MQ1WP"."MQWP_SYSTEM" (actual: 9, maximum: 8)

is stating the MQWP_SYSTEM column has 9 characters (shown with "actual: 9") being inserted into it when only 8 (shown with "maximum: 8") are allowed. 

To resolve this, update the system= setting in ucsrv.ini to have only 8 characters or less.