Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE 12c - uploading RPD

Russ ProudmanNov 17 2015 — edited Dec 6 2015

Hey there.

I have been working on this for days now and cannot get any success.

I understand the difference under 12c and what's required to upload an RPD, but the real question is:

"has anyone done this from Windows to Linux (ie: meta-data-cmd.cmd NOT meta-data-cmd.sh)

It seems to be overwhelming as I've had to copy bits of Java (classes), played with trusted store (SSL). I've read the manuals over and over and

so far, it simply doesn't work and I get error of: "connection error -1".

Has anyone, anywhere seen a blog, documentation, etc. that fully shows the process via Windows. It simply doesn't work for me so far and

there's nothing written about it so far.

Thanks.

Comments

Kishore Guggilla

what is the exact issue you're facing...

Russ Proudman

The issues never seem to end.

First of all there are Java classes that are not installed in the correct directory with the BI client tool that are in the Linux directories.

Then in the data-model-cmd.cmd script, you have to have extra parameters that are not required in the .sh version (because it's a client installation,

but, of course, if you're using the BI Admin Tool from Windows (ala v11.x) then that would always be a client installation).

Then it's not a trusted connection as it's a client installation so now you have to be running SSL in OBIEE as well (trusted store, key, etc.), etc.

Now I'm getting a useless message such as "connection error: -1", except the server, and the port are correct.

It's just an uphill battle.

Compare it to the data-model-cmd.sh script where it just works. Same parameters as I use in the .cmd script (well less required) and it worked first time.

Unfortunately I'm at a location where jumping on to the Linux box and running it from there are not possible.

So my original request is finding ANYONE who has successfully uploaded an RPD from the Windows client .cmd script and what they went through

'cause it's not obvious and has a number of 'unwritten' challenges.

Thanks.

Andrew Fomin.

Hi.

My client system is Windows 7 (tested on Win 10 also) and a server is on Oracle Linux 6.

The only issue I've faced was copying two jars from Linux to Windows. It looks like you've already done it. After that, everything works for me.

Here is my post about it: https://bisoftdiary.com/obiee12c_repository_upload

Russ Proudman

First of all, thanks for the reply.

For your server, is it on the Windows machine as well (ie: Linux running on the same laptop)?

Reason I'm asking is there seems to be extra fields needed when you're running the command from a client machine (Windows) to a server (Linux) and one of them I believe was a mandatory -SSL field.

So I'm just wondering if it's different if on the same box versus from a box to the same box (whether or not running VirtualBox, etc.)?

Thanks.

Andrew Fomin.

Pictures from my blog post were taken on the following configuration: VM #1: OBIEE 12c working on Oracle Linux 6. VM #2: OBIEE client on MS Windows 10. Both VMs work on the same host (Windows 10). But I tried the same procedure with a remote Linux server (Windows 7 - client, OEL 6 - remote server). Everything worked fine without -SSL key.

By the way, have you checked things like a firewall and Java version/bitness? Sometimes the easiest answer is the best one.

Frog Toad

Andrewif написал(а):

Here is my post about it: https://bisoftdiary.com/obiee12c_repository_upload

Andrewif, thousands ray goodness to you for this post

Andrew Fomin.
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details