Symptoms

There are several possible symptoms of the issue, depending on the exact conditions.

OSS Core could fail to connect to BSS Database node with the following exception in /var/log/pa/core.log:

Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "pba"
        at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:443)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:217)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
        at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
        at org.postgresql.Driver.makeConnection(Driver.java:404)

Alternatively, CCP v2 may show errors in the screens, related to Billing functionality. GET API requests on https://cp.example.com/aps/2/resources/71341292-9f3d-4c93-8502-ba5e15dce43e/sm/subscriptions URL end with the 500 error in browser debugger:

Sorry, but something went wrong

The error reflected in core.log:

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
...
Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for relation PromoTrfPeriod

Cause

For old Odin Automation installations, bm4 user could remain as the default identity to access Billing database. During the OA lifetime, the default user was changed to pba. New features imply logging in under this user.

Resolution

Please use the instructions provided in KB article: https://kb.cloudblue.com/en/132609.

Internal content