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 Bar Utility issue

Received Response
91
Views
15
Comments
Hamza Shakeel
Hamza Shakeel Rank 5 - Community Champion
edited Aug 13, 2024 5:34PM in Oracle Analytics Cloud and Server

Hi Guys,

I have used the BAR utility to migrate my Production Server data model, security model and authorization model to a Test Server. The process completed successfully, however even though my analysis were trasnfereed successfully but the repository and users that i have created were not transfered.

Can you tell me why it would have happen?

Regards,


Farrukh Nasir Siddiqui

«1

Answers

  • Rajesh Dhanapal
    Rajesh Dhanapal Rank 4 - Community Specialist

    Hi,

    It depends on how you imported and exported the BAR file. When importing a BAR file you can choose whether to import all three components (RPD, catalog, security model), or just selected elements.

    Please refer the Oracle Documentation:

    https://docs.oracle.com/middleware/1221/biee/BIESG/configrepos.htm#BIESG9314

    Best regards,

    Rajesh Dhanapal.

  • Hamza Shakeel
    Hamza Shakeel Rank 5 - Community Champion

    Hi,

    while importing I did not set the flag to false, as the document stated that the default value for rpd and others parameters is true.

    regards,

  • Joel
    Joel Rank 8 - Analytics Strategist

    Which version of OBIEE are you running? What are the commands that you're running to import/export the BAR file?

  • Hamza Shakeel
    Hamza Shakeel Rank 5 - Community Champion

    I am using OBIEE 12.2.1.2.0.

    The commands i used were

    • exportServiceInstance('/d01/oracle/BIPROD/biapps/user_projects/domains/bi','ssi',  '/d01/BAR_TEMP/workDir', '/d01/BAR_TEMP/expDir')

    and

    • ImportServiceInstance('/d01/oracle/BIPROD/biapps/user_projects/domains/bi','ssi','/d01/BAR_TEMP/xxx.bar')

  • Hamza Shakeel
    Hamza Shakeel Rank 5 - Community Champion

    ?

  • Joel
    Joel Rank 8 - Analytics Strategist

    I was thinking of making a remark about your question mark thread but I'll ignore it.

    The only artefacts included in the BAR file are

    1. repository data model
    2. presentation services catalog
    3. security policy which includes application roles and membership

    It doesn't include users. In your version of 12c, there are no options to specify what content you want included/excluded in the BAR file so yours should contain the 3 artefacts listed above. Not sure why yours would exclude your rpd.

  • Hamza Shakeel
    Hamza Shakeel Rank 5 - Community Champion

    Hi Joel,

    Lets just stick to the question and not the question mark.

    Exactly my point, my bar file should include the rpd, but it didnt.

  • Joel
    Joel Rank 8 - Analytics Strategist

    What do your exportserviceinstance log files tell you? Any clues in them? The log files are typically located here:

    FMW HOME\user_projects\domains\bi\bilogs\service_instances

  • Hamza Shakeel
    Hamza Shakeel Rank 5 - Community Champion

    Hi Joel,

    I tried running the uility again.

    I face another issue now , folders in my catalog are not transferred as well.

  • Hamza Shakeel
    Hamza Shakeel Rank 5 - Community Champion

    Hi Guys,

    Joel Thanks for your updates.

    I raised an SR for this issue. I faced 3 issues.

    1) repository were not transferred

    2) User Folder in Catalogs were not transferred

    3) Users created were not transferred

    The SR provided me a solution for the first two issues as follows

    export command :

    i. make sure obiee services are down to avoid any lock / cache files in catalog

    ii. work directory and export directory should be always clean

    iii. personal folder catalog objects needs to be include in bar file , add parameter : includeCatalogRuntimeInfo=true in export command

    exportServiceInstance(domainHome serviceInstanceKey workDir, exportDir, includeCatalogRuntimeInfo=true)

    e.g.

    exportServiceInstance('/scratch/mydir/oraclehome/user_projects/domains/bi', 'demosvc1', '/scratch/mydir/workDir', '/scratch/mydir/exportDir', includeCatalogRuntimeInfo=true)

    For the 3) issue

    SR says  : Yes, if it Application roles it will get imported but not the users created in the console

    I am just facing this issue that I have created 12 new users on the Production Server and I want them to transferred to TEST Server using the BAR utility.

    I hope this helps others aswell.

    Regards,

    Farrukh Nasir Siddiqui