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 )

Atlassian JIRA | Mark Chaimungkalanont | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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….

    Atlassian JIRA | 1 decade ago | Mark Chaimungkalanont
    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 )
  2. 0

    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….

    Atlassian JIRA | 1 decade ago | Mark Chaimungkalanont
    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 )

    Root Cause Analysis

    1. 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()
    2. org.ofbiz.core
      GenericDAO.insert
      1. org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:341)
      2. org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:115)
      3. org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
      3 frames