KNOWLEDGE BASE

Error "ORA-01843: Not a Valid Month" When Refreshing Data Source Extract


Published: 28 Jun 2014
Last Modified Date: 10 Sep 2017

Issue

When refreshing data source extract, the following error might occur:

Oracle database error 1843: ORA-01843: not a valid month 
Unable to create extract 
 

Environment

  • Tableau Desktop
  • Tableau Server

Resolution

In Tableau Desktop, remove the extract and extract file, and then recreate the extract.
  1. Right-click the data source.
  2. Choose Extract > Remove.
  3. Select Remove the extract and delete the extract file.
  4. Create a new extract from the data source.
  5. If applicable, republish the extract to Tableau Server.

Additional Information

Other workbook elements, like calculation, could break after recreating the extract.
Did this article resolve the issue?