\u203A \u203A Spreadsheet Trans. Error; Workbook Missing

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.(SpreadsheetExpressionEvaluator.java:125)



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: on
A free web counter provided by GoStats.