My Oracle Support Banner

Error: 'ORA-01745: invalid host/bind variable name' When Attempting to Publish Some Projects in P6 EPPM (Doc ID 2639387.1)

Last updated on MARCH 22, 2022

Applies to:

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

Symptoms

Publication fails for some projects with the following error in the <P6 EPPM or P6 Services home>\p6\WebAccessLogs\Services\jt_project\<date-time>_FAILED.log.

[TASK]:[PxServiceCalendarSqlWriter]: [5] CORE(BRE): Failed to update calendar: <calendar ID>   
[TASK]:[PxServiceCalendarSqlWriter]: [5] CORE(BRE): ORA-01745: invalid host/bind variable name

 

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

  1. Publish a project.
  2. The job shows as 'Failed'.
  3. Observe the reported error in the log file.

Changes

 

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.