topic ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string in QlikView https://community.qlik.com/t5/QlikView/ErrorSource-OraOLEDB-ErrorMsg-ORA-01861-literal-does-not-match/m-p/61931#M10346 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am fetching data from one table in oracle using oledb connection into QlikView and getting the following error :</P><P>ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string</P><P></P><P>Earlier I was using odbc connection, and it was all working fine. </P><P></P><P>While analyzing the issue, I found that the issue is occurring due to one field which is having datatype as "Number" in oracle.</P><P></P><P>Does any one have idea how to resolve this?</P><P></P><P>Thanks in advance!</P><P></P><P>Regards,</P><P>Nawaz</P></BODY></HTML> Thu, 05 Apr 2018 12:35:58 GMT Anonymous 2018-04-05T12:35:58Z ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string https://community.qlik.com/t5/QlikView/ErrorSource-OraOLEDB-ErrorMsg-ORA-01861-literal-does-not-match/m-p/61931#M10346 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am fetching data from one table in oracle using oledb connection into QlikView and getting the following error :</P><P>ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string</P><P></P><P>Earlier I was using odbc connection, and it was all working fine. </P><P></P><P>While analyzing the issue, I found that the issue is occurring due to one field which is having datatype as "Number" in oracle.</P><P></P><P>Does any one have idea how to resolve this?</P><P></P><P>Thanks in advance!</P><P></P><P>Regards,</P><P>Nawaz</P></BODY></HTML> Thu, 05 Apr 2018 12:35:58 GMT https://community.qlik.com/t5/QlikView/ErrorSource-OraOLEDB-ErrorMsg-ORA-01861-literal-does-not-match/m-p/61931#M10346 Anonymous 2018-04-05T12:35:58Z