Symptoms

Various actions could lead to the error, such as:

  • An Order on the Billing side fails:

    SQLGrammarException: could not extract ResultSet

  • An attempt to reset password for user in OA.

    The common part of the aforementioned conditions is the following entries in /var/log/pa/core.log:

    Caused by: org.postgresql.util.PSQLException: ERROR: relation "addresses_address_id_seq" does not exist
  Position: 16
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)

  • Periodic task License update fails:

    Feb 28 11:51:00.361 : DBG [task:4 EJB-default---8:425 pau]: c.p.p.tracer exit by exception: com.parallels.pa.service.license.ejb.LicenseManagerBean.updateLicense correlati
onId task:4 javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608)
        at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1152)
        at org.jboss.as.jpa.container.AbstractEntityManager.persist(AbstractEntityManager.java:580)
..
Caused by: org.postgresql.util.PSQLException: ERROR: relation "openfusion_licenses_license_id_seq" does not exist
  Position: 16

Cause

This behavior is recognized as FND-3148 by CloudBlue R&D team.

Resolution

Please contact your TAM or PTA to check the status of the issue and discuss the workaround.

Internal content

Link on internal Article