My Oracle Support Banner

Jobs Fail with Error "Conversion failed when converting date and/or time from character string" When Using a SQL Server Database (Doc ID 2757786.1)

Last updated on MARCH 15, 2021

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 19.12.12.0 and later
Primavera P6 Professional Project Management - Version 19.12.12.0 and later
Information in this document applies to any platform.

Symptoms

All Job Services jobs (ex. XML Import/Export, Summarization, Create/Maintain Baseline, Copy Project, etc.) fail with the following error messages:

Exception: EprmDBSQLExecutionFailure [pop-up]
Message [tab]
Application Exception
Type: EprmDBSQLExecutionFailure
Event Code: PRMDB-3831-3
Description: PRM DBAccess Error: SQL State: 1, SQL Error Code: 241, Level: 16, Procedure: , Line: 1 Conversion failed when converting date and/or time from character string.

Exception: TDBXError [pop-up]
Message [tab]
Application Exception
Type: TDBXError
Event Code: VTRAJ-2263-6
Description: TCVirtualTable.RefreshAppend: JOBSVC: SQL State: 1, SQL Error Code: 241, Level: 16, Procedure: , Line:1 Conversion failed when converting date and/or time from character string.
Time: 03-Mar-21 15:03:58

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.