Team Member Web Login Error "Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: java.lang.NullPointerException" When Database Service Name Is Different from Configured Network Name (Doc ID 2972798.1)

Last updated on SEPTEMBER 25, 2023

Applies to:

Symptoms

When attempting to login to P6 Team Member Web the following error occurs:

Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: java.lang.NullPointerException

The following error can also be seen in the <P6 EPPM home>\tmws\p6tmweb.log file;

<BEA-000000> <Failed creating datasource for jdbc:oracle:thin:@<HOST>:<PORT>/<SERVICE>
oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: java.lang.IllegalStateException: unable to start connection creation task
at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:379)
...
Caused By: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: java.lang.IllegalStateException: unable to start connection creation task
at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:379)
...
Caused By: oracle.ucp.UniversalConnectionPoolException: Unable to create connection within connection wait timeout: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
(CONNECTION_ID=NA24FrZ0TBKKEeIy4AAxFQ==)

Changes

Cause