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

How to migrate OBI-EM roles in OBI12c

Received Response
49
Views
6
Comments
User_B7ZTH
User_B7ZTH Rank 5 - Community Champion
edited Aug 13, 2024 5:48PM in Oracle Analytics Cloud and Server

Hello Experts,

We have a new environment of OBI with vanilla installation of OBI12c.

We have a requirement to move EM application roles from Prod to new dev environment.

We are getting lot of document for OBI11g but not for OBI12c.

Any help will be appreciated.

Thanks a lot for help.

Abhi

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you tried using BAR files for your migration?

    Welcome to OBIEE12c: Using BI Application Archive (BAR) files

    You didn't mention your 12c version as the APIs referred to in this article are deprecated in 12.2.1.3 and don't run in 12.2.1.4

  • User_B7ZTH
    User_B7ZTH Rank 5 - Community Champion

    Hello Joel,

    Thanks for your response.

    Sorry, my bad not to mention the version.

    OBI version is 12.2.1.1.0 (Build BIPS-20160604082456 64-bit).

    Just want to know that did moving of BAR will copy of all the EM roles and place with Catalog and rpd.

    Kindly correct me if I am wrong.

    Thanks a lot for your help.

  • Joel
    Joel Rank 8 - Analytics Strategist

    The BAR file contains the web catalog, repository and security - https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-7FCD90A3-E005-49BF-902F-30FBF9B41B07.htm#BIESG9295 

    You can specify which of these you want to import into your target instance.

  • User_B7ZTH
    User_B7ZTH Rank 5 - Community Champion

    Hello Joel,

    I am executing below command:-

    exportServiceInstance('/u01/app/obiee/product/user_projects/domains/bi','ssi','/u01/app/obiee/workDir','/u01/app/obiee/exportDir')

    but in the middle I am getting the below error:-

    [EL Severe]: ejb: 2018-05-16 16:05:15.759--ServerSession(1794980605)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160526-8f41838): org.eclipse.persistence.exceptions.DatabaseException

    Internal Exception: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

    Error Code: 17002

    Kindly suggest if I am doing anything wrong.

    Thanks for all your help.

  • Joel
    Joel Rank 8 - Analytics Strategist

    are you running WLST offline or online? Do both throw this exception? Try running it in online mode

  • User_B7ZTH
    User_B7ZTH Rank 5 - Community Champion

    Thanks Joel, .bar file worked.