https://community.qlik.com/t5/Talend-Studio/GC-Overhead-limit-exceeded/m-p/2448829#M140599 <P>I am trying to create a excel file with 1000k records and I am getting this error everytime I run the job</P> <DIV>&nbsp;</DIV> <DIV>Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded</DIV> <DIV><SPAN> at org.apache.commons.lang.text.StrBuilder.&lt;init&gt;(StrBuilder.java:115)</SPAN></DIV> <DIV><SPAN> at org.apache.commons.lang.StringUtils.replace(StringUtils.java:3815)</SPAN></DIV> <DIV><SPAN> at org.apache.commons.lang.StringUtils.replace(StringUtils.java:3771)</SPAN></DIV> <DIV><SPAN> at routines.FileProcessor.process(FileProcessor.java:101)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.tDBInput_2Process(jb_create_excel.java:12371)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.tDBInput_1Process(jb_create_excel.java:9616)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.tJava_4Process(jb_create_excel.java:8872)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.tLoop_1Process(jb_create_excel.java:8558)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.tJava_3Process(jb_create_excel.java:8096)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.runJobInTOS(jb_create_excel.java:21758)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.runJob(jb_create_excel.java:20852)</SPAN></DIV> <P>&nbsp;</P> <P>I have increased the xmx parameter to 128gb but still it shows this error. Any other way that I could fix it?</P> Sat, 04 May 2024 18:35:23 GMT AgarwalS5 2024-05-04T18:35:23Z https://community.qlik.com/t5/Talend-Studio/GC-Overhead-limit-exceeded/m-p/2448829#M140599 <P>I am trying to create a excel file with 1000k records and I am getting this error everytime I run the job</P> <DIV>&nbsp;</DIV> <DIV>Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded</DIV> <DIV><SPAN> at org.apache.commons.lang.text.StrBuilder.&lt;init&gt;(StrBuilder.java:115)</SPAN></DIV> <DIV><SPAN> at org.apache.commons.lang.StringUtils.replace(StringUtils.java:3815)</SPAN></DIV> <DIV><SPAN> at org.apache.commons.lang.StringUtils.replace(StringUtils.java:3771)</SPAN></DIV> <DIV><SPAN> at routines.FileProcessor.process(FileProcessor.java:101)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.tDBInput_2Process(jb_create_excel.java:12371)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.tDBInput_1Process(jb_create_excel.java:9616)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.tJava_4Process(jb_create_excel.java:8872)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.tLoop_1Process(jb_create_excel.java:8558)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.tJava_3Process(jb_create_excel.java:8096)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.runJobInTOS(jb_create_excel.java:21758)</SPAN></DIV> <DIV><SPAN> at fi_528.jb_create_excel_0_31.jb_create_excel.runJob(jb_create_excel.java:20852)</SPAN></DIV> <P>&nbsp;</P> <P>I have increased the xmx parameter to 128gb but still it shows this error. Any other way that I could fix it?</P> Sat, 04 May 2024 18:35:23 GMT https://community.qlik.com/t5/Talend-Studio/GC-Overhead-limit-exceeded/m-p/2448829#M140599 AgarwalS5 2024-05-04T18:35:23Z https://community.qlik.com/t5/Talend-Studio/GC-Overhead-limit-exceeded/m-p/2449110#M140600 <P>Hi</P> <P>Take a look at this KB <A href="https://community.qlik.com/t5/Official-Support-Articles/Talend-Studio-OutOfMemory-Exception/ta-p/2151392" target="_self">article</A> that might be helpful, see if you can optimize the job.</P> <P>Regards,<BR />Shicong</P> Mon, 06 May 2024 07:51:46 GMT https://community.qlik.com/t5/Talend-Studio/GC-Overhead-limit-exceeded/m-p/2449110#M140600 Shicong_Hong 2024-05-06T07:51:46Z