OBIEE 12c remote repository download/upload


One of the most interesting features of OBIEE 12c is an ability to download/upload a repository with command-line utility without using OEM and the best part of all: without restarting of an Analytics server! But when I tried to use it and upload a repository from my developer workstation to a server, I've faced two issues.

Disclaimer. This post is a result of my personal investigation. It's neither documented nor supported by Oracle. Following this guide is on your own responsibility.
Update Dec 12, 2015 This is now documented: 1.2.4 Error When Running data-model-cmd.cmd Launcher Script. The bug 22095286 BI-LCM TOOLS NOT WORKING FROM CLIENT INSTALLATION will be fixed in 12.2.3 (My Oracle Support).

The first issue was that the data-model-cmd.cmd script wasn't where I've been expected to find it. I thought that it should be in the C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin folder by analogy with Linux installation. There is a script in the analogous directory on Linux server. It's pretty small and does two things: defines the DOMAIN_HOME environment variable and calls $ORACLE_HOME/bi/modules/oracle.bi.commandlinetools/scripts/data-model-cmd.cmd script. But it wasn't there. I found only a script in the %ORACLE_HOME%\bi\modules\oracle.bi.commandlinetools\scripts folder.

I tried to call the script I've found with -H (help) flag...

..and got an error:



Error text for google users
Exception in thread "main" java.lang.NoClassDefFoundError: oracle/bi/lcm/metadata/MetadataUpdateException
at oracle.bi.utils.BIExec.main(BIExec.java:25) Caused by: java.lang.ClassNotFoundException: oracle.bi.lcm.metadata.MetadataUpdateException
at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) ... 1 more

Hm, "java.lang.ClassNotFoundException" it looks like something is missing. Take a look at this script text: "bi-blocking-metadata-update.jar" and "bi-customization-utils.jar" are supposed to be in the !BICLIENTHOME!\lib folder.

But they are not there.

The good news is that I have a server installation with these jars (I wouldn't need all this if I haven't had one :) ).

These are the jars we are looking for.

I copied them into ORACLE_HOME\bi\lib folder of my Windows (Windows 10 by the way) machine.

Help command works well. It shows commands we can use.

Command name with an -H flag shows help for the command.

Sample for download a repository from my server.

A few seconds and a repository file is on my Windows machine. Now I can edit it in on offline mode as usual.

And I can upload it to a server. Without OEM. Without restarting a server.

Disclaimer. This post is a result of my personal investigation. It's neither documented nor supported by Oracle. Following this guide is on your own responsibility.

troubleshooting obiee 12c


Andrew Fomin Profile Picture
Andrew Fomin

OBIEE specialist since 2007 and Oracle Discoverer before. DWH architect, BI enthusiast, blogger. Lazy cats owner. All opinions are my own and not the views of my employer.


Additional Posts
Share This Post
Twitter Google+ Pinterest Facebook
comments powered by HyperComments