Getting Data Access Error When Importing Source File in FDM "ORA-00439: feature not enabled: Bit-mapped indexes"
Posted by Priya Doyle on 08 February 2011 03:23 PM
Hyperion Financial Data Quality Management - Version: 126.96.36.199.00
Information in this document applies to any platform.
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] **
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.
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