11g to 12c export process

Question

11g TEST Oracle Business Intelligence Product Version 11.1.1.9.0 (Build 150417.0810 64-bit) on Windows 12c TEST Oracle Business Intelligence Product Version 12.2.1.3.0 (Build BIPS-20170820114118 64-bit) I have already done the export from 11g DEV to 12c DEV and it went according to plan. I am trying to do the same from 11g TEST to 12c TEST and am getting an error when creating the export from 11g. The command I am using is java -jar c:\migration\bi-migration-tool.jar out E:\Oracle\Middleware\Oracle_BI1 E:\Oracle\Middleware\user_projects\domains\bifoundation_domain c:\migration\BI11g.jar This is the log file content 2018-05-07 08:12:00 INFOLoading 11g jars from 'E:\Oracle\Middleware' 2018-05-07 08:12:00 INFOFound domain config file at: E:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\biee-domain.xml 2018-05-07 08:12:00 INFODetermined instance directory to be: E:\Oracle\Middleware\instances\instance1 2018-05-07 08:12:00 INFOCreating a migration bundle 2018-05-07 08:12:00 INFOTop-level install directory is: E:\Oracle\Middleware 2018-05-07 08:12:00 INFODomain home directory is: E:\Oracle\Middleware\user_projects\domains\bifoundation_domain 2018-05-07 08:12:00 INFOInstance directory is: E:\Oracle\Middleware\instances\instance1 2018-05-07 08:12:00 INFOOutput migration bundle file is: c:\migration\BI11g.jar 2018-05-07 08:12:00 INFOPackaging date: Mon Apr 30 15:28:00 EDT 2018 2018-05-07 08:12:02 INFOMigration tool jar: C:\migration\bi-migration-tool.jar 2018-05-07 08:12:02 SEVERE Couldn't determine repository directory java.lang.RuntimeException: Failed to execute command at oracle.bi.migration.externalcommandexecutors.DefaultCommandExecuter.execute(DefaultCommandExecuter.java:71) at oracle.bi.migration.externalcommandexecutors.WindowsPermissionModifier.setExecutable(WindowsPermissionModifier.java:24) at oracle.bi.migration.externalcommandexecutors.InternalScriptExecutor.executeScript(InternalScriptExecutor.java:46) at oracle.bi.migration.bidirectorydiscovery.DiscoverRepositoryDirectory.discoverRepositoryDirectory(DiscoverRepositoryDirectory.java:35) at oracle.bi.migration.bidirectorydiscovery.DiscoverRepositoryDirectory.safelyDiscoverRepositoryDirectory(DiscoverRepositoryDirectory.java:135) at oracle.bi.migration.orchestration.actionspecification.ExportAction.performAction(ExportAction.java:79) at oracle.bi.migration.orchestration.MigrationActionExecutor$1.run(MigrationActionExecutor.java:32) at java.lang.Thread.run(Thread.java:745) at oracle.bi.migration.orchestration.MigrationActionExecutor.executeMigrationAction(MigrationActionExecutor.java:52) at oracle.bi.migration.orchestration.MigrationConductor.performMigrationAction(MigrationConductor.java:122) at oracle.bi.migration.tool.MigrationTool.go(MigrationTool.java:200) at oracle.bi.migration.tool.MigrationTool.main(MigrationTool.java:255) Caused by: java.io.IOException: Cannot run program "chmod": CreateProcess error=2, The system cannot find the file specified at java.lang.ProcessBuilder.start(ProcessBuilder.java:1047) at java.lang.Runtime.exec(Runtime.java:617) at java.lang.Runtime.exec(Runtime.java:485) at oracle.bi.migration.externalcommandexecutors.DefaultCommandExecuter.execute(DefaultCommandExecuter.java:40) ... 11 more Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified at java.lang.ProcessImpl.create(Native Method) at java.lang.ProcessImpl.(ProcessImpl.java:385) at java.lang.ProcessImpl.start(ProcessImpl.java:136) at java.lang.ProcessBuilder.start(ProcessBuilder.java:1028) ... 14 more 2018-05-07 08:12:02 INFORepository directory: null 2018-05-07 08:12:02 INFOExporting to bundle: c:\migration\BI11g.jar 2018-05-07 08:12:02 INFOExporting from top level install-directory: E:\Oracle\Middleware 2018-05-07 08:12:02 INFOExporting from domain home: E:\Oracle\Middleware\user_projects\domains\bifoundation_domain 2018-05-07 08:12:02 INFOExporting from oracle 11g home: E:\Oracle\Middleware\Oracle_BI1 2018-05-07 08:12:02 INFOExporting from repository directory: null 2018-05-07 08:12:02 INFOThe following export plugins are configured: metadata, ObiSch, Obips, obis 2018-05-07 08:12:02 INFOPerforming pre-export validation 2018-05-07 08:12:02 INFOPerforming export 2018-05-07 08:12:02 INFOFile requested by default, about to copy: FileLocator [root=INSTANCE_HOME, suffix=config/OPMN/opmn/opmn.xml] 2018-05-07 08:12:02 INFOCreating barFile: E:\Oracle\Middleware\user_projects\domains\bifoundation_domain mp\bi\migration-tool\migration-bundle-plugin-data1525695122226\PerPluginTemp\metadata\metadata.bar 2018-05-07 08:12:02 INFOFound domain config file at: E:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\biee-domain.xml 2018-05-07 08:12:02 SEVERE An error occurred during export: java.lang.NullPointerException java.lang.NullPointerException at oracle.bi.metadata.export11g.ExistingMetadataLocator11g.(ExistingMetadataLocator11g.java:63) at oracle.bi.metadata.export11g.Export11gBar.exportBar(Export11gBar.java:79) at oracle.bi.migration.plugin.metadata.MetadataExportPlugin.export(MetadataExportPlugin.java:38) at oracle.bi.migration.api.adaptor.exporter.V1ExporterPluginAdaptor.export(V1ExporterPluginAdaptor.java:58) at oracle.bi.migration.orchestration.BundleExporter.doExport(BundleExporter.java:287) at oracle.bi.migration.orchestration.BundleExporter.doExport(BundleExporter.java:228) at oracle.bi.migration.orchestration.BundleExporter.runExport(BundleExporter.java:115) at oracle.bi.migration.orchestration.actionspecification.ExportAction.performAction(ExportAction.java:95) at oracle.bi.migration.orchestration.MigrationActionExecutor$1.run(MigrationActionExecutor.java:32) at java.lang.Thread.run(Thread.java:745) at oracle.bi.migration.orchestration.MigrationActionExecutor.executeMigrationAction(MigrationActionExecutor.java:52) at oracle.bi.migration.orchestration.MigrationConductor.performMigrationAction(MigrationConductor.java:122) at oracle.bi.migration.tool.MigrationTool.go(MigrationTool.java:200) at oracle.bi.migration.tool.MigrationTool.main(MigrationTool.java:255) I searched the NullPointerException error but the answers I found do not seem to be for the same issue. Any help is appreciated. Thanks, Stacey

[Deleted User] · Answer

With legacy rubbish I mainly meant config file contents: It's preferable to work with correct and thought-through settings rather than a wild mix of old as well as new and vanilla.

The best option? Use the command line tools which are actually used by the JAR in the background - but just a lot more focused and under your control. (instead  of just a bulk dump)

Stacey D · Answer

Other than the initial error I got on the 11g DEV export, it was a relatively smooth process. In our 11g environment, we don't have a lot of messy stuff, we do a refresh once a month from production down to TEST and DEV through Catalog Mgr, just to keep everything as in sync as possible.  My concern is once we get to PreProd we will want the most up to date copy of 11g Preprod so just migrating from 12c TEST to 12c Preprod wouldn't accomplish that. And of course Prod would need to be an exact match to 11g Prod.We started on 11g, so have not been through an upgrade before, what would be the best option if we don't use the JAR approach?

[Deleted User] · Answer

Any reason you want to stick to the upgrade process? Personally I found that way too much useless legacy rubbish gets transferred and stopped using the JAR approach after the first couple of problems.