Oracle Analytics Cloud and Server

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

What is the best way to move some metadata from one BI Env to another

Received Response
154
Views
17
Comments
deniska
deniska Rank 5 - Community Champion

OBIEE 12.2.1.4

I created some App Roles and assigned some Presentation services privileges to one of them

I have to move it (App Roles and Presentation services privileges) to another environment.

Ive found this article in manual

https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-7FCD90A3-E005-49BF-902F-30FBF9B41B07.htm#BIESG2889

But probably there are different manuals with more description?

«1

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Using the BI Archive files are is the right method for migrating content (catalog, repository, security) from one environment to another.

    Application Roles however, need to be done differently.Use this as a guide - http://www.elffar.co.uk/blog/obiee-12c-weblogic-user-migration

  • deniska
    deniska Rank 5 - Community Champion

    I haven't found any mention about my Application Roles inside 5 dat-files after

    export (

    exportIndex.dat

    XACMLRoleMapper.dat

    DefaultCredentialMapper.dat

    XACMLAuthorizer.dat

    DefaultAuthenticator.dat

    )

    And I created them in EM, not in Console.

    And these example is about how to migrate roles from BI 11 to 12

  • Joel
    Joel Rank 8 - Analytics Strategist

    To be clear, this is a 2 step process where you export the application roles from your source server and then import them into your target server. This is all done via the WebLogic Admin Console.

  • deniska
    deniska Rank 5 - Community Champion

    II know that it is 2 step process but I dont think that I should run import step because there is no new custom Application roles I created in EM.

    These are 5 text-readable files and found some new info(like new Admin user Denis) but no info about roles

  • deniska
    deniska Rank 5 - Community Champion

    When I try to create bar file

    export_service_instance('c:/Oracle/Middleware/Oracle_Home/user_projects/domains/bi_domain','ssi','c:/temp','c:/temp/New')

    I get following error

    Exception in thread "main"... required system property not set: oracle.bi.servicelcm.producthome

  • deniska
    deniska Rank 5 - Community Champion

    Ooo...I see a there are bugs and wrong info in Oracle docs.

    Ok

    I tried

    export_service_instance ssi c:\temp\denis.bar

    No success

    Next I add

    -Doracle.bi.servicelcm.producthome=%PRODUCT_HOME%

    to

    c:\Oracle\Middleware\Oracle_Home\bi\modules\oracle.bi.servicelcm\scripts\export_service_instance.cmd

    AND exporting began

    BUT

    bar file wasnt created

    And Im on Win Server 2012

    2 node cluster

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you seen this article?

    Oracle Support Document 2406648.1 (OBIEE 12c: What Command Should Be Used To Import An Exported Service Instance Bar File In OBI 12.2.1.4?) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2406648.1

    Also, look at this article - Oracle Support Document 2463087.1 (OBIEE 12c: PROBLEM_EXPORTING_BAR_FILE error when exporting BAR file) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2463087.1

  • deniska
    deniska Rank 5 - Community Champion

    Yup.

    Ive already found out that I have to use export_service_instance for export.

    And Ive found out that it is not work without parameter -Doracle.bi.servicelcm.producthome=%PRODUCT_HOME% added in system bi file.

    As I mentioned before the process started but finished with error...

  • deniska
    deniska Rank 5 - Community Champion

    Ive tried to create bar file from another single(non-clastered) instance(no additional cusotm roles and settings in Pres services) and that worked.

    Could It be because of clastered-instance?

    Probably I should do anything else?

  • deniska
    deniska Rank 5 - Community Champion

    Ive found one error in LOG regarding OfflineJaznContentPlugin_exportArchive

    bar2.jpg