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

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


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

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


  • Tableau Desktop
  • Tableau Server


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?