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

book

Article ID: 209276

calendar_today

Updated On:

Products

Automic Continuous Delivery Director

Issue/Introduction

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

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

Cause

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

Environment

Continuous Delivery Director: 7.3

Oracle Database Version: 19c

Resolution

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