Failed to add Phases and tasks in a pipeline - JPA transaction Persistence Exception


Article ID: 209276


Updated On:


Automic Continuous Delivery Director


Getting below error while working with CDD using Oracle 19 ( Oracle )

"Could not roll back JPA transaction; nested exception is javax.persistence.PersistenceException: unexpected error when rollbacking. Please refer to server logs with timestamp [XXXXXXXXXX]. "


This issue come after upgrading CDD database from Oracle Database 12c Version to the Oracle Database 19c.

The Oracle SQL Error codes found in CDD log: Oracle SQL Error: 17410, SQLState: 08000 - No more data to read from socket

The log includes also:  SQL Error: 17002, SQLState: 08006  and SQL Error: 12514, SQLState: 08006


SQL Error: 17002, SQLState: 08006
IO Error: The Network Adapter could not establish the connection


SQL Error: 12514, SQLState: 08006

Listener refused the connection with the following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor


Continuous Delivery Director: 7.3

Oracle Database Version: 19c


Please execute the following 2 statements on the Oracle 19 database server:
alter system set "_optim_peek_user_binds"=FALSE scope=both sid='*';

alter system set "_optimizer_nlj_hj_adaptive_join"=FALSE scope=both sid='*';

Additional Information