KNOWLEDGE BASE

Error: "Invalid datetime value Error Code: DD90F63D" connecting to oracle


Published: 29 Oct 2020
Last Modified Date: 11 Dec 2020

Issue

While creating an extract from Oracle datasources, the following error occur can occur if your date is using dates in the 0400/01/01 - 9999/12/31 range:

"Unable to complete action

Invalid datetime value

Error Code: DD90F63D

Unable to create extract"

 

Environment

  • Tableau Desktop 2020.1 / 2020.2 / 2020.3
  • Oracle

Resolution

Option 1

Check data set and remove date that are out of range 0400/01/01 - 9999/12/31. If they are (for example if you are using biblical dates of 0046) you will need to remove these dates.

Option 2

Upgrade to Tableau Desktop 2020.2.7 and later (October 2020 maintenance releases)

Cause

ojdbc8.jar (driver for 2020.1-2020.3) not handle date out of range 0400/01/01 - 9999/12/31 correctly. This is fixed in all Tableau builds of 2020.1.10, 2020.2.7, 2020.3.2 and higher.
Did this article resolve the issue?