Custom Field with large description causes crash for custom field layout

From Kevin Ross (kross at spheris.com)

1. Created a custom field layout
2. I added a custom field with a considerably large description
3. I was changing the ordering of the newly added custom field in the
layout and on first click it failed.

I’m not quite sure why jira is copying the custom field description into the field layout item (not normalized), but this causes a big problem because the column sizes are not the same.

org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO fieldlayoutitem (ID, FIELDLAYOUT, FIELDIDENTIFIER, DESCRIPTION,

VERTICALPOSITION, ISHIDDEN, ISREQUIRED) VALUES (?, ?, ?, ?, ?, ?, ?) (ORA-01401: inserted value too large for column

)

at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:341)

at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:115)

at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)

SQL> desc fieldlayoutitem

Name Type Nullable Default Comments

---------------- ------------- -------- ------- --------

ID NUMBER(18)

FIELDLAYOUT NUMBER(18) Y

FIELDIDENTIFIER VARCHAR2(255) Y

DESCRIPTION VARCHAR2(255) Y

VERTICALPOSITION NUMBER(18) Y

ISHIDDEN VARCHAR2(60) Y

ISREQUIRED VARCHAR2(60) Y

SQL> desc customfield

Name Type Nullable Default Comments

---------------------- -------------- -------- ------- --------

ID NUMBER(18)

PROJECT NUMBER(18) Y

ISSUETYPE VARCHAR2(255) Y

FIELDTYPE NUMBER(18) Y

CFNAME VARCHAR2(60) Y

DESCRIPTION VARCHAR2(4000) Y

DEFAULTVALUE VARCHAR2(255) Y

CUSTOMFIELDSEARCHERKEY VARCHAR2(255) Y

CUSTOMFIELDTYPEKEY VARCHAR2(255) Y

I’ll get the column resized….