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 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!