Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string

Hi All,

I am fetching data from one table in oracle using oledb connection into QlikView and getting the following error :

ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string

Earlier I was using odbc connection, and it was all working fine.

While analyzing the issue, I found that the issue is occurring due to one field which is having datatype as "Number" in oracle.

Does any one have idea how to resolve this?

Thanks in advance!

Regards,

Nawaz

Labels (1)
0 Replies