Importing Dimension From Interface Tables Fails If Members Have Attributes in Planning with Error: "a general SQL error has occurred accessing the input table"
Last updated on JULY 28, 2016
Applies to:Hyperion Planning - Version 220.127.116.11.00 to 18.104.22.168.00 [Release 9.3 to 11.1]
Information in this document applies to any platform.
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
 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.
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