Oracle Analytics Cloud and Server

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

Migration Error - OBIEE 11g to 12c

Received Response
42
Views
5
Comments
3435205
3435205 Rank 1 - Community Starter

Hi,

Created the export bundle using bi-migration-tool.jar in 11g, which is having JDK version jdk1.8.0_92.

When i tried to import the export bundle in 12c, linux terminal got stuck with the step "Performing actual import".

Pasted the migration log file. Please help me resolve the issue.

2017-05-02 12:10:20 INFO    Loading 12c jars from '/local/obi12c/obi12c_middleware/Oracle_Home' <oracle.bi.migration.tool.MigrationTool prepareForAction>

2017-05-02 12:10:20 WARNING Can't find jar /local/obi12c/obi12c_middleware/Oracle_Home/oracle_common/modules/oracle.jps/../../modules/org.dom4j.jar referenced from /local/obi12c/obi12c_middleware/Oracle_Home/oracle_common/modules/oracle.jps/jps-manifest.jar <oracle.bi.migration.tool.environment.ClasspathInjector findDependencies>

2017-05-02 12:10:20 WARNING Can't find jar /local/obi12c/obi12c_middleware/Oracle_Home/oracle_common/modules/oracle.jps/../../modules/org.apache.neethi.jar referenced from /local/obi12c/obi12c_middleware/Oracle_Home/oracle_common/modules/oracle.jps/jps-manifest.jar <oracle.bi.migration.tool.environment.ClasspathInjector findDependencies>

2017-05-02 12:10:20 WARNING Can't find jar /local/obi12c/obi12c_middleware/Oracle_Home/oracle_common/modules/oracle.jps/../../modules/org.jaxen.jar referenced from /local/obi12c/obi12c_middleware/Oracle_Home/oracle_common/modules/oracle.jps/jps-manifest.jar <oracle.bi.migration.tool.environment.ClasspathInjector findDependencies>

2017-05-02 12:10:20 WARNING Can't find jar /local/obi12c/obi12c_middleware/Oracle_Home/bi/lib/./bi-dss-content-archive-plugin.jar referenced from /local/obi12c/obi12c_middleware/Oracle_Home/bi/lib/bi-bar.jar <oracle.bi.migration.tool.environment.ClasspathInjector findDependencies>

2017-05-02 12:10:20 INFO    Attempting to import a migration bundle <oracle.bi.migration.tool.MigrationTool informUser>

2017-05-02 12:10:20 INFO    Top-level install directory is: /local/obi12c/obi12c_middleware/Oracle_Home <oracle.bi.migration.tool.MigrationTool informUser>

2017-05-02 12:10:20 INFO    Domain home directory is: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi <oracle.bi.migration.tool.MigrationTool informUser>

2017-05-02 12:10:20 INFO    Input migration bundle file is: /local/obi12c/ob12c_softwares/Export_output.jar <oracle.bi.migration.tool.MigrationTool informUser>

2017-05-02 12:10:20 INFO    Java version is: 1.8.0_121 <oracle.bi.migration.orchestration.actionspecification.ImportAction validateParametersAndEnvironment>

2017-05-02 12:10:20 INFO    Top level install directory: /local/obi12c/obi12c_middleware/Oracle_Home <oracle.bi.migration.orchestration.actionspecification.ImportAction validateParametersAndEnvironment>

2017-05-02 12:10:20 INFO    Domain Home: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi <oracle.bi.migration.orchestration.actionspecification.ImportAction validateParametersAndEnvironment>

2017-05-02 12:10:20 INFO    Export Bundle: /local/obi12c/ob12c_softwares/Export_output.jar <oracle.bi.migration.orchestration.actionspecification.ImportAction validateParametersAndEnvironment>

2017-05-02 12:10:21 INFO    Singleton data directory: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/bidata <oracle.bi.migration.orchestration.actionspecification.ImportAction validateParametersAndEnvironment>

2017-05-02 12:10:21 INFO    Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar <oracle.bi.migration.bundle.extraction.BundleExtractor extractBundle>

2017-05-02 12:10:21 INFO    Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar <oracle.bi.migration.bundle.extraction.BundleExtractor extractBundle>

2017-05-02 12:10:22 INFO    No packaging mismatch <oracle.bi.migration.orchestration.actionspecification.AbstractImportAction checkPackagingDate>

