TIBCO Business Events Engine throws, "ORA-01461: can bind a LONG value only for insert into a LONG column exception."

TIBCO Business Events Engine throws, "ORA-01461: can bind a LONG value only for insert into a LONG column exception."

book

Article ID: KB0091257

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Exception in TIBCO Business Events Engine.

208 Apr 28 11:54:34:853 GMT +1 Ops-BusinessEventsArchive Error [test-distributed.be.gen.BusinessRules.Trade.Concepts.CustomDetails.WriteBehindThread] - java.sql.SQLException:
ORA-01461: can bind a LONG value only for insert into a LONG column

Resolution

=======

This is a known issue in BE 2.x and can happen when attempting to insert a string > 4000 characters to a varchar2(4000) field (max. size is 4000). Check your Business Events project to see if there is a possibility of having more than 4000 characters in a string field. This issue should be addressed in an upcoming BE 2.x Hotfix release. Check with TIBCO Support for any available Hotfix.

Issue/Introduction

TIBCO Business Events Engine throws, "ORA-01461: can bind a LONG value only for insert into a LONG column exception."