Export Service Instance in OBIEE 12.2.1.4 — Oracle Analytics

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

Export Service Instance in OBIEE 12.2.1.4

Received Response
525
Views
8
Comments
SonPat99
SonPat99 Rank 6 - Analytics Lead
edited Aug 13, 2024 5:36PM in Oracle Analytics Cloud and Server

Dear GURUS,

I'm on OBIEE 12.2.1.4 and it seems the process of generating BAR file has changed in this version.

Now, I am trying to generate the BAR files using "export_service_instance.cmd ssi D:\TMP" present in "<BI_HOME>user_projects\domains\bi\bitools\bin>".

However, I am getting error again and again as below:

"

SEVERE: [PROBLEM_EXPORTING_BAR_FILE] Problem exporting BAR: location=D:\TMP

java.nio.file.FileAlreadyExistsException: D:\TMP

        at sun.nio.fs.WindowsFileCopy.move(WindowsFileCopy.java:343)

        at sun.nio.fs.WindowsFileSystemProvider.move(WindowsFileSystemProvider.j

ava:287)

        at java.nio.file.Files.move(Files.java:1395)

        at oracle.bi.servicelcm_v2.internal.bar.BarImportExport.exportBar(BarImp

ortExport.java:91)

        at oracle.bi.servicelcm_v2.operations.DefaultAnalyticApplicationOperatio

ns.exportBar(DefaultAnalyticApplicationOperations.java:160)

        at oracle.bi.servicelcm_v2.domain.application.AnalyticApplicationCustomi

sation.exportBAR(AnalyticApplicationCustomisation.java:115)

        at oracle.bi.servicelcm.cli_v2.ExportServiceInstanceAction.run(ExportSer

viceInstanceAction.java:88)

        at oracle.bi.servicelcm.cli_v2.LcmCli.main(LcmCli.java:24)

Sep 06, 2018 3:10:02 AM oracle.bi.servicelcm_v2.operations.DefaultAnalyticApplic

ationOperations exportBar

SEVERE: [PROBLEM_EXPORTING_BAR_FILE] Problem exporting BAR: location=D:\TMP

java.nio.file.FileAlreadyExistsException: D:\TMP

        at sun.nio.fs.WindowsFileCopy.move(WindowsFileCopy.java:343)

        at sun.nio.fs.WindowsFileSystemProvider.move(WindowsFileSystemProvider.j

ava:287)

        at java.nio.file.Files.move(Files.java:1395)

        at oracle.bi.servicelcm_v2.internal.bar.BarImportExport.exportBar(BarImp

ortExport.java:91)

        at oracle.bi.servicelcm_v2.operations.DefaultAnalyticApplicationOperatio

ns.exportBar(DefaultAnalyticApplicationOperations.java:160)

        at oracle.bi.servicelcm_v2.domain.application.AnalyticApplicationCustomi

sation.exportBAR(AnalyticApplicationCustomisation.java:115)

        at oracle.bi.servicelcm.cli_v2.ExportServiceInstanceAction.run(ExportSer

viceInstanceAction.java:88)

        at oracle.bi.servicelcm.cli_v2.LcmCli.main(LcmCli.java:24)

Exception in thread "main" oracle.bi.servicelcm_v2.exceptions.UnexpectedBarExpor

tException: java.nio.file.FileAlreadyExistsException: D:\TMP

        at oracle.bi.servicelcm_v2.operations.DefaultAnalyticApplicationOperatio

ns.exportBar(DefaultAnalyticApplicationOperations.java:171)

        at oracle.bi.servicelcm_v2.domain.application.AnalyticApplicationCustomi

sation.exportBAR(AnalyticApplicationCustomisation.java:115)

        at oracle.bi.servicelcm.cli_v2.ExportServiceInstanceAction.run(ExportSer

viceInstanceAction.java:88)

        at oracle.bi.servicelcm.cli_v2.LcmCli.main(LcmCli.java:24)

