ORA-12899: value too large for column "xxxxxxx"."yyyyyy"."PARAMETERCD" (actual: 11, maximum: 4)

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Fiserv's MM_STMXT Job may fail with the below error which is seen in the output file.

ORA-12899: value too large for column  "xxxxxxx"."yyyyyy"."PARAMETERCD" (actual: 11, maximum: 4)
ORA-02063: preceding line from PROD
ORA-06512: at line 1
ORA-06512: at "APPWORX.AWDYN", line 19
ORA-06512: at line 1

 

Environment

Release : 9.4.2

Resolution

This is not an Applications Manager error but a Fiserv error. It is recommended that a case with the Fiserv support team is opened.

The error itself is likely seen because the parameter or parameter name PARAMETERCD is 11 characters long and the Job is attempting to load the 11 characters into a DNA database table that has a max character limit of 4.

Please contact Fiserv to report this issue as the parameter name or parameter value PARAMETERCD needs to be shorten.