RPD Upload Failed - OAS 2024 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

RPD Upload Failed - OAS 2024

Accepted answer
928
Views
24
Comments
userva
userva Rank 4 - Community Specialist

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

image.png

[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

Best Answer

  • 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.

«13

Answers

  • Shantaram-Oracle
    Shantaram-Oracle Rank 4 - Community Specialist

    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.

  • 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
    userva Rank 4 - Community Specialist

    @Shantaram-Oracle

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

  • userva
    userva Rank 4 - Community Specialist

    @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
    Mostafa Morsy-Oracle Rank 6 - Analytics Lead

    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
    userva Rank 4 - Community Specialist
    edited Apr 25, 2024 6:47PM

    @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

  • 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
    userva Rank 4 - Community Specialist
    edited Apr 25, 2024 7:14PM

    @SteveF-Oracle

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

  • userva
    userva Rank 4 - Community Specialist

    @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

  • 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