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 188.8.131.52 to 184.108.40.206 [Release 17.12]
Information in this document applies to any platform.
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]:  CORE(BRE): Failed to update calendar: <calendar ID>
[TASK]:[PxServiceCalendarSqlWriter]:  CORE(BRE): ORA-01745: invalid host/bind variable name
The issue can be reproduced at will with the following steps:
- Publish a project.
- The job shows as 'Failed'.
- Observe the reported error in the log file.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!