Exception in component tFileOutputExcel

KXXX1603881758 — Sat, 16 Nov 2024 01:13:25 GMT

Hello,

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!

Re: Exception in component tFileOutputExcel

Anonymous — Fri, 30 Oct 2020 08:15:45 GMT

Hello,

Did you have a generation problem in the Talend Administration Center (TAC) even if your Job runs successfully in the Studio?

Are you able to export the Job as a Jobscript from the Studio to make sure the export is working?

Best regards

Sabrina

Re: Exception in component tFileOutputExcel

KXXX1603881758 — Fri, 30 Oct 2020 08:42:58 GMT

Hello Sabrina,

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.

Kind regards,

Kevin

Re: Exception in component tFileOutputExcel

Anonymous — Mon, 02 Nov 2020 07:10:47 GMT

Hello,

Did you try to deploy it on tomcat server with war file? The WR method of deployment is deprecated from 6.4 version onward.

Could you please try the below approach and let us know if it works?

https://help.talend.com/reader/_xjxP5Kopg4MCFbPK2UK3g/w~a2mD8D8CKkon5Ut2WC8A

Best regards

Sabrina

Re: Exception in component tFileOutputExcel

KXXX1603881758 — Fri, 27 Nov 2020 12:20:36 GMT

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.

topic Re: Exception in component tFileOutputExcel in Talend Studio

Exception in component tFileOutputExcel

Re: Exception in component tFileOutputExcel

Re: Exception in component tFileOutputExcel

Re: Exception in component tFileOutputExcel

Re: Exception in component tFileOutputExcel