Object Migration Fails With 'Error While Migrating Members'
Last updated on DECEMBER 30, 2016
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 6.x
In Oracle Financial Services Analytical Applications (OFSAA) 7.3, Object Migration fails when you run it to move dimension members from a source environment into a target environment. The following error appears in the Object Migration View Log messages:
Begining to Migrate All Members for Dimension:5
Error While Migrating Members - Rolled Back All Member Migration
"Dimension Migration Error - com.ofs.reveleus.migration.util.MigrationException: ORA-00957: duplicate column name
Migration Process Stopped, As Fatal Error Ocurred While Migrating Object..[id:5,name:TP_COA_ID,type:12,folder:]
Migration Failed Because of Fatal Error
The error prevents the dimension members from being migrated from the source environment into the target environment.
Steps to Reproduce:
- Log into OFSAA Infrastructure
- Go to Administration > Utilities > Object Migration
- Run an Object Migration rule to transfer dimension members
- Review the View Log messages
The error appears in the View Log messages.
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