Clicking "Edit" for an issue with no options set yet results in PSQLException: ERROR: column "option_value" does not exist error message.

Issue #16 resolved
Former user created an issue

Technical details

Referer URL: https://device.sprintdd.com/jira/browse/SLGM-292 com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:8.4.12 - minor version:4 - major version:8 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 8.4 JDBC4 (build 703)

org.postgresql.util.PSQLException: ERROR: column "option_value" does not exist
  Position: 128
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
    - name:PostgreSQL
    - version:8.4.12
    - minor version:4
    - major version:8
Driver:
    - name:PostgreSQL Native Driver
    - version:PostgreSQL 8.4 JDBC4 (build 703)

org.postgresql.util.PSQLException: ERROR: column "option_value" does not exist
  Position: 128
    at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:167)
    at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.find(DelegatingActiveObjects.java:88)
    at sun.reflect.GeneratedMethodAccessor3492.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
...
    at jira.plugin.projectspecificselectfield.ProjectSpecificSelectCFType.getVelocityParameters(ProjectSpecificSelectCFType.java:37)
    at com.atlassian.jira.issue.customfields.CustomFieldUtils.buildParams(CustomFieldUtils.java:385)
    at com.atlassian.jira.plugin.customfield.CustomFieldTypeModuleDescriptorImpl.getEditHtml(CustomFieldTypeModuleDescriptorImpl.java:184)
    at com.atlassian.jira.issue.fields.CustomFieldImpl.getEditHtml(CustomFieldImpl.java:1012)
...
    at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
    at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
    at java.lang.Thread.run(Thread.java:722)
Caused by: org.postgresql.util.PSQLException: ERROR: column "option_value" does not exist
  Position: 128
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2096)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1829)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
...

Comments (5)

  1. Holger Schimanski repo owner

    Many thanks for reporting this bug!

    Did already found the problem and will release a new version early next week.

    Best regards, Holger

  2. Log in to comment