My Oracle Support Banner

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 APRIL 25, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.