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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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