Oracle Communities

Oracle Analytics and AI

Child Item

RPD Upload Failed - OAS 2024

Recently installed OAS 2024 and imported bar file from OBIEE 12.2.1.3. Import and restore was successful and now i am trying to download and upload rpd to OAS.

Downloaded using the below command: it worked as expected

datamodel downloadrpd -O D:\oracle\product\RPD\DEV_2_20240418.rpd -W xxxxxxxx -U weblogic -P xxxxxxxxx -SI ssi -S 99.99.99.99 -N 9502

Trying to upload above downloaded rpd using the below command: Not Working

datamodel uploadrpd -I D:\oracle\product\RPD\DEV_2_20240418.rpd -W xxxxxxxxx -U weblogic -P xxxxxxxx -SI ssi -S 99.99.99.99 -N 9502

Operation Failed.

An exception occurred during execution, please check server logs.

System exit code:1

Below is the log from the bi-lcm-rest.log file

[2024-04-22T17:19:43.627-04:00] [bi_server1] [ERROR] [] [oracle.bi.lcm.pojo.si.rpd.RpdManager] [tid: 176] [userId: weblogic] [ecid: 8be4b265-db11-4d9b-9176-ee273cc71629-000004c0,0] [APP: bi-lcm-rest] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] Exception installing new RPD: null
[2024-04-22T17:19:43.628-04:00] [bi_server1] [ERROR] [] [oracle.bi.lcm.rest.si.rpd.RpdEndpointV1] [tid: 176] [userId: weblogic] [ecid: 8be4b265-db11-4d9b-9176-ee273cc71629-000004c0,0] [APP: bi-lcm-rest] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] uploadRpd: Exception during RPD file upload: null

Find more posts tagged with

Accepted answers

Steve F-2

The files and DNS lookup, look OK, but the issue still matches.

Give this a test:

Create the file biserver.txt in [DOMAIN_HOME]/config/fmwconfig/bienv/core/
Edit the file and add only the hostname (that matches bienv-compoonents.xml — MADPAPPD01
Restart the services
Test the the datamodel.cmd uploadrp command again

If it fails, try the same steps with the FQDN

If that does not work, then please log a Service Request and have Support reproduce the issue with a Windows OAS 2024 server installation. This may potentially be a regression of an old issue, not sure.

All comments

Shantaram-Oracle

Please confirm that the RPD is downloaded successfully with the system exit code 0 and you are able to open it with the Admin tool and verify.

Steve F-2

Most of the time "null" has to do with hostname

java net api may be having some sort of hostname mismatch.

For the parameter -S 99.99.99.99 are you using an IP address, or the hostname?

If the hostname, does it match your /etc/hosts file? or nslookup results?
What about the bienv-compoonents.xml ?

userva

@Shantaram-Oracle

yes, i can open the downloaded rpd using the OAS Client tool

userva

@SteveF-Oracle

For the parameter -S 99.99.99.99 are you using an IP address, or the hostname? Yes, i have used both IP and hostname, same result.

below is the entry of hosts file

10.121.40.143 MADPAPPD01.XXXXX.NET MADPAPPD01

nslookup result:

nslookup 10.121.40.143

Name: madpappd01.xxxxx.net

Address: 10.121.40.143

I am not able to find any file named bienv-compoonents.xml

Mostafa Morsy-Oracle

Please remove -S key as long as you run the command from the OAS Server the comamnd as
datamodel uploadrpd -I D:\oracle\product\RPD\DEV_2_20240418.rpd -W xxxxxxxxx -U weblogic -P xxxxxxxx -SI ssi

userva

@Mostafa Morsy-Oracle

tried without -S on OAS Server, same result and same error log

[SI-Key: ssi] getCustomizationSessionFromLocalOBIS: localNodeHostName info ------->MADPAPPD01:null

[2024-04-25T14:39:43.627-04:00] [bi_server1] [ERROR] [] [oracle.bi.lcm.pojo.si.rpd.RpdManager] [tid: 176] [userId: weblogic] [ecid: 8be4b265-db11-4d9b-9176-ee273cc71629-000004c0,0] [APP: bi-lcm-rest] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] Exception installing new RPD: null

[2024-04-25T14:39:43.628-04:00] [bi_server1] [ERROR] [] [oracle.bi.lcm.rest.si.rpd.RpdEndpointV1] [tid: 176] [userId: weblogic] [ecid: 8be4b265-db11-4d9b-9176-ee273cc71629-000004c0,0] [APP: bi-lcm-rest] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] uploadRpd: Exception during RPD file upload: null

RajeshPolavarapu-Oracle

Hi @userva,

You can use lowercase s like "-s <hostname>" and also add -Y at the end and then try downloading..

like below -

datamodel.cmd downloadrpd -U weblogic -P Welcome1 -W Welcome1 -O D:\oracle\product\RPD\DEV_2_20240418.rpd -s <hostname_or_IP> -N 9502 -SI ssi -Y

Thanks.

userva

@SteveF-Oracle

found the bienv-compoonents.xml file u have asked for, please see attached.

bienv-components.xml

userva

@RajeshPolavarapu-Oracle

the download works fine for me, no issue. the only issue is during the upload.

tried below commands

datamodel uploadrpd -I D:\oracle\product\RPD\DEV_2_20240418.rpd -W xxxxxxxxx -U weblogic -P xxxxxxxx -SI ssi -S 10.121.40.143 -N 9502

datamodel uploadrpd -I D:\oracle\product\RPD\DEV_2_20240418.rpd -W xxxxxxxxx -U weblogic -P xxxxxxxx -SI ssi -S MADPAPPD01 -N 9502

datamodel uploadrpd -I D:\oracle\product\RPD\DEV_2_20240418.rpd -W xxxxxxxxx -U weblogic -P xxxxxxxx -SI ssi -S madpappd01 -N 9502

Steve F-2

Great memory @Mostafa Morsy-Oracle , I do remember now that was introduced in OAS 2022 time frame. If executing on the server, the host and port are queried from the endpoint manager, and not necessary. On a client installation, the switches are necessary.

We had a team update the following MOS Doc ID for clarity.

After upgrading to Oracle Analytics Server (OAS), datamodel.sh|.cmd 'uploadrpd' 'downloadrpd' Command Line Fail With Various Errors