Caused by: java.nio.file.FileAlreadyExistsException: D:\TMP

        at sun.nio.fs.WindowsFileCopy.move(WindowsFileCopy.java:343)

        at sun.nio.fs.WindowsFileSystemProvider.move(WindowsFileSystemProvider.j

ava:287)

        at java.nio.file.Files.move(Files.java:1395)

        at oracle.bi.servicelcm_v2.internal.bar.BarImportExport.exportBar(BarImp

ortExport.java:91)

        at oracle.bi.servicelcm_v2.operations.DefaultAnalyticApplicationOperatio

ns.exportBar(DefaultAnalyticApplicationOperations.java:160)

        ... 3 more

"

The D:\TMP folder is completely empty, but still I am getting error that the file exists.

Please suggest.

Also, while running this command, it is prompting me for RPD Password. How can I automate this process as I am trying to create a automated backup script to be executed daily?

Please help me with above 2 questions.

Many Thanks in advance.

Answers

  • BenFreez
    BenFreez Rank 5 - Community Champion

    Hi SonPat99,

    Did you tried to put the name of your Bar file in the command like this one : ./export_service_instance.sh ssi /u03/exportDir/obiee12c-Sample-with-RPD.bar

    (Sorry i am using this one un Linux)

    Best regards,

    Ben

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Hello Ben,

    Yes, your suggestion worked for me.

    Can you also help me with some suggestions on how to automate this process?

    Currently, this script asks for Repository Password to be given and that too TWICE. Is there any parameter or option to be hardcoded in the script, using which I do not have to provide password for RPD?

  • BenFreez
    BenFreez Rank 5 - Community Champion

    Hi SonPat99,

    Good question ! i didn't tried to automated this process. I am also interested by this kind of process. I will check and come back to you i am finding something

    Ben

  • SJenkins
    SJenkins Rank 3 - Community Apprentice

    any update on the automation question... I have an SR open trying to get the same question answered..

    the old wlst scripts use to allow you to enter a password. but the new script only prompts..

  • User_3S49I
    User_3S49I Rank 2 - Community Beginner

    y how to import the bar ?

  • SJenkins
    SJenkins Rank 3 - Community Apprentice
    edited Jun 29, 2023 4:43PM

    set ORACLE_HOME=d:\middleware

    set BI_PRODUCT_HOME=d:\middleware\bi

    set PRODUCT_HOME=d:\middleware\bi


    EXPORTING: 

    set DOMAIN_HOME=d:\middleware\user_projects\domains\bi

    echo ***password***|d:\middleware\user_projects\domains\bi\bitools\bin\export_service_instance.cmd ssi e:\bar_backups\obiee\obiee_ssi.bar


    IMPORTING :

    (Do not use import_service_instance.cmd - it will not import Application Roles)


    set DOMAIN_HOME=d:\middleware\user_projects\domains\bi

    d:\middleware\user_projects\domains\bi\bitools\bin\importarchive.cmd ssi e:\bar_backups\obiee\obiee_ssi.bar encryptionpassword=**password**


    USAGE : <service instance key> <location of bar file to import> [nodatamodel] [nocontent] [noauthorization] [nodatasets] [nosearch] [noaction] [encryptionpassword=<encryption password for connections>]

     Description     : Import bar as a service instance

     Mandatory Arguments : service instance key and location of bar file

     Optional Arguments : exclude list of values:nodatamodel nocontent noauthorization nodatasets nosearch

         nodatamodel    : Do not import RPD metadata content

         nocontent     : Do not import WEBCAT metadata content

         noauthorization  : Do not import JAZN metadata content

         nodatasets     : Do not import DSS metadata content

         nosearch      : Do not import Search metadata content

         noaction      : Do not import Action metadata content

         encryptionpassword : Encryption password for connections if any

    note:

    ===================================================================================

    12.2.1.4 bug: D:\Middleware\bi\modules\oracle.bi.servicelcm\scripts\

    export_service_instance.cmd

    import_bar.cmd

    both files need this parameter added or BAR file export/import will fail:

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

    ===================================================================================

  • User_3S49I
    User_3S49I Rank 2 - Community Beginner

    I just applied it and it worked, Thank you very much @SJenkins, I have one last doubt, in case of a Cluster, I only execute the command on one node or both

  • SJenkins
    SJenkins Rank 3 - Community Apprentice

    I would think everything in the cluster would be the same, so you would only need one backup.. but I dont run a cluster.