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.