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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-04-05 08:35 AM

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

1 user say ditto
636 Views
0 Likes
0 Replies