Error Message

[alex-wb]

Hi all,

I am wondering why I get the below error message when I try to load a view into QLIK. It's okay when I load the data as a table, but it doesn't like the view. The issue seems to be with the below bit of SQL

Thanks,

Alex

[Or]

This sounds like an issue with your Oracle view, not a Qlik issue. As per the message, it seems like the data is returning a non-numeric character in a location where a numeric value (such as month or hour) is expected.

[alex-wb]

I don't think this is the case though. I can look at the structure of the table and as you can see it correctly returns the column as a date 

[Or]

You can test this by running the code as a query (rather than using the view) without the TO_DATE aspects. But as I said, this does not appear to be a Qlik issue so you're likely to have better luck asking about it in an Oracle-centric location.

[marcus_sommer]

Qlik could be excluded as cause because it didn't touch the SQL. Beside any potential issues to your cast-syntax you should take a look on the used driver which may not compatible to your code and/or data-base (32 bit vs. 64 bit driver, the release and with it the support of newer features, ...).

[Chip_Matejowsky]

HI @alex-wb,

As both @Or  and @marcus_sommer stated this issue is occurring on the data side and not the QlikView side. QlikView is returning the error because that is what it is receiving from the data source.

I searched the Oracle 01858 error and found the following:

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

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

Action: Fix the input data or the date format model to make sure the elements match in number and type. Then retry the operation.

http://www.dba-oracle.com/t_ora_01858_non_numeric.htm

https://www.tekstream.com/resource-center/ora-01858-error-message/

Suggest you reach out to your DBA for further assistance with this Oracle error.

Best Regards