Knowledgebase: FDM
FDM Export to Excel Process Returns Error "File Could Not Be Opened"
Posted by Priya Doyle on 08 February 2011 04:05 PM

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.1
Information 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.

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 server
B) Re-run the "Export to Excel" process from the import screen in FDM.

(0 vote(s))
Helpful
Not helpful

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