We weekly run a script that generates multiple files from different data sources. This script has multiple jobs that generate multiple xlsx and csv files. Now we have recently updated apache tomcat and for some reason all of the jobs that generate xlsx files have stopped working. The jobs that generate CSV files work fine. Example error:
Job Import_000_XXX start -- Tue Jul 14 07:35:07 CEST 2020
Exception in component tFileOutputExcel_1 (Import_010_XXX_ValidateImport)
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:431)
at java.security.AccessController.doPrivileged(Native Method)
at sun.font.SunFontManager.<init>(SunFontManager.java:376)
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:674)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:695)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:87)
at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:135)
at XXX_XX.import_010_XXX_Validateimport_0_3.Import_010_XXX_ValidateImport.tFileInputDelimited_1Process(Import_010_XXX_ValidateImport.java:9303)
at XXX_XX.import_010_XXX_Validateimport_0_3.Import_010_XXX_ValidateImport.runJobInTOS(Import_010_XXX_ValidateImport.java:22222)
at XXX_XX.import_010_XXX_Validateimport_0_3.Import_010_XXX_ValidateImport.runJob(Import_010_XXX_ValidateImport.java:21332)
at XXX_XX.import_000_XXX_0_3.Import_000_XXX.tRunJob_5Process(Import_000_XXX.java:5753)
at XXX_XX.import_000_XXX_0_3.Import_000_XXX.tJava_2Process(Import_000_XXX.java:4592)
at XXX_XX.import_000_XXX_0_3.Import_000_XXX.runJobInTOS(Import_000_XXX.java:55568)
at XXX_XX.import_000_XXX_0_3.Import_000_XXX.runJob(Import_000_XXX.java:54651)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.tRunJob_24Process(Import_000_XX_Main_XXX.java:17097)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.tRunJob_22Process(Import_000_XX_Main_XXX.java:16631)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.tRunJob_19Process(Import_000_XX_Main_XXX.java:16055)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.tRunJob_7Process(Import_000_XX_Main_XXX.java:15479)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.tRunJob_1Process(Import_000_XX_Main_XXX.java:14903)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.tRunJob_18Process(Import_000_XX_Main_XXX.java:14327)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.tRunJob_5Process(Import_000_XX_Main_XXX.java:13751)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.tJava_1Process(Import_000_XX_Main_XXX.java:13175)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.tJava_2Process(Import_000_XX_Main_XXX.java:12947)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.tRunJob_4Process(Import_000_XX_Main_XXX.java:12724)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.runJobInTOS(Import_000_XX_Main_XXX.java:40146)
at XXX_XX.import_000_XX_main_XXX_0_1.Import_000_XX_Main_XXX.main(Import_000_XX_Main_XXX.java:39136)
**ERROR** XXX.xlsx import file cant be found!
Job Import_000_XXX end -- Tue Jul 14 07:35:08 CEST 2020
Anyone else encountered this problem before ? If any more information is needed let me know, thanks!
Thanks for your reply. We do not make use of the Talend Administration Center. The job that we are running has always worked and still works in different environments. But when we decided to upgrade apache tomcat the same script that always has worked partly stopped working.
The solution was that after some updates done on the server there was no default font file available. After installing packages the script worked again.
