Adding Process Flow Component Predecessor - ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

When adding a predecessor to a process flow component the following error can be seen.

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

ORA-06512: at "AMS943.AWAPI", line 2673

ORA-06512: at "AMS943.AW_WEB_API", line 260

ORA-06512: at line 1

Environment

Release : 9.3.x and 9.4.x

Cause

This can occur when there are a large number of predecessors on a single component. The predecessor details are stored in the table so_chain_detail column so_predecessors cloumn. The so_predecessors cloumn  a character limit of varchar2 4000. Adding a large number of predecessors can exceed this character limit.

Resolution

This limitation is set by Oracle as the maximum character limit for data type varchar2 is 4000 bytes or characters.

https://knowledgeburrow.com/what-is-maximum-size-of-varchar2-in-oracle/

*Please note link above is not an official Broadcom document thus I cannot guarantee its accuracy.

The process flow will need to be redesigned to remove the large number of predecessors on a single component.