Spreadsheet Trans. Error; Workbook Missing
Scenario:
After setting up a schema, ruleset and business process for a spreadsheet transformation, an error occurred in the Auditor.
Issue:
The spreadsheet file used to create the XLS schema, was actually an XSLX.
EXTOL Business Integrator Auditor Error :: Server.log
Step #8: Context Point - Set Value
2016-02-08 10:02:48,813 [INFO] - Starting ContextProcessing
2016-02-08 10:02:48,829 [INFO] - Completed Task.
Step #9: Context Point - Set Value
2016-02-08 10:02:48,829 [INFO] - Starting ContextProcessing
2016-02-08 10:02:48,829 [INFO] - Completed Task.
Step #10: Execute Transformation - Single Output
2016-02-08 10:02:48,829 [INFO] - Starting Transform
2016-02-08 10:02:48,829 [INFO] - Starting Transformation Engine
2016-02-08 10:02:48,829 [INFO] - Executing "RS_ABC_Excel_PO_Inbound / 2016-01-26"
2016-02-08 10:02:49,000 [ERROR] - Unable to retrieve Workbook.
2016-02-08 10:02:49,016 [INFO] - Ending Transformation Engine
2016-02-08 10:02:49,016 [INFO] - Completed Task.
Message ID: 22
Primary: java.lang.NullPointerException
at com.extol.adapters.spreadsheet.JxlSpreadsheetReader.a(JxlSpreadsheetReader.java:57)
at com.extol.adapters.spreadsheet.JxlSpreadsheetReader.getNumberOfRows(JxlSpreadsheetReader.java:48)
at com.extol.adapters.spreadsheet.SpreadsheetExpressionEvaluator.
Resolution:
In this instance, we re-created the spreadsheet template using an XLS file. Once the XLS was recreated, we updated the ruleset and BPS to reflect the new XLS file.
By: Sean Hoppe on
