topic Re: Sybase connection questionable in QlikView https://community.qlik.com/t5/QlikView/Sybase-connection-questionable/m-p/444110#M165592 <HTML><HEAD></HEAD><BODY><P>Maybe you've already solved this problem, since it is already a couple of months. But since no one has responded yet I will try. </P><P></P><P>I noticed the same problem with some Sybase queries in Qlikview. The cause was: warnings. When a query raises an error it is catched by Qlikview en the load wil abort. </P><P>However, sometimes you don't get an error but a warning (e.g. with an arithmetic overflow). In that case Qlikview will continue the load as if nothing happened, but after the warning no records are returned to Qlikview. </P><P></P><P>So the question is: will the queries run OK and without warnings if you run them in a query tool?</P></BODY></HTML> Wed, 10 Apr 2013 12:05:51 GMT 2013-04-10T12:05:51Z Sybase connection questionable https://community.qlik.com/t5/QlikView/Sybase-connection-questionable/m-p/444109#M165591 <HTML><HEAD></HEAD><BODY><P>I have run into numerous problems where, for no apparent reason, a very simple sql query run through qlikview via ODBC connection returns less rows than it should.&nbsp; There is no error returned and the script continues running as if there is no problem.&nbsp; This is a query run every day and normally does not have this problem.&nbsp; I have also seen this problem occur with other queries I run daily against Sybase database.&nbsp; I am using a Sybase ASE OLE DB connector.</P><P></P><P>Has anyone seen this problem before?</P></BODY></HTML> Mon, 17 Dec 2012 20:26:35 GMT https://community.qlik.com/t5/QlikView/Sybase-connection-questionable/m-p/444109#M165591 scotthan 2012-12-17T20:26:35Z Re: Sybase connection questionable https://community.qlik.com/t5/QlikView/Sybase-connection-questionable/m-p/444110#M165592 <HTML><HEAD></HEAD><BODY><P>Maybe you've already solved this problem, since it is already a couple of months. But since no one has responded yet I will try. </P><P></P><P>I noticed the same problem with some Sybase queries in Qlikview. The cause was: warnings. When a query raises an error it is catched by Qlikview en the load wil abort. </P><P>However, sometimes you don't get an error but a warning (e.g. with an arithmetic overflow). In that case Qlikview will continue the load as if nothing happened, but after the warning no records are returned to Qlikview. </P><P></P><P>So the question is: will the queries run OK and without warnings if you run them in a query tool?</P></BODY></HTML> Wed, 10 Apr 2013 12:05:51 GMT https://community.qlik.com/t5/QlikView/Sybase-connection-questionable/m-p/444110#M165592 2013-04-10T12:05:51Z