Calls to get_safety_date Procedure fail with ORA-03111: 'break received on communication channel' (Doc ID 1605954.1)

Last updated on MARCH 02, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 07-May-2015***

Symptoms

On P6 EPPM R8.3 SP1, using Oracle Database version 11.2.0.1 or 11.2.0.2

After upgrading to 8.3 SP1, some scheduled services do not run correctly and the following error can be seen numerous times in multiple scheduled-services log files:

SEVERE:[SERVICE]:[PxService]: DBEngine.executeStatement for {call get_safety_date(?, ?, ?)} failed: ORA-03111: break received on communication channel

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms