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 |