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

Coonect Oracle Admin Tool to OAC error

Received Response
81
Views
4
Comments
mchorazy
mchorazy Rank 4 - Community Specialist
edited Aug 13, 2024 5:19PM in Oracle Analytics Cloud and Server

Hi everyone,

I have OAC with link:  xxxbieedev-xxxcloud.analytics.ocp.oraclecloud.com

I have for my OAC the Identity Cloud Service

I have user with BI Administration Services.

Log in OAC working fine, I import my 'test' rpd like import .bar file in snapshot. It's working fine I see my all presenation area and whole model.

Next I want connect with Oracle Admin Tool.

I download on notebook: Oracle BI Administration Tool Version: 12.2.5.0.0

Open in the Cloud with parameters:

User: xxx.xxx@xxx.com --- with this login I log in OAC

Pass: password for this user

Cloud: bootstrap

Host name: xxxbieedev-xxxcloud.analytics.ocp.oraclecloud.com

Port number: 443

When I click Open I get error:

pastedImage_1.png

What I do wrong? Do I have to do anything extra on OAC or ICS?

In datamodel.log:

kwi 02,2020 18:45:37 oracle.bi.utils.BITools INFO - Initializing endpoint managerkwi 02,2020 18:45:37 oracle.bi.utils.BITools INFO - domain.home: C:\oracle\Middleware\Oracle_Home2\bi\bitools\bin\\..\..\..\domains\bikwi 02,2020 18:45:37 oracle.bi.utils.BITools INFO - oracle.bitools.bin: C:\oracle\Middleware\Oracle_Home2\bi\bitools\bin\kwi 02,2020 18:45:37 oracle.bi.utils.BITools INFO - downloadrpd command will be processedkwi 02,2020 18:45:37 oracle.bi.utils.BITools INFO - Using TLS: falsekwi 02,2020 18:45:37 oracle.bi.utils.BITools INFO - baseUri is: http://xxxbieedev-xxxcloud.analytics.ocp.oraclecloud.com:443/bi-lcm/v1/si/bootstrap/rpd/kwi 02,2020 18:45:38 oracle.bi.utils.BITools INFO - Post downloadrevision REST with url: http://xxxbieedev-xxxcloud.analytics.ocp.oraclecloud.com:443/bi-lcm/v1/si/bootstrap/rpd/downloadrevision

In NQSAdmintTool.log:

[2020-04-02T18:59:42.654+02:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: service1] [tid: 4ea8] C:\oracle\Middleware\Oracle_Home2\bi\bitools\bin\datamodel.cmd downloadrpd -O C:\oracle\Middleware\Oracle_Home2\bi\bifoundation\server\3C32.tmp -W ******* -U xxx.xxx@xxx.com -P ******* -Q C:\oracle\Middleware\Oracle_Home2\bi\bifoundation\server\3C33.tmp -SI bootstrap -S xxxbieedev-xxxcloud.analytics.ocp.oraclecloud.com -N 443 -Y

ps. my password do not have '!'

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Did you follow these instructions?

    https://support.oracle.com/knowledge/Oracle%20Cloud/2432176_1.html

  • mchorazy
    mchorazy Rank 4 - Community Specialist

    Thanks for response.

    I think that yes, but this is my first steps in OAC.

    I downloaded Oracle Analytics Client Tools 18.3.3

    I set parameters with my data:

    Launch the Oracle BI Administration Tool

    Choose File > Open > In the Cloud

    Define the parameters for your OAAC instance:

    Username : <OAAC Admin username>

    Password : <password>

    Cloud : bootstrap ( This is the name of the Service Instance in your OAAC VM - default value is bootstrap)

    Host Name : <OAAC Host name>

    For example:

    If you access your OAAC service instance via https://myoaacinstance-myidentitydomain.analytics.ocp.oraclecloud.com/dv/ui then the Host Name would be myoaacinstance-myidentitydomain.analytics.ocp.oraclecloud.com

    Port Number : 443

    And next i get this 'bad request' error.

  • mchorazy
    mchorazy Rank 4 - Community Specialist

    I set parameters with SSL (cacerts) and it's working.

    Why when I used parameters without SSL I get bad request, but when I add SSL (cacerts) it's working?

  • Joel
    Joel Rank 8 - Analytics Strategist

    You need to point the OAC connection to a local truststore which is used as part of the authentication process between your client and the OAC server.