tsendmail error

[MaryL]

Hello!

Could you please suggest what cause of this error?

at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:88)

at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:135)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:339)

... 7 more

detail of tSendMail:

[Anonymous]

Can you upload the full log messages printed on the console?

Regards

Shong

[MaryL]

Exception in thread "Thread-0" java.lang.OutOfMemoryError: GC overhead limit exceeded

at java.util.LinkedList.listIterator(Unknown Source)

at java.util.AbstractList.listIterator(Unknown Source)

at java.util.AbstractSequentialList.iterator(Unknown Source)

at routines.system.RunStat.sendMessages(RunStat.java:280)

at routines.system.RunStat.run(RunStat.java:244)

at java.lang.Thread.run(Unknown Source)

Exception in component tFileOutputExcel_1 (f2_fin_mon)

java.io.IOException: GC overhead limit exceeded

at org.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:351)

at org.apache.poi.ss.usermodel.WorkbookFactory.createXSSFWorkbook(WorkbookFactory.java:314)

at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:232)

at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:198)

at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:114)

at dwh.f2_fin_mon_0_1.f2_fin_mon.tDBInput_1Process(f2_fin_mon.java:1564)

at dwh.f2_fin_mon_0_1.f2_fin_mon.runJobInTOS(f2_fin_mon.java:3168)

at dwh.f2_fin_mon_0_1.f2_fin_mon.main(f2_fin_mon.java:3006)

Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded

at java.util.Arrays.copyOfRange(Unknown Source)

at java.lang.String.<init>(Unknown Source)

at org.apache.xmlbeans.impl.store.CharUtil.getString(CharUtil.java:97)

at org.apache.xmlbeans.impl.store.Xobj.getValueAsString(Xobj.java:1196)

at org.apache.xmlbeans.impl.store.Xobj.fetch_text(Xobj.java:1814)

at org.apache.xmlbeans.impl.values.XmlObjectBase.get_wscanon_text(XmlObjectBase.java:1377)

at org.apache.xmlbeans.impl.values.XmlObjectBase.check_dated(XmlObjectBase.java:1314)

at org.apache.xmlbeans.impl.values.XmlObjectBase.getStringValue(XmlObjectBase.java:1529)

at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTCellImpl.getR(Unknown Source)

at org.apache.poi.xssf.usermodel.XSSFCell.<init>(XSSFCell.java:117)

at org.apache.poi.xssf.usermodel.XSSFRow.<init>(XSSFRow.java:75)

at org.apache.poi.xssf.usermodel.XSSFSheet.initRows(XSSFSheet.java:268)

at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:231)

at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:218)

at org.apache.poi.xssf.usermodel.XSSFWorkbook.parseSheet(XSSFWorkbook.java:448)

at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:413)

at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:184)

at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:282)

at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:88)

at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:135)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:339)

... 7 more

[Anonymous]

@Maryna Lykhoshva​ , It is an OutOfMemory error, please read this KB article and try to optimize the job design and allocate more memory to the job exectuion.

Regard

Shong

[MaryL]

Thank you!