Importing Dimension From Interface Tables Fails If Members Have Attributes in Planning with Error: "a general SQL error has occurred accessing the input table" (Doc ID 945983.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Planning - Version 9.3.1.1.00 to 11.1.1.2.00 [Release 9.3 to 11.1]
Information in this document applies to any platform.

Symptoms

When loading the Entity dimension into EPMA using Interface Tables. The import profile, which had previously been working, fails with the following errors:

Error message in the EPMA job console:

a general SQL error has occurred accessing the input table ''

Error message in the Windows Event Viewer:

Event Type: Error
Event Source: HyS9BPMA_DimensionServer
Event Category: None
Event ID: 0
Date: 15/09/2009
Time: 16:40:17
User: N/A
Computer: VM0DACARTER4
Description:
[9804] ERROR An item with the same key has already been added.Exception: System.ArgumentException
Message: An item with the same key has already been added.
Source: mscorlib

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