Clarify Scenario:

When trying to translate an Inbound Clarify Spreadsheet ruleset we receive an error.

Clarify Issue:

In the source data (spreadsheet), one of the cells contains: #VALUE!

Server Errors:

Step 4: Execute Transformation - Single Output
Data:

Step Messages:
2019-03-22 07:34:33,106 [PERSISTENT] - Starting com.extol.processtasks.engine2.tasks.TransformationEngineTask@738ec330
2019-03-22 07:34:33,107 [PERSISTENT] - Executing Version 2 Ruleset: "com.abc.fullmovelistxlsx.FullMoveListToAS400RS"
2019-03-22 07:34:33,107 [PERSISTENT] - Starting Transformation Engine
2019-03-22 07:34:55,845 [ERROR] - Cell AI8117 contains an Error.

2019-03-22 07:34:55,848 [PERSISTENT] - Ending Transformation Engine; Completed in 22741ms.
2019-03-22 07:34:55,848 [PERSISTENT] - Completed Task.

Clarify Resolution:

By substituting the "#VALUE!" string for a zero, the file was able to process successfully. This issue will need to be fixed on the file creation side.