Loading

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

Publiceringsdatum: Apr 30, 2025
Beskrivning

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.
 
Knowledge-artikelnummer

001534832

 
Laddar
Salesforce Help | Article