Financial Management Error "Invalid procedure call or argument" When Exporting Data Entry Forms To Excel

Financial Management Error "Invalid procedure call or argument" When Exporting Data Entry Forms To Excel [ID 1367859.1]

		Modified 18-OCT-2011 Type PROBLEM Status PUBLISHED

In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

Applies to:

Hyperion Financial Management - Version: 9.3.3.0.00 to 9.3.3.0.00 - Release: 9.3 to 9.3
Information in this document applies to any platform.

Symptoms

After upgrading a Financial Management (HFM) to version 9.3.3, it is no longer possible to export Web Data Entry Forms (WDEFs) to Excel. In WDEFs there is a red X instead of Export to Excel buttons and clicking on them causes an error message:

An An error has occurred. Please contact your administrator.
Error Number:5
Error Description:Invalid procedure call or argument
Error Source:Microsoft VBScript runtime error
Page On which Error Occurred:/hfm/data/WebFormGenerated.asp

Changes

Upgrade from HFM 9.3.1 to HFM 9.3.3 version

Cause

During the upgrade some of the installation files have not been placed in correct directories.

Solution

Use the following workaround to resolve this issue:

From the Attachments section of this article download the Export2Excel.zip file to your HFM web server.
Unzip the file.
Copy the files from Images folder to %Hyperion_Home%\Financial Management\Web\HFM\Images
Copy the files from Data folder to %Hyperion_Home%\Financial Management\Web\HFM\Data
Restart IIS on the HFM web server, ie. using Windows command iisreset