Resolution:
Description:

============

When using TIBCO BusinessEvents with a backing store, you may encounter error messages such as those detailed below during insert/modify of a concept property at runtime. The following procedure explains how to rectify it.



Environment:

==========

TIBCO Business Events 3.x or 4.x release with Oracle types backing store.



Symptoms:
=========

The following error message shows up in the logs when using TIBCO BusinessEvents with backing store functionality.

java.sql.SQLException: ORA-12899: value too large for column "YYY_CACHE"."D_CONCEPTNAME"."SYS_NC00057$" (actual: 1460, maximum: 1000)


Cause:
=====

This error indicates that the length of the field specified in the TIBCO BusinessEvents schema does not agree with the actual data. It can be a little challenging to figure out the exact column name if the backing store schema is generated using the Oracle Type feature.



Resolution:
=========

You can use the following SQL query in your backing store to identify the columns causing the issue :


select owner,table_name,column_name,qualified_col_name
from all_tab_cols  
where (table_name,column_name)
in ('D_CONCEPTNAME','SYS_NC00057$')
and column_name in ('SYS_NC00057$')  
and owner like 'YYY_CACHE%';


Attachments:
==========
None.


References:
==========
None.

Associating System (Oracle database) generated column names with type definitions.