OBIEE 12c - Migration Import Fails with "Transformation failed" and "Error occurred during initialization of VM" Errors Due to Web Catalog Size (Doc ID 2093534.1)

Last updated on FEBRUARY 19, 2021

Applies to:

Symptoms

An Export bundle was created using the 12c Migration Tool (bi-migration-tool.jar). The 11g Production web catalog was over 8GB in size.

On OBIEE 12c, an Import was performed using the BI Migration Script (migration-tool.sh) to import the 11g data (contained in the Export bundle) in to the 12c system.  The import failed and the following was observed in the migration-#.log file:

SEVERE: Import failed: Plugin metadata -- oracle.bi.migration.plugin.metadata.TransformBarException: Transformation failed. Check logs for failure messages.
oracle.bi.migration.importer.ImportProblemException: Plugin metadata -- oracle.bi.migration.plugin.metadata.TransformBarException: Transformation failed. Check logs for failure messages.
at oracle.bi.migration.plugin.metadata.MetadataImportPlugin.importData(MetadataImportPlugin.java:55)
at oracle.bi.migration.orchestration.BundleImporter.doPluginImport(BundleImporter.java:114)
at oracle.bi.migration.orchestration.BundleImporter.runImport(BundleImporter.java:89)
at oracle.bi.migration.orchestration.actionspecification.ImportAction.performAction(ImportAction.java:137)
at oracle.bi.migration.orchestration.MigrationConductor.performMigrationAction(MigrationConductor.java:115)
at oracle.bi.migration.tool.MigrationTool.go(MigrationTool.java:203)
at oracle.bi.migration.tool.MigrationTool.main(MigrationTool.java:258)
Caused by: oracle.bi.migration.plugin.metadata.TransformBarException: Transformation failed. Check logs for failure messages.
at oracle.bi.migration.plugin.metadata.TransformBar.transformBar(TransformBar.java:123)
at oracle.bi.migration.plugin.metadata.MetadataImportPlugin.importData(MetadataImportPlugin.java:44)
... 6 more

SEVERE: Migration action failed

The ...\Oracle_Home\user_projects\domains\bi\migration-diagnostics.zip file was collected for a review of the included ...bilogs\metadata\content\webcatmetadataplugin.#.#.log files.  The following errors were observed:

webcatmetadataplugin.0.1.log:

JAVA_HOME: /usr/java/jdk1.8.0_65
Error occurred during initialization of VM
Cannot create VM thread. Out of system resources.
An error has occurred while executing command, Please check Catalog Manager log for more details.

webcatmetadataplugin.0.0.log:

JAVA_HOME: /usr/java/jdk1.8.0_65
Error occurred during initialization of VM
java.lang.OutOfMemoryError: unable to create new native thread
An error has occurred while executing command, Please check Catalog Manager log for more details.

Cause

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