\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
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.