Offline Migration of Forecast Rates Fails with 'ORA-02292: integrity constraint violated' Errors (Doc ID 2490414.1)

Last updated on MARCH 28, 2019

Applies to:

Symptoms

On Oracle Financial Services Asset Liability Management (ALM) 8.0.4, for Offline Migration, when attempting to migrate a Static ALM Process from a source to target environment, the import fails with the following errors for Forecast Rates in the offline_migration.log from the web server's OFSAA log directory:

[01-08-18 14:10:05 PM] ~ ERROR ~ MIGRATION ~ Import-->error
java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (<atomic>.FK_FSI_M_FORECAST_RATES_1) violated - child record found
.
.
.
[01-08-18 14:10:05 PM] ~ ERROR ~ MIGRATION ~ Error in parsing XML Data::Error in delete_existing_object objectType:802Error :::ORA-02292: integrity constraint (<atomic>.FK_FSI_M_FORECAST_RATES_1) violated - child record found
 
java.lang.Exception: Error in delete_existing_object objectType:802Error :::ORA-02292: integrity constraint (<atomic>.FK_FSI_M_FORECAST_RATES_1) violated - child record found

       at com.ofs.fsapps.commonapps.core.migration.FSIMetaDataMigration.delete_existing_object(FSIMetaDataMigration.java:868)
       at com.ofs.fsapps.commonapps.core.migration.FSIMetaDataMigration.importObject(FSIMetaDataMigration.java:726)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
       at java.lang.reflect.Method.invoke(Unknown Source)
       at com.ofs.reveleus.migration.core.ImportMigratorThread.invokeMigrationAPI(ImportMigratorThread.java:311)
       at com.ofs.reveleus.migration.core.ImportMigratorThread.migrateObject(ImportMigratorThread.java:162)
       at com.ofs.reveleus.migration.core.ImportMigratorThread.run(ImportMigratorThread.java:69)
       at com.ofs.reveleus.migration.service.OfflineMigrationService.startImportProcess(OfflineMigrationService.java:167)
       at com.ofs.reveleus.migration.service.MigrationServiceProvider.importRuleset(MigrationServiceProvider.java:951)
       at com.ofs.reveleus.migration.ws.service.MigrationOfflineServiceImpl.importObject(MigrationOfflineServiceImpl.java:55)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

and

[01-08-18 14:10:05 PM] ~ ERROR ~ MIGRATION ~ Import-->error
java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (<atomic>.FK_FSI_ALM_DTL_FCAST_EI_AUDIT2) violated - child record found
.
.
.
[01-08-18 14:10:05 PM] ~ ERROR ~ MIGRATION ~ Error in parsing XML Data::Error in delete_existing_object objectType:804Error :::ORA-02292: integrity constraint (<atomic>.FK_FSI_ALM_DTL_FCAST_EI_AUDIT2) violated - child record found
 
java.lang.Exception: Error in delete_existing_object objectType:804Error :::ORA-02292: integrity constraint (<atomic>.FK_FSI_ALM_DTL_FCAST_EI_AUDIT2) violated - child record found

       at com.ofs.fsapps.commonapps.core.migration.FSIMetaDataMigration.delete_existing_object(FSIMetaDataMigration.java:868)
       at com.ofs.fsapps.commonapps.core.migration.FSIMetaDataMigration.importObject(FSIMetaDataMigration.java:726)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

Due to this issue, you cannot migrate Forecast Rates data from the source to the target.

Changes

Cause

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