"- 2147217833 - Data Access Error" Importing an XML File in a New Financial Data Quality Management (FDM) Application via the Workbench

(Doc ID 1053441.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.1.2.00 and later
Information in this document applies to any platform.

Symptoms

Importing and XML file in a new FDM application via the Workbench client, errors with:
"- 2147217833 - Data Access Error"; when "Import Maps with Locations" is selected in the "Options" tab.

If the Maps are not selected, the import loads successfully.

The *.err log file gives the following errors:

ERROR:
Code............................................. -2147217833
Description...................................... ORA-01401: inserted value too large for column
Procedure........................................
clsDataManipulation.fProcessRecord
Component........................................ upsWDataWindowDM
Version.......................................... 1111
Thread........................................... 2220

and

ERROR:
Code............................................. -2147217833
Description...................................... Data access error.
Procedure........................................ clsImport.ImportLogicGroups
Component........................................ upsWMetaMgrDM
Version.......................................... 1111
Thread........................................... 2220

IDENTIFICATION:
User............................................. admin
Computer Name.................................... XXXX
App Name......................................... FDM_TEST
Client App....................................... WorkBench

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms