OAPP_SET jobs abort with the error "ORA-06502: PL/SQL: numeric or value error: host bind array too small"
search cancel

OAPP_SET jobs abort with the error "ORA-06502: PL/SQL: numeric or value error: host bind array too small"

book

Article ID: 85137

calendar_today

Updated On:

Products

CA Automic Dollar Universe

Issue/Introduction

Error Message :
The following errors appear on the job log:

####
ERROR:
ORA-06502: PL/SQL: numeric or value error: host bind array too small
ORA-06512: at line 1
####

Patch level detected:Dollar Universe 6.2.01
Product Version: Dollar.Universe 6.2.01

Description :Some OAPP_SET Jobs abort with the following message in the job log:

"ERROR: ORA-06502: PL/SQL: numeric or value error: host bind array too small"

Environment

OS: Linux

Cause

Cause type:
Other
Root Cause: This problem can appear for two reasons:
1. The UTL_FILE package is not correctly configured to work with Dollar Universe. The package UTL_FILE is based on a directory alias defined on the database.

Resolution

For the first reason, the solution is to modify the alias used by Dollar Universe ( variable UXOAPP_DIR_OUT_ALIAS on the values.xml).
In case the database server is remote, then you should add the following variable on the values.xml:
Y


For the second reason, the solution is to modify the PATH and LD_LIBRARY_PATH so they point to a version 11g or superior of sqlplus.
In order to do that, add these three lines at the end of the file /data/nodefiles/unienv_oapp_specific.ksh in order to point to the client 11g:

export ORACLE_HOME=yourpathtoclient11g
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

Fix Status: Released

Fix Version(s):
Component: Application.Server
Version: Dollar.Universe 6.2.01

Additional Information

Workaround :
N/A