My Oracle Support Banner

Error: "Start_date: Invalid Value or Data Type Mismatch" When Importing XLS file (Doc ID 2428746.1)

Last updated on MARCH 07, 2019

Applies to:

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

Symptoms

When attempting to import XLS file, the following error occurs:

ERROR
-----------------------
ERROR: Column start_date: Invalid value or data type mismatch. Discarding the value.
ERROR: Column end_date: Invalid value or data type mismatch. Discarding the value.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Login to P6 Pro as Admin SuperUser.
  2. Export Project to XLS file.
  3. Try to import the XLS file back to P6 without modification.

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!


In this Document
Symptoms
Changes
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.