Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
I am facing rhe same problem. running in dev but not in QA