Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
mpantos
Contributor
Contributor

Error when running compiled code

Hi,
I am a relatively new user and am receiving the following error using installed components:
Exception in thread "main" java.lang.NoSuchMethodError: org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(Lorg/apache/poi/ss/usermodel/Workbook: ) I
    at org.apache.poi.xssf.streaming.AutoSizeColumnTracker.<init>(AutoSizeColumnTracker.java:117)
    at org.apache.poi.xssf.streaming.SXSSFSheet.<init>(SXSSFSheet.java:78)
    at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:624)
    at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:645)
    at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:131)
    at hosted_files.CustomerName_excel_zippricat_copy_0_1.CustomerName_excel_zipPRICAT_Copy.tRowGenerator_1Process(CustomerName_excel_zipPRICAT_Copy.java:4669)
    at hosted_files.CustomerName_excel_zippricat_copy_0_1.caraustarIndustries_excel_zipPRICAT_Copy.tOracleConnection_1Process(CustomerName_excel_zipPRICAT_Copy.java:4202)
    at hosted_files.CustomerName_excel_zippricat_copy_0_1.CustomerName_excel_zipPRICAT_Copy.tFileInputDelimited_1Process(CustomerName_excel_zipPRICAT_Copy.java:4033)
    at hosted_files.CustomerName_excel_zippricat_copy_0_1.CustomerName_excel_zipPRICAT_Copy.runJobInTOS(CustomerName_excel_zipPRICAT_Copy.java:6976)
    at hosted_files.CustomerName_excel_zippricat_copy_0_1.CustomerName_excel_zipPRICAT_Copy.main(CustomerName_excel_zipPRICAT_Copy.java:6805)
Does anyone have any insight? I appreciate your time and help.
Labels (3)
1 Reply
premchandkar
Contributor
Contributor

Hi  mpantos,

It seems your excel file is opened in your machine,Try executing the talend job once after closing the excel file,Hope it will work for u

Thanks,
Premchand