My Oracle Support Banner

Project Arbiter Fails to Run Daily at 3AM (Doc ID 2788225.1)

Last updated on MARCH 22, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version to [Release 20.12]
Information in this document applies to any platform.


After enabling publication with email notification enabled using a Microsoft SQL Server database, the arbiter fails with the following error at 3AM daily.

'ERROR DB Id: 1 com.primavera.jobsvc.common.JobServiceExecutable Job error running job of type JT_ProjectArbiter on database1
MDC: {context= DB Id: 1} DBEngine.executeSelect() error while executing: {SELECT pxjobrun.jobrun_id JobRunId,pxjobrun.status_code JobStatus,pxjobrun.job_type_key JobTypeKey,pxjobrun.run_duration RunDuration,pxjobrun.run_start_date RunStartDate,pxjobrun.run_end_date RunEndDate FROM pxjobrun WHERE pxjobrun.job_type='JT_Project' AND pxjobrun.run_start_date > '04-28-2021 03:00:00', 'mm-dd-yyyy hh24:mi:ss') ORDER BY pxjobrun.job_type_key,pxjobrun.run_start_date}
  --Incorrect syntax near ','. '

The issue can be reproduced at will with the following steps:
1. Login to P6 Web Go to Administration/Application Settings/Services. Set the settings for Project Publication.
    a. Enable publish Projects = true with publish every 1 minute.
    b. Enable Notification Email = true.
2. Wait 24 hours, the error will occur at 3:00 AM.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.