2017-05-02 12:10:22 INFO    Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar <oracle.bi.migration.bundle.extraction.BundleExtractor extractBundle>

2017-05-02 12:10:22 INFO    Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar <oracle.bi.migration.bundle.extraction.BundleExtractor extractBundle>

2017-05-02 12:10:50 INFO    Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar <oracle.bi.migration.bundle.extraction.BundleExtractor extractBundle>

2017-05-02 12:10:50 INFO    Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar <oracle.bi.migration.bundle.extraction.BundleExtractor extractBundle>

2017-05-02 12:10:50 INFO    Bundle contains data from: 1 plugins <oracle.bi.migration.orchestration.ExplodeBundleContentToDisk$Receiver receiveManifest>

2017-05-02 12:10:50 INFO    Bundle contains data for: metadata <oracle.bi.migration.orchestration.ExplodeBundleContentToDisk$Receiver recievePluginFile>

2017-05-02 12:10:53 INFO    Bundle contains shipped config: InstanceFiles/1_config_OracleBIPresentationServicesComponent_coreapplication__obips1_instanceconfig.xml <oracle.bi.migration.orchestration.ExplodeBundleContentToDisk$Receiver receiveShippedFile>

2017-05-02 12:10:53 INFO    Bundle contains shipped config: InstanceFiles/1_config_OracleBIServerComponent_coreapplication__obis1_NQSConfig.INI <oracle.bi.migration.orchestration.ExplodeBundleContentToDisk$Receiver receiveShippedFile>

2017-05-02 12:10:53 INFO    Bundle contains shipped config: InstanceFiles/1_config_OPMN_opmn_opmn.xml <oracle.bi.migration.orchestration.ExplodeBundleContentToDisk$Receiver receiveShippedFile>

2017-05-02 12:10:53 INFO    The following import plugins are configured: metadata, ObiSch, Obips, obis <oracle.bi.migration.orchestration.BundleImporter_ runImport>

2017-05-02 12:10:53 INFO    Validating system prior to import <oracle.bi.migration.tool.MigrationTool informUser>

2017-05-02 12:10:53 INFO    Validating import for plugin metadata <oracle.bi.migration.orchestration.BundleImporter_ doPluginValidation>

2017-05-02 12:10:53 INFO    Validating import for plugin ObiSch <oracle.bi.migration.orchestration.BundleImporter_ doPluginValidation>

2017-05-02 12:10:53 INFO    Validating import for plugin Obips <oracle.bi.migration.orchestration.BundleImporter_ doPluginValidation>

2017-05-02 12:10:53 INFO    Validating import for plugin obis <oracle.bi.migration.orchestration.BundleImporter_ doPluginValidation>

2017-05-02 12:10:53 INFO    Shipped NQSConfig.INI file is in: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-shipped-files1493741450238/InstanceFiles/1_config_OracleBIServerComponent_coreapplication__obis1_NQSConfig.INI <oracle.bi.cam.obis.migration.ObisPlugin validate>

2017-05-02 12:10:53 INFO    Domain Home is: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi <oracle.bi.cam.obis.migration.ObisPlugin validate>

2017-05-02 12:10:53 INFO    Existing NQSConfig.INI file is in: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/config/fmwconfig/biconfig/OBIS/NQSConfig.INI <oracle.bi.cam.obis.migration.ObisPlugin validate>

2017-05-02 12:10:53 INFO    Shipped opmn.xml file is in: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-shipped-files1493741450238/InstanceFiles/1_config_OPMN_opmn_opmn.xml <oracle.bi.cam.obis.migration.ObisPlugin validate>

2017-05-02 12:10:53 INFO    Existing obis.properties file is in: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/config/fmwconfig/bienv/OBIS/obis.properties <oracle.bi.cam.obis.migration.ObisPlugin validate>

2017-05-02 12:10:53 INFO    Temporary directory for plugin is: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-plugin-data1493741450238/PerPluginTemp/obis <oracle.bi.cam.obis.migration.ObisPlugin validate>

2017-05-02 12:10:53 INFO    Performing actual import <oracle.bi.migration.tool.MigrationTool informUser>

2017-05-02 12:10:53 INFO    Transforming BAR: domainHome=/local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi, oracleHome=/local/obi12c/obi12c_middleware/Oracle_Home, dataFile=/local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-plugin-data1493741450238/metadata/metadata.bar <oracle.bi.migration.plugin.metadata.MetadataImportPlugin importData>

