My Oracle Support Banner

'Hierarchy Does Not Exist On Source System' Error Running Dimension Hierarchy Migration (Doc ID 604707.1)

Last updated on NOVEMBER 24, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10.2
This problem can occur on any platform.
Dimension Hierarchy Migration

Symptoms

-- Problem Statement:
On 11.5.10.2 in Production:
When attempting to migrate a Hierarchy from the Target instance into the Source instance, the
following error occurs:

ERROR
Migrating Hierarchy...
The Hierarchy <My Hierarchy Name> does not exist in the source system.

It is confirmed that the database link is functional and registered correctly.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Login to Source instance
2. Run the 'Dimension Hierarchy Migration'

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!


In this Document
  Symptoms
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.