Loading

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

Udgivelsesdato: Apr 30, 2025
Beskrivelse

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'
 

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").
Løsning
Verify the date value/format in Oracle and correct them before using the field in Tableau Prep flow.
 
Vidensartikelnummer

001534832

 
Indlæser
Salesforce Help | Article