Exception in component tFileOutputExcel_1 null java.lang.NullPointerException: null

[JayZ1]

I have a job that runs perfectly fine on my local machine as well as our development environment, however when I deploy it to our QA environments it fails due to an error:

tFileOutputExcel_1 null

java.lang.NullPointerException: null

No idea why this isn't working and I am unable to figure out more information to why this would fail in QA but not dev or locally. The output location exists in both dev/QA so that should not be an issue.

Any help is appreciated!

[FATAL] 19:09:40 .- tFileOutputExcel_1 null

java.lang.NullPointerException: null

at sun.awt.FontConfiguration.getVersion(FontConfiguration.java:1264) ~[?:1.8.0_302]

at sun.awt.FontConfiguration.readFontConfigFile(FontConfiguration.java:219) ~[?:1.8.0_302]

at sun.awt.FontConfiguration.init(FontConfiguration.java:107) ~[?:1.8.0_302]

at sun.awt.X11FontManager.createFontConfiguration(X11FontManager.java:774) ~[?:1.8.0_302]

at sun.font.SunFontManager$2.run(SunFontManager.java:441) ~[?:1.8.0_302]

at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_302]

at sun.font.SunFontManager.<init>(SunFontManager.java:386) ~[?:1.8.0_302]

at sun.awt.FcFontManager.<init>(FcFontManager.java:35) ~[?:1.8.0_302]

at sun.awt.X11FontManager.<init>(X11FontManager.java:57) ~[?:1.8.0_302]

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_302]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_302]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_302]

at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_302]

at java.lang.Class.newInstance(Class.java:442) ~[?:1.8.0_302]

at sun.font.FontManagerFactory$1.run(FontManagerFactory.java:83) ~[?:1.8.0_302]

at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_302]

at sun.font.FontManagerFactory.getInstance(FontManagerFactory.java:74) ~[?:1.8.0_302]

at java.awt.Font.getFont2D(Font.java:491) ~[?:1.8.0_302]

at java.awt.Font.canDisplayUpTo(Font.java:2064) ~[?:1.8.0_302]

at java.awt.font.TextLayout.singleFont(TextLayout.java:470) ~[?:1.8.0_302]

at java.awt.font.TextLayout.<init>(TextLayout.java:531) ~[?:1.8.0_302]

at org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:273) ~[poi-4.1.2-20200903124306_modified_talend.jar:4.1.2-20200903124306_modified_talend]

at org.apache.poi.xssf.streaming.AutoSizeColumnTracker.<init>(AutoSizeColumnTracker.java:117) ~[poi-ooxml-4.1.2-20200903124306_modified_talend.jar:4.1.2-20200903124306_modified_talend]

at org.apache.poi.xssf.streaming.SXSSFSheet.<init>(SXSSFSheet.java:82) ~[poi-ooxml-4.1.2-20200903124306_modified_talend.jar:4.1.2-20200903124306_modified_talend]

at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:684) ~[poi-ooxml-4.1.2-20200903124306_modified_talend.jar:4.1.2-20200903124306_modified_talend]

at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:705) ~[poi-ooxml-4.1.2-20200903124306_modified_talend.jar:4.1.2-20200903124306_modified_talend]

at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:88) ~[poi-ooxml-4.1.2-20200903124306_modified_talend.jar:4.1.2-20200903124306_modified_talend]

at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:134) ~[talendExcel-1.14-20220912.jar:?]

[statistics] disconnected

[INFO ] 19:09:40 TalendJob: '' - Finished - status: failure returnCode: 1

Exception in component tFileOutputExcel_1 )

java.lang.NullPointerException

at sun.awt.FontConfiguration.getVersion(FontConfiguration.java:1264)

at sun.awt.FontConfiguration.readFontConfigFile(FontConfiguration.java:219)

at sun.awt.FontConfiguration.init(FontConfiguration.java:107)

at sun.awt.X11FontManager.createFontConfiguration(X11FontManager.java:774)

at sun.font.SunFontManager$2.run(SunFontManager.java:441)

at java.security.AccessController.doPrivileged(Native Method)

at sun.font.SunFontManager.<init>(SunFontManager.java:386)

at sun.awt.FcFontManager.<init>(FcFontManager.java:35)

at sun.awt.X11FontManager.<init>(X11FontManager.java:57)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at java.lang.Class.newInstance(Class.java:442)

at sun.font.FontManagerFactory$1.run(FontManagerFactory.java:83)

at java.security.AccessController.doPrivileged(Native Method)

at sun.font.FontManagerFactory.getInstance(FontManagerFactory.java:74)

at java.awt.Font.getFont2D(Font.java:491)

at java.awt.Font.canDisplayUpTo(Font.java:2064)

at java.awt.font.TextLayout.singleFont(TextLayout.java:470)

at java.awt.font.TextLayout.<init>(TextLayout.java:531)

at org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:273)

at org.apache.poi.xssf.streaming.AutoSizeColumnTracker.<init>(AutoSizeColumnTracker.java:117)

at org.apache.poi.xssf.streaming.SXSSFSheet.<init>(SXSSFSheet.java:82)

at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:684)

at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:705)

at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:88)

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

[Anonymous]

Hi

Please share a screenshot of basic setting panel of tFileOutputExcel_1, in addition, I suggest you to check if the two environment have the same Java version?

Regards

Shong

[Nirupam]

I am facing rhe same problem. running in dev but not in QA