Issue/Introduction:
Error Message :
ErrorMsg: AwE-5001 Database Query Error
On a new install of Applications Manager (AM) the Automation Engine (Master) starts but remains in a TROUBLE status when the Master name is long (over 20 characters).
Investigation
- Install an AM Master using the name DEV_APP_MANAGER_ENGINE (22 characters long)
- Start the AM processes (startso all)
- The Master will stay in a TROUBLE status and any jobs that are launched will stay in a RUNNING status.
- Enable RmiServer debugging and look at the RmiServer<timestamp>.log files that are generated in the AM log directory.
The following errors are displayed:
14:30:00.315 rfp0: .DBAccess: checkError 6502
14:30:00.316 rfp0: AwE-5001
14:30:00.316 rfp0: SQL Error: 6502
14:30:00.317 rfp0: .AxOptions: NoErrorMsgProperties=false
ErrorMsg: AwE-5001 Database Query Error (11/29/16 2:30 PM)
Details: aw5.process_state
0 name: IN:VARCHAR2:java.lang.String:DEV_APP_MANAGER_ENGINE
1 progname: IN:VARCHAR2:java.lang.String:RMIMASTER
2 sessionId: IN:NUMERIC:java.math.BigDecimal:45408
3 status: IN:OUT:VARCHAR2:java.lang.String:STARTING
4 cpuUsage: IN:VARCHAR2::null
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPMGR_REPO.AW5", line 1824
ORA-06512: at line 1
The issue is a result of a procedure being called that inserts into the SO_JOB_HISTORY table. The record that is being inserted records the status change of the Master. When it does this it tries to insert the name of the Master (DEV_APP_MANAGER_ENGINE) a dash (-) and the type (RMIMASTER). This display name that it is trying to insert into the SO_MODULE field of the SO_JOB_HISTORY table exceeds the 30 charater limit defined for that field, since ‘DEV_APP_MANAGER_ENGINE-RMIMASTER’ is 32 characters long. This causes the Master to go into a TROUBLE state.
Resources
Cause:
Cause type:
Defect
Root Cause: Display name concatenating Master name and type which exceeds the 30 character limit.
Environment:
Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:
Resolution:
In the fixed version below, the product was modified so that the display name will truncate the <Master Name>-<Type> and will only use the first 30 characters.
Fix Status: Released
Fix Version(s):
Applications Manager 9.1.2 - Available
Additional Information:
Workaround :
The Automation Engine (Master) name must be shortened. To do so, run awinstall and when it asks if the settings are correct answer "No" and rename the Master to something 20 characters or less.