https://community.qlik.com/t5/Talend-Studio/resolved-tOracleOutput-tries-to-insert-0-rows/m-p/2303764#M75606 <P>Hi i have the following job:<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFqx.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133789i391A24FB87794E08/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFqx.jpg" alt="0683p000009MFqx.jpg" /></span><BR /><BR />It's not an error that 0 rows are fetched, i don't understand why fillRectifica (toracleouput) it's trying to insert if there are no rows.&nbsp;<BR />I need to figure out a way to filter the insertion in case 0 rows pass throught the filterNull filter.<BR />Thank you for your help.<BR /><BR /><STRONG>EDITION 2016-12-17</STRONG><BR /><STRONG><FONT color="#3333ff">SOLVED: The problem is not that the tOracleOutput is trying to insert a null row, but that the if condition in at it's output doesn't find the variable to evaluate. Thanks <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span></FONT></STRONG></P> Fri, 16 Dec 2016 21:13:20 GMT Anonymous 2016-12-16T21:13:20Z https://community.qlik.com/t5/Talend-Studio/resolved-tOracleOutput-tries-to-insert-0-rows/m-p/2303764#M75606 <P>Hi i have the following job:<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFqx.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133789i391A24FB87794E08/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFqx.jpg" alt="0683p000009MFqx.jpg" /></span><BR /><BR />It's not an error that 0 rows are fetched, i don't understand why fillRectifica (toracleouput) it's trying to insert if there are no rows.&nbsp;<BR />I need to figure out a way to filter the insertion in case 0 rows pass throught the filterNull filter.<BR />Thank you for your help.<BR /><BR /><STRONG>EDITION 2016-12-17</STRONG><BR /><STRONG><FONT color="#3333ff">SOLVED: The problem is not that the tOracleOutput is trying to insert a null row, but that the if condition in at it's output doesn't find the variable to evaluate. Thanks <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span></FONT></STRONG></P> Fri, 16 Dec 2016 21:13:20 GMT https://community.qlik.com/t5/Talend-Studio/resolved-tOracleOutput-tries-to-insert-0-rows/m-p/2303764#M75606 Anonymous 2016-12-16T21:13:20Z https://community.qlik.com/t5/Talend-Studio/resolved-tOracleOutput-tries-to-insert-0-rows/m-p/2303765#M75607 Hi,<BR />Thanks for posting that you have resolved it by yourself.<BR />Best regards<BR />Sabrina Mon, 19 Dec 2016 02:43:22 GMT https://community.qlik.com/t5/Talend-Studio/resolved-tOracleOutput-tries-to-insert-0-rows/m-p/2303765#M75607 Anonymous 2016-12-19T02:43:22Z