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
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  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)

    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