Getting Data Access Error When Importing Source File in FDM "ORA-00439: feature not enabled: Bit-mapped indexes"

Getting Data Access Error When Importing Source File in FDM "ORA-00439: feature not enabled: Bit-mapped indexes"
		Modified 11-JUN-2010     Type PROBLEM

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

During the import of a source general ledger at the import stage of the FDM work flow, user receives "Data Access Error". The error log then contains the following entries:

** Begin FDM Runtime Error Log Entry [2009-01-07-14:17:13] ** 
------------------------------------------------------------- 
ERROR: 
Code......................................... -2147217900 
Description.................................. ORA-00439: feature not enabled: Bit-mapped indexes 
CREATE BITMAP INDEX IX_tWhypadm457250968475_BA ON tWhypadm457250968475 (CalcAcctType) TABLESPACE HYPERIONWORK COMPUTE STATISTICS 
Procedure.................................... clsDataManipulationclsDataManipulation.fExecuteDMLfExecuteDML 
Component.................................... upsWDataWindowDMupsWDataWindowDM 
Version...................................... 931 
Thread....................................... 5096 

Cause

The client was using Oracle 10g for the FDM relational database and the Bitmap Index Switch is turned on.

The Bitmap Index Switch configuration option should be disabled for Oracle 10g and enabled for Oracle 9i.

Solution

To disable the Bitmap Index Switch within the FDM Application, the following steps need to be performed:

#1 Launch the FDM Workbench Client

#2 Login to the FDM Application as a Power User

#3 Choose the Tools menu | Configuration Settings

#4 In drop-down, choose Oracle Work Table Bitmap Index Switch

#5 Un-check the box to turn off this feature and click the "Save and Close" button

#5 Re-import source file to test