Troubleshoot Issues with Model Administration Tool (Oracle Analytics Client Tools)

Here’s some tips on how to troubleshoot issues when you try to connect to Oracle Analytics Cloud from Model Administration Tool. The Model Administration Tool is available with the Oracle Analytics Client Tools download.

Access these log files on your client machine:

  • BI_client_domain home\domains\bi\servers\obis1\logs\user_name_NQSAdminTool.log

  • BI_client_domain_home\domains\bi\clients\datamodel\logs\datamodel.log

This table describes some common connection issues and how you can resolve them.

Common Connection Issues Cause and Resolution

401: Unauthorized OR Authentication failure

The login credentials are invalid.

  • Make sure the user account exists.

  • Make sure you spelled the user name and password correctly.

  • Make sure the password doesn't contain an exclamation mark (!)

  • Make sure the user has the BI Service Administrator application role.

Error initializing TLS secure connection or Proxy exception: java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: SunJSSE, class: sun.security.ssl.SSLContextImpl$DefaultSSLContext)

OR

Error initializing TLS secure connection or Proxy exception: Remote host closed connection during handshake

This issue has multiple causes:

  • The connection points to a file which is not trust/key store.

  • The connection points to a trust/key store that doesn’t contain a certificate that can be used to verify the server certificate.

  • The trust store password is incorrect.

Use the default JDK key store located in: BI_client_domain_home\oracle_common\jdk\jre\lib\security\cacerts.

Connection failed, the server processes may be down, the host name, port number, service instance, or protocol (http/https) may be incorrect

This issue has multiple causes:

  • Make sure you’ve specified the correct host name and port number. See Connect to a Semantic Model in the Cloud.

  • If the datamodel.log file reports Connection timed out, check whether the machine where you installed Oracle Analytics Client Tools is in a proxy-enabled network. If it is, ask your network administrator for the proxy server and port, and specify these when you connect to your semantic model.

  • If you can’t diagnose a connection issue using the client side log files and Oracle Analytics Cloud is deployed in a customer-managed environment, check server side log files bi-lcm-rest.log.0 and bi_server1.out.

    For example, if the database user doesn’t have the BI Service Administrator application role, the bi_server1.out. file shows an error similar to:

    oracle.bi.restkit.security.auth.RequiredGroupAuthoriser> <BEA-000000> <Failed authorisation for user: weblogic>
I can't use Model Administration Tool in SSL mode

If the default security certificates don't work, import the server security certificates. For example, on the machine where you downloaded and installed Oracle Analytics Client Tools, you might use the Key and Certificate Management Tool (keytool) to execute these commands:

C:\Oracle\Middleware\oracle_common\jdk\jre\bin\keytool.exe -importcert -alias oacserver -file
C:\Oracle\Middleware\oracle_common\jdk\jre\lib\security\server.crt -keystore
C:\Oracle\Middleware\oracle_common\jdk\jre\lib\security\cacerts -storepass
password