KNOWLEDGE BASE

Error "failure Evaluating To Database: Oracle Database Error 1858" Upon Running The Flow


Published: 22 May 2020
Last Modified Date: 28 May 2020

Issue

Upon running the flow with Oracle data source, the following error occurs:

"Failure evaluating to database: Oracle database error 1858: ORA-01858: a non-numeric character found where a numeric was expected Try running the flow again or review the log file for more details."



 

Environment

  • Tableau Prep Builder
  • Windows 10
  • Oracle

Resolution

1. Fix the input data to conform to the format which is used in the flow.
or
2. Correct the date format model in the flow to ensure that the elements match in number and type in the database.

Cause

The input data to be converted using a date format model is incorrect. The input data did not contain a number where a number was required by the format model.

Additional Information

For example,

1)
SQL> select to_date(’10-JUN-2014’, ‘DD-MM-YYYY’) from dual;
ERROR:

ORA-01858: a non-numeric character was found where a numeric was expected
no rows selected

2)
SQL> select to_date(’10-JUN-2014’, ‘DD-MON-YYYY’) from dual
2 /
TO_DATE( ‘ 10
10-JUN-2014

This allows the statement to run smoothly.

Did this article resolve the issue?