My Oracle Support Banner

Hierarchy Object Migration Fails With 'Reverse Population Failed for Hierarchy..<HIERARCHY NAME>' (Doc ID 2749917.1)

Last updated on FEBRUARY 09, 2021

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Object Migration, when migrating a hierarchy that exists on the target but needs to be overwritten, the process fails after attempting to run Reverse Population.  The following messages appear in the web server's FUSIONSUBSYSTEMSService.log:

[22-12-20 22:08:49,969 GMT PM] [DEBUG] [WEB] [AMHM] [NA] [COMMONFUNCTIONS] Query to Hierarchy reverse population procedure : { call ADHM_MGMT.populateHierarchy(?, ?, ?) }
[22-12-20 22:08:50,703 GMT PM] [DEBUG] [WEB] [AMHM] [NA] [COMMONFUNCTIONS] Hierarchy reverse population result status : false
[22-12-20 22:08:50,703 GMT PM] [DEBUG] [WEB] [AMHM] [NA] [HIERARCHYMIGRATIONSERVICE] Reverse populating Hierarchy - dbOperation :2 is :false
[22-12-20 22:08:50,703 GMT PM] [INFO ] [WEB] [AMHM] [NA] [HIERARCHYMIGRATIONSERVICE] Exception occurred while trying to get Migration Hierarchy.com.ofs.reveleus.migration.util.MigrationException: Reverse Population Failed for Hierarchy..<HIERARCHY NAME>
[22-12-20 22:08:51,337 GMT PM] [DEBUG] [WEB] [AMHM] [NA] [DBUTIL] Hierarchy Migration Error - com.ofs.reveleus.migration.util.MigrationException: Reverse Population Failed for Hierarchy..<HIERARCHY NAME>
[22-12-20 22:08:51,337 GMT PM] [INFO ] [WEB] [AMHM] [NA] [CONNECTIONS] Getting tomcat connection from pool
[22-12-20 22:08:51,362 GMT PM] [DEBUG] [WEB] [AMHM] [NA] [MIGRATORTHREAD] Migration Return Value..-1
[22-12-20 22:08:51,362 GMT PM] [DEBUG] [WEB] [AMHM] [NA] [DBUTIL] Failed Migrating Object..[id:200055,name:<HIERARCHY NAME>,type:5,Source Folder:<FOLDER NAME>,Target Folder:<FOLDER NAME>]

Reverse Population for the Dimension members is successful.   Checking FSI_MESSAGE_LOG, below is the only message related to the Hierarchy Reverse Population:

Starting Hierarchy Load Batch Mode for dimension 1

There are no more messages after this point.

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.