"ORA-01840: input value not long enough for date format" error occurs when execute a flow

KNOWLEDGE BASE

"ORA-01840: input value not long enough for date format" error occurs when execute a flow

Published: 18 Aug 2023
Last Modified Date: 21 Aug 2023

Issue

When executing a flow connected to Oracle, the following error occurs.

System Error: AplProcessor evaluation failed: ORA-01840: input value not long enough for date format
or
System Error: An error occurred while communicating with the Oracle data source 'LoomDataSource'

Environment

Tableau Prep Builder
Oracle

Resolution

Verify the date value/format in Oracle and correct them before using the field in Tableau Prep flow.

Cause

A field that has been changed to Date type in Tableau Prep Builder contains values that cannot be recognized as dates (such as "0" or "99999999").

Click here to return to our Support page.

Open a new case

Click here to go to our Support page.

Get detailed answers and how-to step-by-step instructions for your issues and technical questions.

Find and share solutions with our active community through forums, user groups and ideas.

Browse a complete list of product manuals and guides. Available online, offline and PDF formats.

Learn how to master Tableau’s products with our on-demand, live or class room training.