ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Symptoms

The following error is returned when trying to edit any OAE job or process flow that containf OAE jobs.

Data Types missing, Please import : OAE_OBJS : java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPWORX_DEV.AWAPI", line 533 

 

 

---

 

Cause

The problem is that the OAE data types are missing.

 

---

 

Resolution

Import the OAE_OBJS. The file can can be found in the $AW_HOME/import directory of the master. The file is named OAE_OBJS.exp