2017-05-02 12:10:53 INFO    Extracting 11g bundle to folder: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-plugin-data1493741450238/PerPluginTemp/metadata/11gExtracted <oracle.bi.migration.plugin.metadata.TransformBar transformBar>

2017-05-02 12:10:56 INFO    Successfully extracted 11g bar to /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-plugin-data1493741450238/PerPluginTemp/metadata/11gExtracted <oracle.bi.migration.plugin.metadata.TransformBar transformBar>

2017-05-02 12:10:56 INFO    Building plugin list <oracle.bi.migration.plugin.metadata.TransformBar buildTransformPlugins>

2017-05-02 12:10:56 INFO    Extracing catalog content  to : /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-plugin-data1493741450238/PerPluginTemp/metadata/11gExtracted/metadata/runtime/content <oracle.bi.migration.catalog.WebcatTransformContext populateInputParams>

2017-05-02 12:11:46 INFO    delete result of file: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-plugin-data1493741450238/PerPluginTemp/metadata/11gExtracted/metadata/runtime/content/live.cat is true <oracle.bi.migration.catalog.WebcatTransformContext populateInputParams>

2017-05-02 12:11:46 INFO    msgdb contents does not exists in 11g bar <oracle.bi.migration.catalog.WebcatTransformContext populateInputParams>

2017-05-02 12:11:46 INFO    Creating a emtpy msgdb folder <oracle.bi.migration.catalog.WebcatTransformContext populateInputParams>

2017-05-02 12:11:46 INFO    Invoking transformation plugin for metadata - RPD <oracle.bi.migration.plugin.metadata.MetadataPlugin run>

2017-05-02 12:11:46 INFO    Invoking transformation plugin for metadata - WEBCAT <oracle.bi.migration.plugin.metadata.MetadataPlugin run>

2017-05-02 12:11:46 INFO    Invoking transformation plugin with parameter - {runtime.rpd.password=Admin123, runtime.rpd=/local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-plugin-data1493741450238/PerPluginTemp/metadata/11gExtracted/metadata/runtime/datamodel/live.rpd} <oracle.bi.migration.plugin.metadata.MetadataPlugin run>

2017-05-02 12:11:46 INFO    Invoking transformation plugin with parameter - {instance.config=/local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-shipped-files1493741450238/InstanceFiles/1_config_OracleBIPresentationServicesComponent_coreapplication__obips1_instanceconfig.xml, runtime.content=/local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-plugin-data1493741450238/PerPluginTemp/metadata/11gExtracted/metadata/runtime/content} <oracle.bi.migration.plugin.metadata.MetadataPlugin run>

2017-05-02 12:11:46 INFO    Transforming Runtime RPD <oracle.bi.migration.RPDTransformPlugin doTransform>

2017-05-02 12:11:46 INFO    Executing Command: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/bitools/bin/biserverxmlgen.sh -R /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-plugin-data1493741450238/PerPluginTemp/metadata/11gExtracted/metadata/runtime/datamodel/live.rpd -P ***** -O /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/tmp/bi/migration-tool/migration-bundle-plugin-data1493741450238/PerPluginTemp/metadata/rpd/live.rpd/datamodel/customizations/default/default_diff.xml -8 -B  <oracle.bi.metadata.util.TransformRpdUtil executeBiCmd>

2017-05-02 12:12:31 INFO    RPD Transformation plugin exited with result: true <oracle.bi.migration.plugin.metadata.MetadataPlugin run>

Regards,

Sudhen

