KNOWLEDGE BASE

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


Published: 28 Jun 2014
Last Modified Date: 28 Jun 2016

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

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.

Additional Information

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