My Oracle Support Banner

Global Scheduled Service "Publish Security" is Failing after Upgrading P6 EPPM (Doc ID 3020084.1)

Last updated on AUGUST 07, 2024

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 21.12 to 21.12.19.0 [Release 21.12]
Primavera P6 Enterprise Project Portfolio Management - Version 22.12 to 22.12.14.0 [Release 22.12]
Primavera P6 Enterprise Project Portfolio Management - Version 23.12 to 23.12.4.0 [Release 23.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 24.4 to 24.5 [Release 24.4 to 24.5]
Information in this document applies to any platform.

Symptoms

After upgrading P6 EPPM, the 'Publish Security' global scheduled service runs for an hour and then fails. The following errors are written to the service log:

[3] CORE(SQL): IO Error: Socket read timed out
[3] CORE(SQL): Connection has been recycled. Database: <db_name>, Pool: PML, Id: 156

Job Status: Failed

[3] CORE(SQL): Errors occurred when executing following statement: declare DIRTY_USERS_CONTEXT_NAME varchar2(12) := 'DIRTY_USERS';


The issue can be reproduced at will with the following steps:

  1. In P6 Web navigate to Administration > Scheduled Services and select Global.
  2. Highlight the Publish Security service and click Run Service.
  3. The job will timeout after an hour and fail with the reported error.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.