Answers

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    In the Log message there is nothing wrong... have you tried checking other server logs?

  • user1692634
    user1692634 Rank 1 - Community Starter

    Hi,

    We get the same errors.  (I have added it to the SR we have for our migration issues, but was hoping for a speedier resolution.)
    Our environment is an Exalytics T5-8 server, running Solaris 11.  Both 11g and 12c are on the same server in different ORACLE_HOMEs.

    Our import fails with the following messages:

    Performing actual import
    An error occurred during import: Plugin metadata -- oracle.bi.migration.plugin.metadata.TransformBarException: Transformation failed. Check logs for failure messages.
    Import failed: Plugin metadata -- oracle.bi.migration.plugin.metadata.TransformBarException: Transformation failed. Check logs for failure messages.

    We get the following lines from the log (Basically the same as Sudhen's):

    2017-05-19 11:11:50 WARNING Can't find jar /u01/app/oracle/product/fmw/OBI_12c/oracle_common/modules/oracle.jps/../../modules/org.dom4j.jar referenced from /u01/app/oracle/product/fmw/OBI_12c/oracle_common/modules/oracle.jps/jps-manifest.jar <oracle.bi.migration.tool.environment.ClasspathInjector findDependencies>
    2017-05-19 11:11:50 WARNING Can't find jar /u01/app/oracle/product/fmw/OBI_12c/oracle_common/modules/oracle.jps/../../modules/org.apache.neethi.jar referenced from /u01/app/oracle/product/fmw/OBI_12c/oracle_common/modules/oracle.jps/jps-manifest.jar <oracle.bi.migration.tool.environment.ClasspathInjector findDependencies>
    2017-05-19 11:11:50 WARNING Can't find jar /u01/app/oracle/product/fmw/OBI_12c/oracle_common/modules/oracle.jps/../../modules/org.jaxen.jar referenced from /u01/app/oracle/product/fmw/OBI_12c/oracle_common/modules/oracle.jps/jps-manifest.jar <oracle.bi.migration.tool.environment.ClasspathInjector findDependencies>
    2017-05-19 11:11:50 WARNING Can't find jar /u01/app/oracle/product/fmw/OBI_12c/bi/lib/./bi-dss-content-archive-plugin.jar referenced from /u01/app/oracle/product/fmw/OBI_12c/bi/lib/bi-bar.jar <oracle.bi.migration.tool.environment.ClasspathInjector findDependencies>

    We also get the following lines in the log:

    2017-05-19 11:12:21 SEVERE  biserverxmlgen Failed to generate /u01/app/oracle/product/fmw/OBI_12c/user_projects/domains/bifoundation_domain/tmp/bi/migration-tool/migration-bundle-plugin-data1495185120711/PerPluginTemp/metadata/rpd/live.rpd/datamodel/customizations/default/default_diff.xml <oracle.bi.metadata.util.TransformRpdUtil generateXml>
    2017-05-19 11:12:21 SEVERE  Runtime RPD transformation failed <oracle.bi.migration.RPDTransformPlugin doTransform>
    2017-05-19 11:14:45 SEVERE  Metadata plugin returned false after transformation: RPD <oracle.bi.migration.plugin.metadata.TransformBar transformBar>
    2017-05-19 11:14:45 SEVERE  biserverxmlgen exited with status 9 <oracle.bi.migration.plugin.metadata.TransformBar processPluginMessages>
    2017-05-19 11:14:45 SEVERE  ld.so.1: biserverxmlgen: fatal: relocation error: file /u01/app/oracle/product/fmw/OBI_12c/bi/bifoundation/server/bin/biserverxmlgen: symbol S_OS_DEFAULT_USER: referenced symbol not found <oracle.bi.migration.plugin.metadata.TransformBar processPluginMessages>
    2017-05-19 11:14:45 SEVERE  An error occurred during import: Plugin metadata -- oracle.bi.migration.plugin.metadata.TransformBarException: Transformation failed. Check logs for failure messages.

    Regards
    Casper

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Hi Casper,

    Looks like your 11g import into 12c environment is failing at 11g RPD migration into 12c environment and it is due to below error

    "symbol S_OS_DEFAULT_USER: referenced symbol not found"

    Could you open your OBIEE 11g RPD in OBIEE 11g BI Administration Client Tool and perform consistency check of your 11g RPD to see if passes all the checks, because if it fails then you need to fix the errors and perform migration from scratch after fixing the error and placing the fixed RPD in your environment.

    In your case in your 11g RPD you should look if there is there any reference of object with name "S_OS_DEFAULT_USER" whereas object itself is missing.

    You can also refer to below mentioned KM document:

    OBIEE 12c: Migration Of Export Bundle From OBIEE 11g Fails With "Runtime RPD transformation failed' (Doc ID 2178640.1)

    Thanks and Regards,

    Syed Hamd Salman

  • user1692634
    user1692634 Rank 1 - Community Starter

    Hi Syed,

    Thanks for the reply!

    We will action your suggestions and reply with an update asap.

    Regards,

    Casper

  • user1692634
    user1692634 Rank 1 - Community Starter

    Hi,

    Our solution was simple:

    Make sure that no older version environment variable are set and do not set any environment variables for 12c either before doing the import.

    Thats it.

    Regards,

    Casper