As of TRIRIGA Application Platform version 3.5.1, the Java Excel API (JExcelApi) jxl.jar is no longer included as part of the TRIRIGA package. If you have Kettle ETLs that use Microsoft Excel input or output steps you will need to download jxl.jar and add it to your application server’s classpath.
- 1. If you have an ETL that ran prior to upgrading to 3.5.1, check to see if the server.log contains an entry similar to the following entry. If the entry exists you will need to obtain jxl.jar and add it to your application server startup.
2016-02-11 12:32:16,490 WARN [com.tririga.platform.workflow.runtime.taskhandler.WFTaskHandlerBase](WFA:221931 - 127581834 triProcessManual:309907888 IE=309907888) Workflow task handler error while Loading class com.tririga.platform.workflow.runtime.taskhandler.ETL.RunETL. Class definition not found. TaskStep: Custom Task(39) WFTID=19192848.7 TSID=204231 Label='Call Kettle Transformation API' FormulaRecalc='Recalculate as Needed' EventAction=''. Cause: java.lang.NoClassDefFoundError: jxl/format/CellFormat[MID-1509809430]
- 2. Get the jxl-2.6.12.jar from either of these two sources:
- 3. Add jxl-18.104.22.168.jar to your TRIRIGA application server as follows…