OBIEE 12.2.1.4 RPD upload/download results in error — Oracle Analytics

Oracle Analytics Cloud and Server

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

OBIEE 12.2.1.4 RPD upload/download results in error

Received Response
315
Views
7
Comments
neeraj bisht
neeraj bisht Rank 3 - Community Apprentice

Hi All,

we have recently upgraded from obiee 12.2.1.0 to 12.2.1.4, the upgrade was successful and did not give any result and after upgrade services are also starting properly but i am unable to upload/download the new rpd successfully,

the logs result in error, looks like getCustomizationSessionFromLocalOBIS: localNodeHostName info ------->ucxtacn01:null does not result in correct port (9514) because of which obiee is unable to create the new rpd in upload rpd command.

can anyone share some thoughts or if you faced the same issue.

----upload results in below error

Jul 13,2018 10:08:35 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - uploadRpd: uploadBinRpd called for: ssi

Jul 13,2018 10:08:35 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - instance: domainHome: /u01/oracle/config/domains/BIDomain

Jul 13,2018 10:08:35 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - instance: biHome: /u01/oracle/product/fmw/bi

Jul 13,2018 10:08:35 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - instance: oracleHome: /u01/oracle/product/fmw

Jul 13,2018 10:08:35 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - instance: OBICCS obi01-priv:9508(9508)

Jul 13,2018 10:08:35 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - instance: Local Node Host Name-->ucxtacn01

Jul 13,2018 10:08:35 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - instance: Local Node Host address -->10.144.16.25

Jul 13,2018 10:08:35 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - instance: Obis hosts List----->obi01-priv

Jul 13,2018 10:08:35 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - Try to find /u01/oracle/config/domains/BIDomain/config/fmwconfig/bienv/core/biserver.txt to get local BI server name

Jul 13,2018 10:08:35 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - Found obi01-priv in line -- 192.168.11.150 obi01-priv

Jul 13,2018 10:08:35 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - instance: OBIS instance obis1 - obi01-priv:9514(9514)

Jul 13,2018 10:08:35 oracle.bi.lcm.pojo.si.rpd.RpdHelper SEVERE - instance: Could not retrieve BIANALYTICSWS instance information.

Jul 13,2018 10:08:36 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - Plain connection to BI Server failed, trying SSL...

Jul 13,2018 10:10:06 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - isBiServerSslRequired: SSL connection to BI Server failed.

Jul 13,2018 10:10:06 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - uploadRpd: call RpdEndPointV1.tryRpdLock to acquire ReentrantLock lock

Jul 13,2018 10:10:06 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - acquire RPD_LOCK

Jul 13,2018 10:10:06 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - Put the si-specific rpd(ReentrantLock) lock to RPD_LOCK_MAP for the service instance: ssi

Jul 13,2018 10:10:06 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - acquire si-specific rpd(ReentrantLock) lock for the service instance: ssi

Jul 13,2018 10:10:06 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - unlock RPD_LOCK

Jul 13,2018 10:10:06 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - uploadRpd: Using tmp directory: /u01/oracle/config/domains/BIDomain/config/fmwconfig/servers/bi_server1/tmp/lcmrpd/temp-ssi-rpd198684271158103132

Jul 13,2018 10:10:06 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - uploadRpd: Received RPD file successfully, file-length: 28760, path: /u01/oracle/config/domains/BIDomain/config/fmwconfig/servers/bi_server1/tmp/lcmrpd/temp-ssi-rpd198684271158103132/uploaded.rpd

Jul 13,2018 10:10:06 oracle.bi.lcm.pojo.si.rpd.RpdManager INFO - installNewRpdFullParams is called

Jul 13,2018 10:10:06 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - getCustomizationSessionFromLocalOBIS: getCustomizationSessionFromLocalOBIS is called

Jul 13,2018 10:10:06 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - getCustomizationSessionFromLocalOBIS: localNodeHostName info ------->ucxtacn01:null

Jul 13,2018 10:10:06 oracle.bi.lcm.pojo.si.rpd.RpdManager INFO - Exception installing new RPD: null

Jul 13,2018 10:10:06 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 SEVERE - uploadRpd: Exception during RPD file upload: null

Jul 13,2018 10:10:06 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - uploadRpd: unlock the ReentrantLock lock for the service instance: ssi

Jul 13,2018 10:12:29 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO -

----download results in below error

Jul 13,2018 10:12:29 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - downloadRpd called for: ssi

Jul 13,2018 10:12:29 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - call RpdEndPointV1.tryRpdLock to acquire ReentrantLock lock

Jul 13,2018 10:12:29 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - acquire RPD_LOCK

Jul 13,2018 10:12:29 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - acquire si-specific rpd(ReentrantLock) lock for the service instance: ssi

Jul 13,2018 10:12:29 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - unlock RPD_LOCK

Jul 13,2018 10:12:29 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - Using tmp directory: /u01/oracle/config/domains/BIDomain/config/fmwconfig/servers/bi_server1/tmp/lcmrpd/temp-ssi-rpd7405915984064886916

Jul 13,2018 10:12:29 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - getCustomizationSessionFromLocalOBIS: getCustomizationSessionFromLocalOBIS is called

Jul 13,2018 10:12:29 oracle.bi.lcm.pojo.si.rpd.RpdHelper INFO - getCustomizationSessionFromLocalOBIS: localNodeHostName info ------->ucxtacn01:null

Jul 13,2018 10:12:29 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 SEVERE - Exception preparing RPD file for download: null

Jul 13,2018 10:12:29 oracle.bi.lcm.rest.si.rpd.RpdEndpointV1 INFO - unlock the ReentrantLock lock for the service instance: ssi

Answers

  • neeraj bisht
    neeraj bisht Rank 3 - Community Apprentice

    can anyone provide any suggestions ?

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Which command are you using for uploading your RPD?

  • 842395
    842395 Rank 3 - Community Apprentice

    please handshaking port:9514

  • neeraj bisht
    neeraj bisht Rank 3 - Community Apprentice

    Hi Micheal,

    I am using below command for uploading the rpd ./datamodel.sh  uploadrpd -I /tmp/SPC.rpd -SI ssi -U weblogic_bi -P <weblogic password> and then after prompt giving RPD password

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    I don't see any issues with the command. Used the same on 12.2.1.4 environment and uploaded successfully.

    Did you try remote from Windows machine to see if other logging is created?

  • neeraj bisht
    neeraj bisht Rank 3 - Community Apprentice

    Hi,

    the upgrade also worked for me on windows laptop from 12.2.1.0 to 12.2.1.4 and was able to download and upload successfully but it doesn't seems to work on Linux machine where dev, prod etc servers are there,

    does obiee need both hosts and biinstance to be the same name as in our case, biinstance is different because of hosts file

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Hello,

    Can you please check the OBIS log to see if it contains the error details as well?

    Please check other logs as well.