My Oracle Support Banner

Various Functions in P6 EPPM Fail with the Following Error: The Conversion Of The Data Type Varchar To Datetime Produced An Out-of-range Value (Doc ID 2873106.1)

Last updated on MARCH 20, 2024

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
Primavera hangs while trying to use multiple functionalities, avoiding the completion of certain actions, such as Global Search & Replace that include date type UDFs.
Checking the P6WebAccess.html file the following error is found.

The conversion of the data type varchar to datetime produced an out-of-range value

EXPECTED BEHAVIOR
-----------------------
Every functionality, such as Global Search & Replace for date type UDFs, should work normally, without errors.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to EPS > Actions > Global Search & Replace
2. Apply a Global S&R with a date type UDF
3. Primavera hangs if the Global S&R has a filter.
4. The Global S&R is applied if it has no filters. But then, the job fails.

NOTE: This issue is specific to using a Microsoft SQL Server database utilizing Spanish as the language set.

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!


In this Document
Symptoms
Cause
Solution
References


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