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
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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 )
  3. 0

    After following the [JIRA Jetty install doc|http://docs.codehaus.org/display/JETTY/JIRA], and importing a largish XML backup, JIRA completes successfully but prints an error in the log: 2007-05-01 14:06:44,499 INFO [jira.action.admin.DataImport] XML successfully parsed 2007-05-01 14:06:44,502 INFO [jira.action.admin.DataImport] Removing all entries from the database. 2007-05-01 14:06:44,572 INFO [jira.action.admin.DataImport] All entries removed. 2007-05-01 14:06:44,574 INFO [jira.action.admin.DataImport] Started storing 1367941 Generic Values 2007-05-01 14:08:13,891 WARN [jira.util.xml.XMLCleaningReader] Replaced invalid XML character (12). 2007-05-01 14:08:13,905 WARN [jira.util.xml.XMLCleaningReader] Replaced invalid XML character (12). java.lang.NullPointerException at org.enhydra.jdbc.pool.GenericPool.getFromPool(GenericPool.java:200) at org.enhydra.jdbc.pool.GenericPool.checkOut(GenericPool.java:351) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:194) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:204) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) 2007-05-01 14:10:35,812 ERROR [jira.action.admin.ImportParser] Exception importing entity Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException)) org.ofbiz.core.entity.GenericDataSourceException: Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException)) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:91) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:239) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:213) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) 2007-05-01 14:10:37,172 ERROR [jira.action.admin.DataImport] Error importing data: org.apache.commons.lang.exception.NestableException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException)) org.apache.commons.lang.exception.NestableException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException)) at com.atlassian.jira.action.admin.ImportParser.startElement(ImportParser.java:71) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:395) at com.atlassian.jira.action.admin.DataImport.doExecute(DataImport.java:119) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57) at com.atlassian.jira.action.JiraNonWebActionSupport.execute(JiraNonWebActionSupport.java:27) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34) at com.atlassian.jira.web.action.setup.SetupImport.doExecute(SetupImport.java:81) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:185) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1050) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:35) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:39) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141) at org.mortbay.jetty.Server.handle(Server.java:269) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:701) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:617) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:199) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339) at org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475) java.lang.NullPointerException at org.enhydra.jdbc.pool.GenericPool.getFromPool(GenericPool.java:200) at org.enhydra.jdbc.pool.GenericPool.checkOut(GenericPool.java:351) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:194) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:204) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) ....

    Atlassian JIRA | 10 years ago | Jeff Turner
    org.ofbiz.core.entity.GenericDataSourceException: Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    After following the [JIRA Jetty install doc|http://docs.codehaus.org/display/JETTY/JIRA], and importing a largish XML backup, JIRA completes successfully but prints an error in the log: 2007-05-01 14:06:44,499 INFO [jira.action.admin.DataImport] XML successfully parsed 2007-05-01 14:06:44,502 INFO [jira.action.admin.DataImport] Removing all entries from the database. 2007-05-01 14:06:44,572 INFO [jira.action.admin.DataImport] All entries removed. 2007-05-01 14:06:44,574 INFO [jira.action.admin.DataImport] Started storing 1367941 Generic Values 2007-05-01 14:08:13,891 WARN [jira.util.xml.XMLCleaningReader] Replaced invalid XML character (12). 2007-05-01 14:08:13,905 WARN [jira.util.xml.XMLCleaningReader] Replaced invalid XML character (12). java.lang.NullPointerException at org.enhydra.jdbc.pool.GenericPool.getFromPool(GenericPool.java:200) at org.enhydra.jdbc.pool.GenericPool.checkOut(GenericPool.java:351) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:194) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:204) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) 2007-05-01 14:10:35,812 ERROR [jira.action.admin.ImportParser] Exception importing entity Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException)) org.ofbiz.core.entity.GenericDataSourceException: Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException)) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:91) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:239) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:213) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) 2007-05-01 14:10:37,172 ERROR [jira.action.admin.DataImport] Error importing data: org.apache.commons.lang.exception.NestableException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException)) org.apache.commons.lang.exception.NestableException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException)) at com.atlassian.jira.action.admin.ImportParser.startElement(ImportParser.java:71) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:395) at com.atlassian.jira.action.admin.DataImport.doExecute(DataImport.java:119) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57) at com.atlassian.jira.action.JiraNonWebActionSupport.execute(JiraNonWebActionSupport.java:27) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34) at com.atlassian.jira.web.action.setup.SetupImport.doExecute(SetupImport.java:81) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:185) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1050) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:35) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:39) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141) at org.mortbay.jetty.Server.handle(Server.java:269) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:701) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:617) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:199) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339) at org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475) java.lang.NullPointerException at org.enhydra.jdbc.pool.GenericPool.getFromPool(GenericPool.java:200) at org.enhydra.jdbc.pool.GenericPool.checkOut(GenericPool.java:351) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:194) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:204) at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164) at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53) at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:237) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.jira.action.admin.ImportParser$1.run(ImportParser.java:191) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:751) at java.lang.Thread.run(Thread.java:619) ....

    Atlassian JIRA | 10 years ago | Jeff Turner
    org.ofbiz.core.entity.GenericDataSourceException: Exception while inserting the following entity: [GenericEntity:ChangeItem][newvalue,12322676][field,Attachment][id,12372349][fieldtype,jira][newstring,webapps-move-2.patch][group,12353345] (Unable to esablish a connection with the database. (SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.lang.NullPointerException))

    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