Error When Importing in FDM Using SQL Integration Script - Detail:Object Variable or With Block Variable Not Set

Error When Importing in FDM Using SQL Integration Script - Detail:Object Variable or With Block Variable Not Set
		Modified 07-JUN-2010     Type PROBLEM     Status MODERATED

Applies to:Hyperion Financial Data Quality Management - Version: 9.3.1.0.00<max_ver> and later   [Release: 9.3 and later ]
Information in this document applies to any platform.

Symptoms

Receiving Object Variable or With Block Variable Not Set error
Within FDM when attempting to perform an import using a SQL Integration Script or attempting to Export Mapping to Excel, users receiving an error message. The error message states:

"Object Variable or With Block Variable Not Set"

The error is returned immediately after clicking the Export to Excel icon in the mapping table, or the Import button in the Import Workflow for the SQL Integration Locations. 

Cause

When a SQL Integration Script is used within FDM for importing, the SQL Statement results are written to a text file that is located in the FDM Inbox directory of the Application Structure. If the FDM Service account is unable to write to this directory, it results in the error message "Object Variable or With Block Variable Not Set" being returned.

The FDM Service Account did not have "Write" share permission to the FDMDATA folder structure, which resulted in the FDM Service account being unable to write the text file that is produced when running a SQL Integration Script. Without being able to write to the directory, the import process cannot complete successfully.

Solution

1) From the FDM Login screen select "Add Application" from the drop down list
2) Login with a valid user
3) Highlight the application that is experiencing the issue and click "modify"
4) Locate the "Application Path", this is the location of the FDM Application Files. Connect to the server hosting the FDMDATA folder.
5) Right-click on the FDMDATA folder and choose "Properties"
6) Click on the "Sharing" tab and click the "Permissions" button
7) Click "Add" and enter the id of the FDM Service Account used for all the FDM Configs and click OK
8) Check the "Full Control" box and click "Apply"
9) Click OK to save the changes.