oledb connnectivity error in Qlikview Dashboard

[navaneeth79]

i 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!

[Anil_Babu_Samineni]

Can you share your date format in select statement

[navaneeth79]

The error is not in date field and we are getting error in a filed which has data type NUMBER

[Anil_Babu_Samineni]

Yes, This error en-count to only Date format issue? Better to make troubleshoot where you are writing SQL query in your statement? Or else please post the line which error tuck into preview

[navaneeth79]

Issue is not occurring due to date, it is occurring due to NUMBER datatype field.

Please find the below code which we are using in qlikview.

SQL select

AP_KEY

from

xyz;

//AP_KEY is the field in oracle having datatype as "NUMBER"