org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, ISSUE, CUSTOMFIELD, STRINGVALUE, NUMBERVALUE, TEXTVALUE , DATEVALUE FROM customfieldvalue WHERE ISSUE=? (ERROR: relation "customfieldval ue" does not exist )

Atlassian JIRA | Barrow Kwan | 1 decade ago
  1. 0

    got java.lang.NullPointerException when edit an issue looking at the log and found this. (customfieldval table doesnt's exist. this is a fresh install not an upgrade ) 2004-03-08 22:49:59,833 WARN [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] first select failed: trying to add row, result set was empty for sequence: Issue 2004-03-08 22:50:00,046 ERROR [jira.issue.index.IssueDocument] Could not retrieve custom fields for issue :[GenericEntity:Issue][created,2004-03-08 22:49:59.831 ][summary,Svn class throws null reference exception if label is not specified][timeoriginalestimate,null][workflowId,10000][type,1][environment,][status,1][updated,2004-03-08 22:49:59.831][id,10000][timeestimate,null][key,CCNET-1][duedate,2 004-03-09 00:00:00.0][description,There's a bug in the ProcessSourceControl.LabelSourceControl method when using Subversion as the version control repository. When automatic taggingis off, a null pointer exception is being thrown because the output of the CreateLabelProcessInfo method returns a null process info, which LabelSourceControl tries to execute.][reporter,orogers][project,10000][security, null][votes,0][assignee,orogers][priority,3] : org.ofbiz.core.entity.GenericData SourceException: SQL Exception while executing the following:SELECT ID, ISSUE, C USTOMFIELD, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE FROM customfieldvalue WHERE ISSUE=? (ERROR: relation "customfieldvalue" does not exist ) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, ISSUE, CUSTOMFIELD, STRINGVALUE, NUMBERVALUE, TEXTVALUE , DATEVALUE FROM customfieldvalue WHERE ISSUE=? (ERROR: relation "customfieldval ue" does not exist ) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.jav a:311) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(Generi cDAO.java:1050) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.jav a:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.jav a:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.jav a:767) at org.ofbiz.core.entity.GenericDelegator.getRelated(GenericDelegator.ja ......

    Atlassian JIRA | 1 decade ago | Barrow Kwan
    org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, ISSUE, CUSTOMFIELD, STRINGVALUE, NUMBERVALUE, TEXTVALUE , DATEVALUE FROM customfieldvalue WHERE ISSUE=? (ERROR: relation "customfieldval ue" does not exist )
  2. 0

    [JRA-3365] java.lang.NullPointerException when edit an issue - Atlassian JIRA

    atlassian.com | 1 year ago
    org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, ISSUE, CUSTOMFIELD, STRINGVALUE, NUMBERVALUE, TEXTVALUE , DATEVALUE FROM customfieldvalue WHERE ISSUE=? (ERROR: relation "customfieldval ue" does not exist ) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.jav a:311) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(Generi cDAO.java:1050)
  3. 0

    [JRA-9193] "Invalid state, the Connection object is closed." with JTDS 1.2 and MSSQL 2000 - Atlassian JIRA

    atlassian.com | 1 year ago
    org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, username, PASSWORD_HASH FROM userbase WHERE username=? (Invalid state, the Connection object is closed.)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    The FogBugz importer is blowing up near the end of a large import: {noformat} 2006-04-06 14:55:04,326 INFO [imports.importer.impl.ImportLogger] Rewritten comment for issue LOGI75-145 (105435.017s)^M 2006-04-06 15:02:56,451 INFO [imports.importer.impl.ImportLogger] Rewritten comment for issue IDEDEV-94 (105907.142s)^M 2006-04-06 15:19:42,591 INFO [imports.importer.impl.ImportLogger] FAILED: Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state (106913.282s)^M 2006-04-06 15:19:42,779 INFO [imports.importer.impl.ImportLogger] com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, AUTHOR, actiontype, actionlevel, actionbody, CREATED, actionnum FROM jiraaction WHERE issueid=? AND actiontype=? (I/O Error: Connection reset)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.rewriteOldIssueKeys(DefaultJiraDataImporter.java:652)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:116)^M at com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)^M Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, AUTHOR, actiontype, actionlevel, actionbody, CREATED, actionnum FROM jiraaction WHERE issueid=? AND actiontype=? (I/O Error: Connection reset)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:345)^M at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1050)^M at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)^M at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.rewriteOldIssueKeys(DefaultJiraDataImporter.java:631)^M ... 2 more^M (106913.47s)^M 2006-04-06 15:19:42,966 INFO [imports.importer.impl.ImportLogger] Flushing issue cache (106913.657s)^M 2006-04-06 15:21:28,576 WARN [core.entity.jdbc.SQLProcessor] Already closed.^M 2006-04-06 15:21:28,623 WARN [core.entity.jdbc.SQLProcessor] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Invalid state, the Connection object is closed.^M 2006-04-06 15:21:28,623 WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor^M java.sql.SQLException: Invalid state, the Connection object is closed.^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494)^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:1889)^M at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)^M at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:131)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:114)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M 2006-04-06 15:21:28,623 WARN [NoModule] [SQLProcessor.commit]: SQL Exception occurred on commit. Error was:java.sql.SQLException: Invalid state, the Connection object is closed.^M 2006-04-06 15:21:28,638 ERROR [NoModule] Error closing the result, connection, etc in finalize EntityListIterator^M org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (Invalid state, the Connection object is closed.)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:116)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M java.sql.SQLException: Invalid state, the Connection object is closed.^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494)^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1874)^M at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.commit(DelegatingConnection.java:238)^M at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:199)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:112)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M {noformat}

    Atlassian JIRA | 1 decade ago | Jeff Turner
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, AUTHOR, actiontype, actionlevel, actionbody, CREATED, actionnum FROM jiraaction WHERE issueid=? AND actiontype=? (I/O Error: Connection reset)
  6. 0

    The FogBugz importer is blowing up near the end of a large import: {noformat} 2006-04-06 14:55:04,326 INFO [imports.importer.impl.ImportLogger] Rewritten comment for issue LOGI75-145 (105435.017s)^M 2006-04-06 15:02:56,451 INFO [imports.importer.impl.ImportLogger] Rewritten comment for issue IDEDEV-94 (105907.142s)^M 2006-04-06 15:19:42,591 INFO [imports.importer.impl.ImportLogger] FAILED: Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state (106913.282s)^M 2006-04-06 15:19:42,779 INFO [imports.importer.impl.ImportLogger] com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, AUTHOR, actiontype, actionlevel, actionbody, CREATED, actionnum FROM jiraaction WHERE issueid=? AND actiontype=? (I/O Error: Connection reset)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.rewriteOldIssueKeys(DefaultJiraDataImporter.java:652)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:116)^M at com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)^M Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, AUTHOR, actiontype, actionlevel, actionbody, CREATED, actionnum FROM jiraaction WHERE issueid=? AND actiontype=? (I/O Error: Connection reset)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:345)^M at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1050)^M at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)^M at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.rewriteOldIssueKeys(DefaultJiraDataImporter.java:631)^M ... 2 more^M (106913.47s)^M 2006-04-06 15:19:42,966 INFO [imports.importer.impl.ImportLogger] Flushing issue cache (106913.657s)^M 2006-04-06 15:21:28,576 WARN [core.entity.jdbc.SQLProcessor] Already closed.^M 2006-04-06 15:21:28,623 WARN [core.entity.jdbc.SQLProcessor] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Invalid state, the Connection object is closed.^M 2006-04-06 15:21:28,623 WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor^M java.sql.SQLException: Invalid state, the Connection object is closed.^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494)^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:1889)^M at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)^M at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:131)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:114)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M 2006-04-06 15:21:28,623 WARN [NoModule] [SQLProcessor.commit]: SQL Exception occurred on commit. Error was:java.sql.SQLException: Invalid state, the Connection object is closed.^M 2006-04-06 15:21:28,638 ERROR [NoModule] Error closing the result, connection, etc in finalize EntityListIterator^M org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (Invalid state, the Connection object is closed.)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:116)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M java.sql.SQLException: Invalid state, the Connection object is closed.^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494)^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1874)^M at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.commit(DelegatingConnection.java:238)^M at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:199)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:112)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M {noformat}

    Atlassian JIRA | 1 decade ago | Jeff Turner
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, AUTHOR, actiontype, actionlevel, actionbody, CREATED, actionnum FROM jiraaction WHERE issueid=? AND actiontype=? (I/O Error: Connection reset)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.ofbiz.core.entity.GenericDataSourceException

      SQL Exception while executing the following:SELECT ID, ISSUE, CUSTOMFIELD, STRINGVALUE, NUMBERVALUE, TEXTVALUE , DATEVALUE FROM customfieldvalue WHERE ISSUE=? (ERROR: relation "customfieldval ue" does not exist )

      at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery()
    2. org.ofbiz.core
      GenericDAO.selectByAnd
      1. org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:311)
      2. org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1050)
      3. org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)
      3 frames