OBIEE 12.2.1.2.0 Not being able to deploy or download RPD

Ed Chavez

Hi

I have both a Windows and Linux server and in both, after upgrading OBIEE to 12.2.1.2.0 from 12.2.1.0 we are no longer able to deploy nor download current RPD. The upgrade creates a new Oracle_Home with its own set of folders. I am unfamiliar with this new folder since I did not perform the upgrade myself. So now when executing this command:

Original_Oracle_Home/user_projects/domains/BIDOMAIN/bitools/bin/data-model-cmd.sh downloadrpd -O RPD_Name.rpd -W PasswordRPD -U userweblogic -P passwordweblogic -SI ssi

And I get:

Service Instance: ssi

Operation failed.

Service Instance key "ssi" does not exist.

But the service Instance Key has always being SSI and in fact I see in the log of Presentation Services referencing the service instance Key as ssi

Do any of you know what changed? Is the path wrong? both servers are giving me the same issue.

Gianni Ceresa

Hi,

If I get you right you are calling data-model-cmd.sh on your old OBIEE instance (12.2.1.0.0), right?

Why don't you call it using the command of the new updated one? (12.2.1.2.0)

The difference is that in 12.2.1.2.0 (maybe already in 12.2.1.1.0, can't remember) they renamed the script, it's now named datamodel.sh

So give it a try on the new updated instance and forget the old one...

Ed Chavez

Thanks for the answer... I found a new datamodel.sh but its usage seems to be different, is not allowing me to use the above command and I can't find any documentation for this.

\OracleBI12212\Middleware\Oracle_Home_12212\bi\modules\oracle.bi.commandline.tools\scripts\datamodel.cmd uploadrpd -I repository.rpd -SI bi -U weblogic -P weblogicpassword -W rpdpassword

And I get the following message:

usage: uploadrpd -I <RPD filename> [-W <RPD password>] [ -V enable validation of

rpd] [-D] [-KG <groups>] [-RG <groups>] -U <cred user> [-P <cred password>] [-S

I <service instance>] [-S <host>] [-N <port>] [-SSL]

Options for removing existing customization groups on the server:

-D                   : Remove all customization groups.

-D -KG group1,group2 : Remove all customization groups exception of group1 and g

roup2.

-D -RG group1,group2 : Remove group1 and group2 but keep all others.

what is wrong with my command?

Joel

Could you retry with the -D parameter.

Lamin J

Hi!

Is your service instance namne really-SI  bi or the default -SI ssi ?

Best regards LJ

Ed Chavez

oh, yes, it is ssi, but I used the example that the documentation is providing just for the sake of filling out the info, I actually executed the command with ssi

Ed Chavez

I tried but I get the same message, that I'm not using it correctly>

\OracleBI12212\Middleware\Oracle_Home_12212\bi\modules\oracle.bi.commandline.tools\scripts\datamodel.cmd uploadrpd -I repository.rpd -SI ssi -U weblogic -P somepassword -D

now, is the script path correct?

\OracleBI12212\Middleware\Oracle_Home_12212\bi\modules\oracle.bi.commandline.tools\

That is the path I found the only datamodel.cmd.

The old data-model-cmd.cmd does not work, gaves me the error I describe at the beginning of this post

Joel

Have you used this document as reference? As @Gianni Ceresa mentioned, the file has changed after the 1st 12c release. The file to use is datamodel.cmd. The documentation link I provided gives you information about the exact location of this file.

Ed Chavez

Ok, found the newest datamodel.cmd

However the upload command throws this error:

"DESC_CODE_SERVER_EXCEPTION"

and the download command simply gives me Services Instance Key ssi does not exists.

Crazy.

Venkata Rachuri

Try this

Ed Chavez

Thank you so much Sir...

One day I will learn the mysteries of reality, God existence or not, secrets of the universe and finally why Oracle does whatever it does.