Command Line Utility Export Fails With 'Error occurred while getting MASTER DSN Name Errors' Even Though REV_MIG_LOG Says Migration Success (Doc ID 2377647.1)

Last updated on MAY 24, 2023

Applies to:

Symptoms

The Command Line Utility Export fails and does note create .DMP after REV_MIG_LOG says Migration Success. When attempting to export using command line utility, the migration seems to be starting for some object types, but errors out after posting MIGRATION SUCCESSFUL in REV_MIG_LOG and REV_MIG_EXECUTION.

Neither Data Transformations (DT) nor Forms export seem to work.

ERROR
From:  SMSService.log

Mar 13,18 12:19:07 : [SMSSERVICES]Error occurred while getting MASTER DSN Name
java.lang.Exception: Error occurred while getting MASTER DSN Name
       at com.iflex.fic.client.SMSServices.getMasterDSN(SMSServices.java:93)
       at com.iflex.fic.ficml.JSPInitBean.defaultInitialize(JSPInitBean.java:225)
       at metadata.cmd.UnifiedExportImportMetadata.main(UnifiedExportImportMetadata.java:257)

From: FUSIONSUBSYSTEMSService.log

[FUSIONSUBSYSTEMS] Mar 13,18 11:07:30 : [MIGRATIONSERVICEPROVIDER]Query to retrive the Migration Ruleset details:::SELECT RMRDT.OBJECT_TYPE, RMRDT.OBJECT_SUB_TYPE, RMRDT.OBJECT_ID, RMRDT.FOLDER_NAME, RMRDT.TARGET_FOLDER_NAME, RMRDT.OBJECT_NAME, FSIID.ID_TYPE, FITC.OBJECT_TYPE, RMRDT.SUB_TYPE_DESC FROM REV_MIG_RULESET_DETAILS RMRDT, (SELECT DISTINCT OBJECT_TYPE_ID, MIGRATION_ORDER FROM REV_OBJECT_REGISTER) RREG, FSI_ID_TYPE_MLS FSIID, FSI_ID_TYPE_CD FITC WHERE RMRDT.OBJECT_MIGRATION_ID = ? AND RMRDT.OBJECT_TYPE = RREG.OBJECT_TYPE_ID AND FSIID.ID_TYPE_CD = RMRDT.OBJECT_TYPE AND FSIID.MLS_CD = ? AND FITC.ID_TYPE_CD = RMRDT.OBJECT_TYPE ORDER BY RREG.MIGRATION_ORDER,RREG.OBJECT_TYPE_ID, RMRDT.OBJECT_NAME
[FUSIONSUBSYSTEMS] Mar 13,18 11:07:30 : [MIGRATIONSERVICEPROVIDER]All Option Selected For Type..121
[FUSIONSUBSYSTEMS] Mar 13,18 11:07:30 : [MIGRATIONSERVICECLIENT]objAPI::::com.ofs.reveleus.migration.impl.UMMSummaryListService.getUMMObjectListOFFLine
[FUSIONSUBSYSTEMS] Mar 13,18 11:07:30 : [UMMSUMMARYLISTSERVICE]UMMMigrationService.getOFFLineUMMObjectList:<INFODOM>
[FUSIONSUBSYSTEMS] Mar 13,18 11:07:30 : [UMMSUMMARYLISTSERVICE]infodom..<INFODOM>
[FUSIONSUBSYSTEMS] Mar 13,18 11:07:30 : [UMMSUMMARYLISTSERVICE]objType..121
[FUSIONSUBSYSTEMS] Mar 13,18 11:07:30 : [UMMSUMMARYLISTSERVICE]segment..null
[FUSIONSUBSYSTEMS] Mar 13,18 11:07:30 : [UMMSUMMARYLISTSERVICE]user..<USER>
[FUSIONSUBSYSTEMS] Mar 13,18 11:07:30 : [UMMSUMMARYLISTSERVICE]locale..en_US
[FUSIONSUBSYSTEMS] Mar 13,18 11:07:30 : [UMMSUMMARYLISTSERVICE]optionalParams..{}
Error occurred while getting MASTER DSN Name at com.ofs.reveleus.migration.service.MigrationServiceClient.getObjectListOFFLine(MigrationServiceClient.java:245)
       at com.ofs.reveleus.migration.service.MigrationServiceProvider.getObjectListOFFLine(MigrationServiceProvider.java:222)
       at com.ofs.reveleus.migration.service.MigrationServiceProvider.retrieveMigrationRuleSet(MigrationServiceProvider.java:661)

The issue can be reproduced at will with the following steps:
1. Run command line object migration

Cause

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