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 SEPTEMBER 09, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

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

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