Migration Error - OBIEE 11g to 12c

Question

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' 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 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 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 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 2017-05-02 12:10:20 INFO Attempting to import a migration bundle 2017-05-02 12:10:20 INFO Top-level install directory is: /local/obi12c/obi12c_middleware/Oracle_Home 2017-05-02 12:10:20 INFO Domain home directory is: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi 2017-05-02 12:10:20 INFO Input migration bundle file is: /local/obi12c/ob12c_softwares/Export_output.jar 2017-05-02 12:10:20 INFO Java version is: 1.8.0_121 2017-05-02 12:10:20 INFO Top level install directory: /local/obi12c/obi12c_middleware/Oracle_Home 2017-05-02 12:10:20 INFO Domain Home: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi 2017-05-02 12:10:20 INFO Export Bundle: /local/obi12c/ob12c_softwares/Export_output.jar 2017-05-02 12:10:21 INFO Singleton data directory: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi/bidata 2017-05-02 12:10:21 INFO Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar 2017-05-02 12:10:21 INFO Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar 2017-05-02 12:10:22 INFO No packaging mismatch 2017-05-02 12:10:22 INFO Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar 2017-05-02 12:10:22 INFO Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar 2017-05-02 12:10:50 INFO Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar 2017-05-02 12:10:50 INFO Opening bundle: /local/obi12c/ob12c_softwares/Export_output.jar 2017-05-02 12:10:50 INFO Bundle contains data from: 1 plugins 2017-05-02 12:10:50 INFO Bundle contains data for: metadata 2017-05-02 12:10:53 INFO Bundle contains shipped config: InstanceFiles/1_config_OracleBIPresentationServicesComponent_coreapplication__obips1_instanceconfig.xml 2017-05-02 12:10:53 INFO Bundle contains shipped config: InstanceFiles/1_config_OracleBIServerComponent_coreapplication__obis1_NQSConfig.INI 2017-05-02 12:10:53 INFO Bundle contains shipped config: InstanceFiles/1_config_OPMN_opmn_opmn.xml 2017-05-02 12:10:53 INFO The following import plugins are configured: metadata, ObiSch, Obips, obis 2017-05-02 12:10:53 INFO Validating system prior to import 2017-05-02 12:10:53 INFO Validating import for plugin metadata 2017-05-02 12:10:53 INFO Validating import for plugin ObiSch 2017-05-02 12:10:53 INFO Validating import for plugin Obips 2017-05-02 12:10:53 INFO Validating import for plugin obis 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 2017-05-02 12:10:53 INFO Domain Home is: /local/obi12c/obi12c_middleware/Oracle_Home/user_projects/domains/bi 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 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 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 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 2017-05-02 12:10:53 INFO Performing actual import 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 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 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 2017-05-02 12:10:56 INFO Building plugin list 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 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 2017-05-02 12:11:46 INFO msgdb contents does not exists in 11g bar 2017-05-02 12:11:46 INFO Creating a emtpy msgdb folder 2017-05-02 12:11:46 INFO Invoking transformation plugin for metadata - RPD 2017-05-02 12:11:46 INFO Invoking transformation plugin for metadata - WEBCAT 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} 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} 2017-05-02 12:11:46 INFO Transforming Runtime RPD 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 2017-05-02 12:12:31 INFO RPD Transformation plugin exited with result: true Regards, Sudhen

user1692634 · Answer

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

user1692634 · Answer

Hi Syed,

Thanks for the reply!

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

Regards,

Casper

Syedsalmancs110 · Answer

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