Resolution:
Description:
===========
Business Event Cache Server reports error:
"ORA-01461: can bind a LONG value only for insert into a LONG column"


Environment:
===========
  o Business Events 3.0.1 (all OS versions)

Symptoms:
=========
Error in logfile of Cache Server:
"ORA-01461: can bind a LONG value only for insert into a LONG column"

Cause:
======
The error will be raised when the Cache Server tries to save a string property that exceeds the max. possible length of a property value (varchar2(4000), Default: varchar2(256))

Resolution:
========

Change the string size for the properties to a higher value (&gt4000) in designer. To do this open the Extended Properties of the concept property (right mouseclick on the property in designer) and set the new value.

After that change run the be-oradeploy script. The property will be saved as a CBLOB (no size limit).

NOTE:
We strongly recommend to run some tests after that change because you might hit performance issues during heavy volume processing (both memory and CPU).