https://community.qlik.com/t5/Talend-Studio/Oracle-return-137-when-process-hanged-using-tDBBulkExec/m-p/2294798#M67640 <P>Hi All,</P><P></P><P></P><P>I''m using tDBBulkExec for using my own CTL file to load data.</P><P></P><P></P><P>I found that sometimes is will hang and do nothing, no log was generated from CTL file.</P><P>The source file only has 1 record...</P><P></P><P></P><P>I killed the sqlldr process with kill -9 process id.</P><P>It return code is 137 (((Integer)globalMap.get("tDBBulkExec_1_RETURN_CODE"))).</P><P></P><P></P><P>Environment:</P><P>Linux</P><P>Oracle 12c</P><P>ojdbc7</P><P></P><P></P><P>CTL file setting:</P><P>OPTIONS (SKIP=1,DIRECT=FALSE)</P><P></P><P></P><P>May I know does anyone has encountered same issue and what is the resolution? </P><P></P><P></P><P>Many thanks.</P><P></P><P></P> Sat, 16 Nov 2024 01:23:48 GMT CLi1594691515 2024-11-16T01:23:48Z https://community.qlik.com/t5/Talend-Studio/Oracle-return-137-when-process-hanged-using-tDBBulkExec/m-p/2294798#M67640 <P>Hi All,</P><P></P><P></P><P>I''m using tDBBulkExec for using my own CTL file to load data.</P><P></P><P></P><P>I found that sometimes is will hang and do nothing, no log was generated from CTL file.</P><P>The source file only has 1 record...</P><P></P><P></P><P>I killed the sqlldr process with kill -9 process id.</P><P>It return code is 137 (((Integer)globalMap.get("tDBBulkExec_1_RETURN_CODE"))).</P><P></P><P></P><P>Environment:</P><P>Linux</P><P>Oracle 12c</P><P>ojdbc7</P><P></P><P></P><P>CTL file setting:</P><P>OPTIONS (SKIP=1,DIRECT=FALSE)</P><P></P><P></P><P>May I know does anyone has encountered same issue and what is the resolution? </P><P></P><P></P><P>Many thanks.</P><P></P><P></P> Sat, 16 Nov 2024 01:23:48 GMT https://community.qlik.com/t5/Talend-Studio/Oracle-return-137-when-process-hanged-using-tDBBulkExec/m-p/2294798#M67640 CLi1594691515 2024-11-16T01:23:48Z