org.postgresql.util.PSQLException: ERRO: relation "AO_60DB71_RAPIDVIEW_ID_seq" does not exist Position: 16

Atlassian JIRA | Clarissa Gauterio | 5 years ago
  1. 0

    If JIRA used a different schema ("jira" for example) instead of the default one ("public" in this case), Greenhopper doesn't fully work. When trying to create a Rapid Board (_Agile > Rapid Board > Create a new Rapid View_), the message "Internal Server Error" appears on the screen and the following error appear in _catalina.out_: {noformat} 30/01/2012 16:04:33 com.sun.jersey.server.impl.application.WebApplicationImpl onException SEVERE: Internal server error com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:9.1.1 - minor version:1 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.0 JDBC4 (build 801) org.postgresql.util.PSQLException: ERRO: relation "AO_60DB71_RAPIDVIEW_ID_seq" does not exist Position: 16 at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:79) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:58) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) ... {noformat} Note: the "AO_60DB71_RAPIDVIEW_ID_seq" sequence was created in database and is available. Workaround: Set default search schema for jira db user to start from "jira" schema: {code:sql} ALTER USER jirauser SET search_path TO jira,public; {code}

    Atlassian JIRA | 5 years ago | Clarissa Gauterio [Atlassian]
    org.postgresql.util.PSQLException: ERRO: relation "AO_60DB71_RAPIDVIEW_ID_seq" does not exist Position: 16
  2. 0

    If JIRA used a different schema ("jira" for example) instead of the default one ("public" in this case), Greenhopper doesn't fully work. When trying to create a Rapid Board (_Agile > Rapid Board > Create a new Rapid View_), the message "Internal Server Error" appears on the screen and the following error appear in _catalina.out_: {noformat} 30/01/2012 16:04:33 com.sun.jersey.server.impl.application.WebApplicationImpl onException SEVERE: Internal server error com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:9.1.1 - minor version:1 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.0 JDBC4 (build 801) org.postgresql.util.PSQLException: ERRO: relation "AO_60DB71_RAPIDVIEW_ID_seq" does not exist Position: 16 at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:79) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:58) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) ... {noformat} Note: the "AO_60DB71_RAPIDVIEW_ID_seq" sequence was created in database and is available. Workaround: Set default search schema for jira db user to start from "jira" schema: {code:sql} ALTER USER jirauser SET search_path TO jira,public; {code}

    Atlassian JIRA | 5 years ago | Clarissa Gauterio
    org.postgresql.util.PSQLException: ERRO: relation "AO_60DB71_RAPIDVIEW_ID_seq" does not exist Position: 16
  3. 0

    Rightseditor není obsažený v distribuci

    GitHub | 2 years ago | MartinRumanek
    org.apache.empire.db.exceptions.QueryFailedException: Error executing query SELECT nextval('GROUP_USER_ASSOC_ID_SQ'). Native error is: ERROR: relation "group_user_assoc_id_sq" does not exist Position: 16
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    The Cyclos users forum • View topic - Cyclos 4.3.2 installation problem

    cyclos.org | 11 months ago
    org.postgresql.util.PSQLException: ERROR: relation "application" does not exist Position: 16 Error Code: 0 Call: SELECT ? FROM application LIMIT ? OFFSET ? bind => [3 parameters bound] Query: ReportQuery(referenceClass=Application sql="SELECT ? FROM application LIMIT ? OFFSET ?")
  6. 0

    DB schema support re-broken

    GitHub | 2 months ago | samroberton
    org.postgresql.util.PSQLException: ERROR: relation "schema_migrations" does not exist Position: 16

    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.postgresql.util.PSQLException

      ERRO: relation "AO_60DB71_RAPIDVIEW_ID_seq" does not exist Position: 16

      at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create()
    2. com.atlassian.activeobjects
      DelegatingActiveObjects.create
      1. com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:79)
      2. com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:58)
      2 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    4. Spring AOP
      AopUtils.invokeJoinpointUsingReflection
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      1 frame