https://community.qlik.com/t5/Connectivity-Data-Prep/Query-with-error-in-PLSQL-does-not-throw-an-error-in-Qlik-Sense/m-p/1638930#M4544 <P>Hey everyone,</P><P>A rather unusual issue here: Using the Oracle connector from Qlik Sense, I am running a specific single query - SELECT * FROM RANDOM_VIEW - which includes single-row subqueries in the SELECT statement of the view. Due to an issue in the underlying data, this query <STRONG>should</STRONG> fail with an ORA-01427 (single-row subquery returns more than one row) message. This is indeed the case when I run the query from PL/SQL Developer, but when I run the same query from Qlik Sense, it behaves oddly; Instead of throwing an error message and stopping, it doesn't throw an error message and returns partial data (up to the point where the ORA-01427 occurred).</P><P>I have not changed the ErrorMode defaults.</P><P>Has anyone experienced this issue or anything similar to it, where a query returns partial data instead of failing with an error as it should? I'm stumped as to how to further troubleshoot this issue.</P><P>Thanks!</P> Wed, 15 Dec 2021 18:45:27 GMT Or 2021-12-15T18:45:27Z https://community.qlik.com/t5/Connectivity-Data-Prep/Query-with-error-in-PLSQL-does-not-throw-an-error-in-Qlik-Sense/m-p/1638930#M4544 <P>Hey everyone,</P><P>A rather unusual issue here: Using the Oracle connector from Qlik Sense, I am running a specific single query - SELECT * FROM RANDOM_VIEW - which includes single-row subqueries in the SELECT statement of the view. Due to an issue in the underlying data, this query <STRONG>should</STRONG> fail with an ORA-01427 (single-row subquery returns more than one row) message. This is indeed the case when I run the query from PL/SQL Developer, but when I run the same query from Qlik Sense, it behaves oddly; Instead of throwing an error message and stopping, it doesn't throw an error message and returns partial data (up to the point where the ORA-01427 occurred).</P><P>I have not changed the ErrorMode defaults.</P><P>Has anyone experienced this issue or anything similar to it, where a query returns partial data instead of failing with an error as it should? I'm stumped as to how to further troubleshoot this issue.</P><P>Thanks!</P> Wed, 15 Dec 2021 18:45:27 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Query-with-error-in-PLSQL-does-not-throw-an-error-in-Qlik-Sense/m-p/1638930#M4544 Or 2021-12-15T18:45:27Z https://community.qlik.com/t5/Connectivity-Data-Prep/Query-with-error-in-PLSQL-does-not-throw-an-error-in-Qlik-Sense/m-p/2121746#M12839 <P>Hi Can Anyone Help on This. Facing Similar issue</P> Mon, 25 Sep 2023 01:56:03 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Query-with-error-in-PLSQL-does-not-throw-an-error-in-Qlik-Sense/m-p/2121746#M12839 rajeshwar1 2023-09-25T01:56:03Z