Knowledgebase: Enterprise
Error 'ERROR DISPATCH 101#' When Loading A Formula Extract Into Hyperion Enterprise 6.5 Or Above
Posted by Priya Doyle on 16 February 2011 10:59 AM

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


(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: