Knowledgebase: FDM
Error: -2147217887 Data Access Error. Trying to Import a File in an FDM Location with a Logic Group Assigned
Posted by Priya Doyle on 07 February 2011 12:15 PM
Error: -2147217887 Data Access Error. Trying to Import a File in an FDM Location with a Logic Group Assigned

 Modified 03-SEP-2010 

Applies to:

Hyperion Financial Data Quality Management - Version: 9.3.1.0.01 and later   [Release: 9.3 and later ]
Generic Windows

Symptoms

When attempting to import a source gl file into FDM, the import fails with Error: “ -2147217887 Data Access Error. Account=XY”.  The error message occurs when trying to import a file with the POV set to an FDM location with a logic group assigned.  If the logic group field on the locations workflow behaviors tab is set to [None], the import process is successful.  

Cause

The cause of this problem has been identified in Bug 7214403. There is a difference in the way Microsoft SQL Server 2000 and Microsoft SQL Server 2005 handle OLE DB port connections under large volumes of data load.

Solution


Service Fix 9.3.1.2.00 (Patch 8429909) addresses this issue and it is now available in Metalink.  Please refer to the Read-me file included with the download for instructions on installing the service pack.

References

BUG:7214403 - LOGIC ACCOUNTS FAIL UNDER HIGH VOLUME DATA LOADS


(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: