ORA-12899: value too large for column "OBLICORE"."T_DEBUG_INTERMEDIATE_DATA"."DATA"

Products

• CA Business Service Insight

Issue/Introduction

Following error appears when trying to run Business Logic Scope calculation due to large eventDetails columns values

ORA-12899: value too large for column "OBLICORE"."T_DEBUG_INTERMEDIATE_DATA"."DATA" (actual: 1344, maximum: 1000)

Environment

CA Business Service Insight 8.3.x and 9.x

Resolution

1.  Take a backup of the BSI database

2.  The following database statements will increase the size

ALTER TABLE T_INTERMEDIATE_DATA MODIFY (DATA VARCHAR2(2000)); 

ALTER TABLE T_DEBUG_INTERMEDIATE_DATA MODIFY (DATA VARCHAR2(2000));