Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
AgarwalS5
Contributor
Contributor

GC Overhead limit exceeded

I am trying to create a excel file with 1000k records and I am getting this error everytime I run the job

 
Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded
at org.apache.commons.lang.text.StrBuilder.<init>(StrBuilder.java:115)
at org.apache.commons.lang.StringUtils.replace(StringUtils.java:3815)
at org.apache.commons.lang.StringUtils.replace(StringUtils.java:3771)
at routines.FileProcessor.process(FileProcessor.java:101)
at fi_528.jb_create_excel_0_31.jb_create_excel.tDBInput_2Process(jb_create_excel.java:12371)
at fi_528.jb_create_excel_0_31.jb_create_excel.tDBInput_1Process(jb_create_excel.java:9616)
at fi_528.jb_create_excel_0_31.jb_create_excel.tJava_4Process(jb_create_excel.java:8872)
at fi_528.jb_create_excel_0_31.jb_create_excel.tLoop_1Process(jb_create_excel.java:8558)
at fi_528.jb_create_excel_0_31.jb_create_excel.tJava_3Process(jb_create_excel.java:8096)
at fi_528.jb_create_excel_0_31.jb_create_excel.runJobInTOS(jb_create_excel.java:21758)
at fi_528.jb_create_excel_0_31.jb_create_excel.runJob(jb_create_excel.java:20852)

 

I have increased the xmx parameter to 128gb but still it shows this error. Any other way that I could fix it?

Labels (1)
  • v7.x

1 Reply
Shicong_Hong
Employee
Employee

Hi

Take a look at this KB article that might be helpful, see if you can optimize the job.

Regards,
Shicong