Error 'ERROR DISPATCH 101#' When Loading A Formula Extract Into Hyperion Enterprise 6.5 Or Above

Error 'ERROR DISPATCH 101#' When Loading A Formula Extract Into Hyperion Enterprise 6.5 Or Above

		Modified 17-MAR-2010     Type PROBLEM

Applies to:

Hyperion Enterprise - Version: 6.5.0.0.00 - Release: 6.5
Information in this document applies to any platform.

Symptoms

Receiving "IDispatch Error 101# " when loading a formula extract from a version prior to 6.5 into 6.5 or later

Cause

This occurs when a line in the source file contains a comment (shown by the exclamation ! sign) followed later by an ampersand (&). The ampersand is used to wrap the comment onto the next line due to its length. It is the & which throws the error.

Solution

When attempting to load the file, the error log should list the lines which are erroring.
Open the formulas file in a text editor and navigate to those lines.

Pre-correction the line will appear as:
#account=Formula ! a long comment which is wrapped &
onto the next line

Correct the line to appear as:
#account=Formula ! a long comment which is wrapped onto the next line


Only the & which appear after a comment (!) need to be removed