nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Export Service Instance in OBIEE 12.2.1.4

SonPat99

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 \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: \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: \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: \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: \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 \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.

Find more posts tagged with

Accepted answers

All comments

BenFreez

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

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

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

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

y how to import the bar ?

SJenkins

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

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

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