| FDM Export to Excel Process Returns Error "File Could Not Be Opened" | |||||
|
|
|||||
| Modified 27-OCT-2010 Type PROBLEM | |||||
Applies to:
Hyperion Financial Data Quality Management - Version: 9.3.1.0.00 to 11.1.2.0.00 - Release: 9.3 to 11.1Information in this document applies to any platform.
Symptoms
Clicking the "Export to Excel" icon on the import screen returns the following error message:
Export to excel
Error: File could not be opened.
Error: File could not be opened.
The following information is written to the user error log:
** Begin FDM Runtime Error Log Entry [2010-10-19-12:10:48] **
-------------------------------------------------------------
ERROR:
Code............................................. 3002
Description...................................... File could not be opened.
C:\Newxx\Outbox\ExcelFiles\xxxx Imp-All-Accts-Oct - 2010-ACTUAL98882.xls
Procedure........................................ clsAppServer.fFileGetStream
Component........................................ upsAppSv
Version.......................................... 1111
Thread........................................... 3720
IDENTIFICATION:
User............................................. admin
Computer Name.................................... DEV
App Name......................................... FDM_AGG
Client App....................................... WebClient
Cause
This error message indicates that either:a) Smart View is installed on the FDM application server within Excel which will cause this issue.
b) The Essbase Spreadsheet Add-In is registered within Excel on the FDM application server.
c) Also, if any other Excel Add Ins (possibly non-Hyperion) is installed.
Discovered this issue is being caused due to the Performance Point Excel Add In being installed within Excel on the FDM application server.
Solution
A) Uninstall the Performance Point Excel Add In within Excel on the FDM application serverB) Re-run the "Export to Excel" process from the import screen in FDM.
GKontos
Comments