https://community.qlik.com/t5/Talend-Studio/Problems-with-OracleInput-NullPointerException-and/m-p/2314046#M84848 <BLOCKQUOTE> jlolling wrote: <BR />Whow what a dangerous design! Why your tOracleInput_1 does not use its own connection? It simply does not make sense here to use a separate connection for it - not as far as I can see in your design.&nbsp; <BR />But your description of your problem and your own analysis was pretty good. </BLOCKQUOTE> <BR />I took this old design and added new components, that's why turned into a dangerous design. <BR />This job is actually looking for files in differents folders and then reads every row which then goes to the database. <BR /> <BR />After all this problem, I've changed the connections of tOracleRow_1 and tOracleInput_1 to they own connections. <BR /> <BR />Thanks Jlolling! Mon, 01 Aug 2016 16:59:07 GMT cox 2016-08-01T16:59:07Z https://community.qlik.com/t5/Talend-Studio/Problems-with-OracleInput-NullPointerException-and/m-p/2314043#M84845 <P>Hi Everyone!<BR />I'm having an error when trying to run my Job, that says NullPointerException in tOracleInput_1.<BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFZ8.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135167iCF726B7162BF95FA/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFZ8.jpg" alt="0683p000009MFZ8.jpg" /></span><BR /><BR /><BR />If I go to the code where the error seems to be generating (line 20056), it looks like the getSessionTimeZone it's the problem in here.<BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFZb.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146654i87259E1AC65FAF89/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFZb.jpg" alt="0683p000009MFZb.jpg" /></span><BR /><BR />The first thing that I did was to look if there was a null value inside the tOracleInput_1 table, but it wasn't.<BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFZg.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130148i6B01820890CE509B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFZg.jpg" alt="0683p000009MFZg.jpg" /></span><BR /><BR />Talend Version: 5.6.3 (Java)<BR />OS: Windows 7<BR /><BR />I hope that you can really give a hand with this!<BR />Thanks.</P> Thu, 28 Jul 2016 16:33:58 GMT https://community.qlik.com/t5/Talend-Studio/Problems-with-OracleInput-NullPointerException-and/m-p/2314043#M84845 cox 2016-07-28T16:33:58Z https://community.qlik.com/t5/Talend-Studio/Problems-with-OracleInput-NullPointerException-and/m-p/2314044#M84846 Hey guys, I think I solved it.<BR />tOracleInput was trying to load the table first than anything so tOracleConnection_2 wasn't started yet. Changing tOracleInput to tOracleConnection_1 solved this problem.<BR />The error message was totally different to the real problem, so I hope that if anyone has this problem this post could be helpfull.<BR /><BR />Thanks! Thu, 28 Jul 2016 22:13:26 GMT https://community.qlik.com/t5/Talend-Studio/Problems-with-OracleInput-NullPointerException-and/m-p/2314044#M84846 cox 2016-07-28T22:13:26Z https://community.qlik.com/t5/Talend-Studio/Problems-with-OracleInput-NullPointerException-and/m-p/2314045#M84847 Whow what a dangerous design! Why your tOracleInput_1 does not use its own connection? It simply does not make sense here to use a separate connection for it - not as far as I can see in your design.&nbsp;<BR />But your description of your problem and your own analysis was pretty good. Sat, 30 Jul 2016 20:05:01 GMT https://community.qlik.com/t5/Talend-Studio/Problems-with-OracleInput-NullPointerException-and/m-p/2314045#M84847 Anonymous 2016-07-30T20:05:01Z https://community.qlik.com/t5/Talend-Studio/Problems-with-OracleInput-NullPointerException-and/m-p/2314046#M84848 <BLOCKQUOTE> jlolling wrote: <BR />Whow what a dangerous design! Why your tOracleInput_1 does not use its own connection? It simply does not make sense here to use a separate connection for it - not as far as I can see in your design.&nbsp; <BR />But your description of your problem and your own analysis was pretty good. </BLOCKQUOTE> <BR />I took this old design and added new components, that's why turned into a dangerous design. <BR />This job is actually looking for files in differents folders and then reads every row which then goes to the database. <BR /> <BR />After all this problem, I've changed the connections of tOracleRow_1 and tOracleInput_1 to they own connections. <BR /> <BR />Thanks Jlolling! Mon, 01 Aug 2016 16:59:07 GMT https://community.qlik.com/t5/Talend-Studio/Problems-with-OracleInput-NullPointerException-and/m-p/2314046#M84848 cox 2016-08-01T16:59:07Z