Coonect Oracle Admin Tool to OAC error

mchorazy

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:

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 '!'

Joel

Did you follow these instructions?

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

mchorazy

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

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

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.