Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OAS 7.0 - unable to download RPD

Accepted answer
607
Views
27
Comments
Matej D.
Matej D. Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Hi,

We migrated OAS 6.4 to OAS 7.0 (OAS 6.4 from OCI marketplace, customer-managed server).

Since then we can not download RDP on the server with datamodel.sh command.

Error is:

Error - both Trust Store (TS) and Trust Store Password (TSP) values must be passed if using custom certificates.

Any help?

Tnx and Regards

M.

Best Answers

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach
    edited Jul 16, 2024 10:39AM Answer ✓

    Hello Matej

    Have you tried the solution provided here?

    https://support.oracle.com/epmos/faces/DocContentDisplay?id=2934651.1

  • SteveF-Oracle
    SteveF-Oracle Mod
    edited Jul 17, 2024 10:01PM Answer ✓

    Bi server is not configured for SSL:


    ssl_report.txt

    Internal SSL enabled

    with demo certs



    So, @Christian Berg -Oracle comment is applicable.

    @Mostafa Morsy-Oracle - Thanks for requesting that.

    Is there a specific reason, or document you are following, to have internal SSL enabled, and external Weblogic SSL not enabled.?

    Recommend, you disable internalSSL and test gain

«13

Answers

  • Matej D.
    Matej D. Rank 3 - Community Apprentice

    Hi Christian,

    tnx for help.

    Bi server is not configured for SSL:

    bi_server1.png

    Inside datamodel.sh script is:
    WL_HOME is set by commEnv.sh above

    TRUST_STORE="$WL_HOME/server/lib/DemoTrust.jks"
    TRUST_STORE_PW="DemoTrustKeyStorePassPhrase"

    Output is from the running script:

    /u01/app/Oracle/oas/7.0/oas_home/wlserver/server/lib/DemoTrust.jks
    DemoTrustKeyStorePassPhrase

    I don't why a script is forcing an SSL connection.

    Regards

  • Gianni Ceresa
    Gianni Ceresa Mod

    @Matej D. ,

    What command are you using exactly? (replace passwords and other sensible info with fake values before posting it)

    And you are running the command from the OAS 7.0 server itself? That is an OAS 7.0 you created using the Oracle Analytics Server available in the OCI Marketplace and you didn't change anything else than the required parameter when setting it up?

  • Matej D.
    Matej D. Rank 3 - Community Apprentice

    Hi Gianni,

    this is the command:

    ./datamodel.sh downloadrpd -O /tmpd/Porduct_15072024.rpd -W xxx-U admin -P xxxx -SI ssi

    The first setup for OAS was for version 6.4 and then we made the upgrade to 7.0.

    The command is run from the OAS 7.0 itself.

    Regards

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    Echoing Gianni's question: Is this happening on a vanilla OAS 7.0 marketplace image?

  • Matej D.
    Matej D. Rank 3 - Community Apprentice

    No, the first setup from OCI marketplace was for 6.4 version, then we manually upgraded to 7.0

  • TetyanaH-Oracle
    TetyanaH-Oracle Rank 4 - Community Specialist

    Hi Matej,

    Please make sure your OAS 7.0 is fully patched as per document : Critical Patch Update (CPU) Advisor For Oracle Analytics Server and Oracle Business Intelligence - Updated for April 2024 (Doc ID 2832967.2)

    After that, please re-test datamodel.sh command.

    In addition, please check if internal SSL is enabled:

    ./ssl.sh internalssl status

    Regards

  • TetyanaH-Oracle
    TetyanaH-Oracle Rank 4 - Community Specialist

    Hi Matej,

    Please make sure your OAS 7.0 is fully patched as per document: Critical Patch Update (CPU) Advisor For Oracle Analytics Server and Oracle Business Intelligence - Updated for April 2024 (Doc ID 2832967.2)

    After that, please re-test if you can download your RPD.

    Also, please check if internal SSL is enabled:

    ./ssl.sh internalssl status

    Regards

  • Matej D.
    Matej D. Rank 3 - Community Apprentice

    Hi,

    after modifying the logging.properties file in $MW_HOME//bi/modules/oracle.bi.commandline.tools/scripts for datamodel.sh command I get this:

    2024-07-17 11:25:05:520 INFO : LOG_INIT_ENDPOINT_MGR
    2024-07-17 11:25:05:548 INFO : SSL facilities not available since bi-ssl jar not included
    2024-07-17 11:25:05:549 INFO : SSL facilities not available since bi-ssl jar not included
    2024-07-17 11:25:05:628 INFO : Optional file /u01/data/domains/bi/config/fmwconfig/bienv/core/endpoint.properties not present
    2024-07-17 11:25:06:112 INFO : LOG_GET_OBIS_ENDPOINT
    2024-07-17 11:25:06:149 INFO : Received endpoint: OBIS.obis1 tcp(s)://xxxxxx:9514(9514)/ - System Component
    2024-07-17 11:25:06:149 INFO : LOG_GET_BI_LCM_REST_ENDPOINT
    2024-07-17 11:25:06:150 INFO : Received endpoint: BI-LCM-REST.bi_server1 https://xxxxxx:9505/bi-lcm/ - custom channel bi_internal_channel1
    2024-07-17 11:25:06:151 INFO : LOG_GET_CSS_REST_ENDPOINT
    2024-07-17 11:25:06:151 INFO : Received endpoint: BICSS_REST_SERVICE.bi_server1 https://xxxxxx:9505/bi-contentstorage/api - custom channel bi_internal_channel1
    2024-07-17 11:25:06:151 INFO : domain.home: /u01/data/domains/bi
    2024-07-17 11:25:06:151 INFO : oracle.bitools.bin: null
    2024-07-17 11:25:06:152 INFO : LOG_DOWNLOAD_RPD_COMMAND
    2024-07-17 11:25:06:289 INFO : Using TLS: true
    Error - both Trust Store (TS) and Trust Store Password (TSP) values must be passed if using custom certificates.
    Operation failed.

    For some reason, the script is using TLS.

    Regards

  • Gianni Ceresa
    Gianni Ceresa Mod

    Did you try by adding the host and port parameters?

    Without those, on the server, the script tries to find the info from some other file, if you define them when calling the script, you maybe avoid the script trying to be "too smart".