My Oracle Support Banner

The Publish Audit Data Service Fails With the Following Error - Conversion Failed when Converting Date and/or Time from Character String (Doc ID 2942953.1)

Last updated on MARCH 20, 2024

Applies to:

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

Symptoms

When attempting to execute the Publish Audit Data service,
the following error occurs.

ERROR
-----------------------
Conversion failed when converting date and/or time from character string.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Login to P6 EPPM
2.  Execute the Publish Audit Data service.

Changes

The P6 EPPM database has been migrated from Oracle to Microsoft SQL Server. 

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
Changes
Cause
Solution


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