Converter Output is Missing Variable Data, But Designer Preview Works. Error Message: "Variable processing error: 9:Subscript out of range"

(Doc ID 1300516.1)

Last updated on MARCH 15, 2011

Applies to:

Oracle Legal Whitehill Enterprise - Version: 5.8.0 and later   [Release: and later ]
Information in this document applies to any platform.

Symptoms

In Designer, running a preview works, but in Converter certain variables do not evaluate.

In the error.log, the Designer preview results in an error message similar to the following:


"Your SQL statement 'select file_path from Document_Catalog Where desc_num_1 = ******' failed for the Query Fragment OriginalBill 0"


In the error.log, the Converter job results in:


"Variable processing error: 9:Subscript out of range"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms