FDM Issues

FDM Issues

Failure to Create a New FDM Application on 64-bit Windows


Issue: When creating a new application using FDM Workbench Win32 Client, it returns the
error: “Error: Database user ID and password are required for login”.

This error is returned when the information provided on the database configuration page is not correct or has become invalid. This error message can also be returned when the Oracle 32-bit Database Client is not installed on a 64-bit Windows machine.


Solution: When using the Oracle software on 64-bit Windows:

1. Install the 32-bit Oracle Database Client on the 64-bit machine.
2. Reconfigure using the 32-bit client and reboot the server.
Appropriate database providers include: (a) Oracle Provider for OLE DB installed on
Workbench Win32 Client machine, and (b) Microsoft OLE DB Provider for SQL Server.
These providers must exist on the user's system in order for Oracle Hyperion Financial Data
Quality Management to connect to the database successfully via the Workbench Client. On 64-
bit Windows, the 32-bit and 64-bit Oracle Software gets installed separately and used separately.

The 64-bit Oracle software will not recognize if the 32-bit Oracle software is installed. They
operate separately when both are installed on a 64-bit Windows platform.


FDM Load balancer Configuration issue

Unable to create Load Balance Manager object! Configuration directory could not be located. Error=-2147023878 - Retrieving the COM class factory for component with CLSID *{E652643D-6CC1-48AC-915D-01842B04F292}*
Source=TaskManagerService - at TaskManagerService.TaskItem.fGetConfigFolder()



• Start the ‘dcomcnfg’ tool in Windows
• Expand Component Services\Computers\My Computer\Dcom-Config and locate the following object: {E652643D-6CC1-48AC-915D-01842B04F292}
• Right-click and choose "Properties" and click on the "Security" tab
• Click the "Edit" button and remove all users except the default: "Everyone" and "System" and click OK, then set the radio button to "Use Default"
• Click the "Edit" button under Access Permissions and remove all users/groups except the default items and click OK, and set the radio button to "Use Default"
•Now click the "Identity" tab and remove the ID in the "This User" field and set the radio button to "The Launching User" and click "Apply" and "OK"


The administrators group Should be part of

• Act as part of the operating system
• Bypass traverse checking
• Log on as a batch job
• Log on as a service

FDM Application Creation Issue

Unable to Create FDM Application or Configure Shared Services Provider on Windows 2008 R2 [ID 1324303.1]

Applicable to these versions 11.1.2.1.000 and later [Release: 11.1 and later ]

Hyperion Financial Data Quality Management 
OS Microsoft Windows x64 (64-bit) - Version: 2008 R2

Symptoms

When attempting to connect to shared services with the CSS provider in the authentication providers tab of the Load Balance Configuration, the connection process fails and returns "Active-X Component Can't Create Object".

This is occurring with version 11.1.2.1 on a Windows 2008 R2 server.

Root Cause

Currently the EPM System Installer does not properly register a necessary file for FDM to use to connect to shared services successfully. When attempting to connect to HSS from the Load Balance Configuration the process fails and results in the error message.


The cause of the issue is justified by Unpublished Bug 12540570. 

Solution

•  Launch the EPM System Installer on the FDM server
• Click Next at the welcome screen
• Verify the EPM System Home and click next
• Choose the "Re-Install This Release" option and the "Choose Components Individually" radio button and click Next
• Un-check All items and then check the FDM component box and click nextVerify the FDM Components to be re-installed and click Next
• Start > Programs > Oracle EPM System > Financial Data Quality Management > Application Server > Application Server Config
• Enter the FDM Service account username/password/confirm password/domain and click OK
• Start > Programs > Oracle EPM System > Financial Data Quality Management > Load Balance Server > Load Balance Configuration
• Enter the FDM Service Account username/password/confirm password/domain. Click on the application servers tab and add the FDM Application Server Name. Click on the Authentication Providers Tab and add a new Provider. Choose "CSS" for the type and click OK. Enter a description for the provider and the HSS Admin/password account and click "test connection". Receive message "Connection Successful" click OK and ok again to return the the load balance config and OK to save the changes.
• Start > Programs > Oracle EPM System > Financial Data Quality Management > Task Manager > Task Manager Configuration. Enter the FDM Service Account uid/pwd/confirm pwd/domain. Click on the load balance server tab and populate the FDM application server name in the primary server field and click OK
• Start > Programs > Oracle EPM System > Financial Data Quality Management > Web Server Components > Web Configuration. Enter the FDM Service Account uid/pwd/confirm pwd/domain. Click on the load balance server tab and populate the FDM application server name in the primary server field and click OK.
• Click OK to the IIS Restart message and open a command prompt. Type iisreset and hit the enter key.

FDM Object Variable or With Block Variable Not Set" 

The error "Object Variable or With Block Variable Not Set" is caused when the FDM Service account does 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. Could you please verify the following and update the SR accordingly.

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.

Solution II

Follow the TROUBLESHOOTING Financial Data Quality Management Error "Run-Time error '91': Object Variable or With Block Variable Not Set" (Doc ID 1436909.1)

Perform the below steps

1)Launch the Windows 2008 Management Console 
2) Click "Add Roles" 
3) Click next on the first screen 
4) Check the Application Server box and click next 
5) Check the IIS Support Box for the application server role and click Next 
6) Verify the Role and click Finish to install the role 

Note :The above IIS Roles Should  be validated  before installing and configuring FDM Components



Other Known FDM Installation & Configuration Issues

Document 1308568.1    How to Use the UPSShell.EXE To Launch a Custom Script for FDM 
Document 1161892.1      Configuring Necessary Roles in Windows 2008 for FDM Web Server [Video] 
Document 1162823.1    Enable Drill Through to FDM in a Financial Report [Video] 
Document 1067430.1    Migrating an FDM Application From a System 9 Environment to a FDM version 11.1.1.0 and Higher Environment [Video] 
Document 967036.1      How to setup Drill Through from Smart View into Financial Data Quality Management (FDM) 
Document 728181.1      Error After Loading New Mapping to a Location. "Error While Parsing Entity Name" 
Document 1052993.1    How to Setup Drill Through from Financial Management (HFM) to Financial Data Quality Management (FDM) Version 11.1.1.3 
Document 816183.1      DCOM Error Message in Windows Event Viewer for Load Balance Manager or Application Server components 
Document 986694.1      Export to Excel Hangs in FDM 11.1.1.3. How to Un-Register Essbase Add-In in EPM System 11.1.1.3 
Document 1078450.1    BULK INSERT ERROR ON IMPORT IN FDM 
Document 815038.1      Cannot Publish Report to Excel for One Location 
Document 951369.1      Configure and use ERPi as a Replacement to the Financial Data Quality Management EBS Adapter 
Document 1052154.1   How to Leverage Multiple FDM ERPi Adapters 
Document 602380.1      Setup and Configuration for HFM Audit Intersection (DrillBack) into FDM 
Document 981794.1      How to Configure and Setup DrillBack from Hyperion Enterprise (HE) into Hyperion Financial Data Quality Management (FDM) 
Document 739664.1      Workbench Error "2037 - Database User ID and Password are Required" for Login During Application Logon 
Document 968084.1      FDM URL Link from HFM causes FDM Window to Close Unexpectedly 
Document 942561.1      Setting Up Conditional Maps in FDM 
Document 1101084.1    How to Set Up Essbase Adapter's Calc Script to Prevent Delete for Previous Years 
Document 1114660.1    Incorrect Date in the Period Field of the Check Report 
Document 800476.1      Tips for FDM Registering with Shared Services 
Document 1090074.1  Failure to Create New FDM Application on 64-bit Windows 
Document 780874.1  How to Verify EBS Setup for DrillBack to EBS in FDM 
Document 745230.1 How to Configure FDM to Authenticate on Shared Services 



Error Messages/Bugs 

Document 1436909.1  TROUBLESHOOTING Financial Data Quality Management Error "Run-Time error '91': Object Variable or With Block 

Error Messages/Bugs 
Document 1436909.1  TROUBLESHOOTING Financial Data Quality Management Error "Run-Time error '91': Object Variable or With Block Variable Not Set" 
Document 1441863.1  TROUBLESHOOTING Financial Data Quality Management Error "Automation Error" 

Document 1065546.1    FDM Error "Index Was Out of Range" in User Maintenance When Pulling Users From Shared Services 
Document 840319.1      Periodic data export fails loading into HFM with "No Such Member PER" 
Document 963032.1      Data Access Error or "There is Invalid Cell Data" in the Logic for the type 'Function' in Financial Data Quality Management 11.1.1.3.00 
Document 852117.1     "Essbase API Procedure: [EsbInit] Threw code: 1030723" When Testing Financial Data Quality Management Integration into Essbase 
Document 727112.1    User Unable to Load FDM Data into HFM, Receive "Could not Authenticate the Specified User. %0" 
Document 973722.1      "Type Mismatch - 13" Error When Logging into a Financial Data Quality Management Application Deployed Against SharedServices 
Document 597376.1      FDM Integration with HFM Error: "Server/Cluster is incorrectly configured. Please reconfigure your Cluster or Server connection 
Document 1132723.1    Export To Excel error "SaveAs method of Workbook class failed" in FDM 11.1.2 
Document 1179495.1   Error: "HTTP Error 500.0 - Internal Server Error" Unable to Run FDM and EPM Simultaeneously on IIS7 64bit Installation 
Document 1229893.1   Error: "This application is not registered with Shared Services." when trying to add a newly provisioned user to FDM 
Document 1195948.1   FDM Import Error "Error: Invalid Option Key: Fileprompt" 
Document 1118753.1  FDM Validate Error "The stylesheet does not contain a document element" 
Document 1139713.1 Shared Services Provisioning Fails Error "30:1101:JNDI" 
Document 597518.1 FDM Receive "ERROR: Description [Script failure caused error]: Object doesn't support this property or method Procedure clsEventHandler.PobjAPI_ImportAction" During Import 
Document 800406.1 Error at Line 45 Browsing to the Target System in the Financial Data Quality Management (FDM) Maps 

Document 1213783.1 Error Logging into FDM Workbench "Invalid User Name or Password, No Permission to Create or Add a New FDM Application - 2653" 

Document 1053623.1 FDM Adapter Configuration Error on 64 Bit Operating System