ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 88326

calendar_today

Updated On:

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