Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

11g to 12c export process

Received Response
3
Views
3
Comments
Stacey D
Stacey D Rank 2 - Community Beginner
edited Aug 13, 2024 5:48PM in Oracle Analytics Cloud and Server

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' <oracle.bi.migration.tool.MigrationTool prepareForAction>
2018-05-07 08:12:00 INFOFound domain config file at: E:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\biee-domain.xml <oracle.bi.metadata.export11g.FileNames11g getBIDomainConfigFile>
2018-05-07 08:12:00 INFODetermined instance directory to be: E:\Oracle\Middleware\instances\instance1 <oracle.bi.migration.tool.bidirectorydiscovery.Discover11gInstanceDirectory discover11gInstanceDirectory>
2018-05-07 08:12:00 INFOCreating a migration bundle <oracle.bi.migration.tool.MigrationTool informUser>
2018-05-07 08:12:00 INFOTop-level install directory is: E:\Oracle\Middleware <oracle.bi.migration.tool.MigrationTool informUser>
2018-05-07 08:12:00 INFODomain home directory is: E:\Oracle\Middleware\user_projects\domains\bifoundation_domain <oracle.bi.migration.tool.MigrationTool informUser>
2018-05-07 08:12:00 INFOInstance directory is: E:\Oracle\Middleware\instances\instance1 <oracle.bi.migration.tool.MigrationTool informUser>
2018-05-07 08:12:00 INFOOutput migration bundle file is: c:\migration\BI11g.jar <oracle.bi.migration.tool.MigrationTool informUser>
2018-05-07 08:12:00 INFOPackaging date: Mon Apr 30 15:28:00 EDT 2018 <oracle.bi.migration.orchestration.actionspecification.ExportAction performAction>
2018-05-07 08:12:02 INFOMigration tool jar: C:\migration\bi-migration-tool.jar <oracle.bi.migration.bidirectorydiscovery.DiscoverMigrationToolJar discoverMigrationToolJar>

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.<init>(ProcessImpl.java:385)

    at java.lang.ProcessImpl.start(ProcessImpl.java:136)

    at java.lang.ProcessBuilder.start(ProcessBuilder.java:1028)

    ... 14 more

<oracle.bi.migration.bidirectorydiscovery.DiscoverRepositoryDirectory safelyDiscoverRepositoryDirectory>

2018-05-07 08:12:02 INFORepository directory: null <oracle.bi.migration.orchestration.actionspecification.ExportAction performAction>
2018-05-07 08:12:02 INFOExporting to bundle: c:\migration\BI11g.jar <oracle.bi.migration.orchestration.BundleExporter runExport>
2018-05-07 08:12:02 INFOExporting from top level install-directory: E:\Oracle\Middleware <oracle.bi.migration.orchestration.BundleExporter runExport>
2018-05-07 08:12:02 INFOExporting from domain home: E:\Oracle\Middleware\user_projects\domains\bifoundation_domain <oracle.bi.migration.orchestration.BundleExporter runExport>
2018-05-07 08:12:02 INFOExporting from oracle 11g home: E:\Oracle\Middleware\Oracle_BI1 <oracle.bi.migration.orchestration.BundleExporter runExport>
2018-05-07 08:12:02 INFOExporting from repository directory: null <oracle.bi.migration.orchestration.BundleExporter runExport>
2018-05-07 08:12:02 INFOThe following export plugins are configured: metadata, ObiSch, Obips, obis <oracle.bi.migration.orchestration.BundleExporter runExport>
2018-05-07 08:12:02 INFOPerforming pre-export validation <oracle.bi.migration.orchestration.BundleExporter doValidation>
2018-05-07 08:12:02 INFOPerforming export <oracle.bi.migration.orchestration.BundleExporter doExport>
2018-05-07 08:12:02 INFOFile requested by default, about to copy: FileLocator [root=INSTANCE_HOME, suffix=config/OPMN/opmn/opmn.xml] <oracle.bi.migration.orchestration.BundleExporter doExport>
2018-05-07 08:12:02 INFOCreating barFile: E:\Oracle\Middleware\user_projects\domains\bifoundation_domain\tmp\bi\migration-tool\migration-bundle-plugin-data1525695122226\PerPluginTemp\metadata\metadata.bar <oracle.bi.migration.plugin.metadata.MetadataExportPlugin export>
2018-05-07 08:12:02 INFOFound domain config file at: E:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\biee-domain.xml <oracle.bi.metadata.export11g.FileNames11g getBIDomainConfigFile>

2018-05-07 08:12:02 SEVERE  An error occurred during export: java.lang.NullPointerException

java.lang.NullPointerException

    at oracle.bi.metadata.export11g.ExistingMetadataLocator11g.<init>(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)

<oracle.bi.migration.tool.MigrationTool alertUser>

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

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • Stacey D
    Stacey D Rank 2 - Community Beginner

    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]
    [Deleted User] Rank 2 - Community Beginner

    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)