OBIEE 11g to 12c Upgrade issue — Oracle Analytics

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

OBIEE 11g to 12c Upgrade issue

Received Response
11
Views
3
Comments
Rajagopal R-Oracle
Rajagopal R-Oracle Rank 5 - Community Champion
edited Aug 13, 2024 6:08PM in Oracle Analytics Cloud and Server

Hi.,

Getting "SEVERE  Failed on running migrate policy store , java.lang.Exception: Script returned non-zero value" while exporting 11g into a jar file using migration_tool.jar

What could be the cause for this error.

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    You'll need to provide more information if you're going to get any assistance here. Some screenshots will be helpful as well as some idea of where exactly this is happening, what versions you're upgrading from and to, which OS etc.

  • Rajagopal R-Oracle
    Rajagopal R-Oracle Rank 5 - Community Champion

    Trying migrtion from 11.1.1.9.5 to 12c in Linux server .,  when I run the export command

    java -jar <obieehome>/Migration/bi-migration-tool.jar out <obieehome>/Oracle_BI1 <obieehome>/user_projects/domains/bifoundation_domain <obieehome>/Migration/export.jar

    getting the below exception

    NFO    Calling migrate policy store with parameters: [policyStore, <OBIEEHome>user_projects/domains/bifoundation_domain/config/fmwconfig/jps-config-migration.xml, default, policystore_dest_context] <oracle.bi.metadata.export11g.JAZNExporter migrationSecurityStore>

    2017-01-03 11:08:09 SEVERE  Failed on running migrate policy store.

    java.lang.Exception: Script returned non-zero value

      at oracle.bi.metadata.export11g.JAZNExporter.migrationSecurityStore(JAZNExporter.java:201)

      at oracle.bi.metadata.export11g.ExistingMetadataLocator11g.retrieveJaznFile(ExistingMetadataLocator11g.java:155)

      at oracle.bi.metadata.export11g.ExistingMetadataLocator11g.<init>(ExistingMetadataLocator11g.java:119)

      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)

  • Joel
    Joel Rank 8 - Analytics Strategist

    https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=265383940610711&id=2126027.1&_afrWindowMode=0&_adf.ctr…

    This is specific to Windows but it might point you in the right direction.