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
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
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.
Please use the instructions provided in KB article: https://kb.cloudblue.com/en/132609.