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

unable to add connection

Received Response
41
Views
3
Comments
Muriel Fry
Muriel Fry Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

unable to add connection

Content

Hello,

I used to work with May 2016 version and everything was OK (Since 2 months did not used DVD)

This morning, before to work, i upgraded my DVD to Version 12.2.2.1.1-20161222001521 (Dec. 2016)

Since I am unable to connect to Oracle database.

I just have :

"Failed to save the connection"

msg when i try to save

[2017-02-10T12:29:40.113+01:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 2f60] call NQSExternalVerifyConnection( '<?xml version="1.0" encoding="UTF-8" standalone="no"?><cm:dsConnMetadata xmlns:cm="com.oracle.bi/ConnMetadata/v1"><cm:dsMetadata><cm:cliName>OCI 10g/11g</cm:cliName><cm:targetName>Oracle 11g</cm:targetName><cm:providerName>oracle</cm:providerName></cm:dsMetadata><cm:dsSignon><cm:dsn>192.168.1.36:1521/orcl</cm:dsn><cm:host>192.168.1.36</cm:host><cm:port>1521</cm:port><cm:serviceName>orcl</cm:serviceName><cm:userName>scott</cm:userName><cm:password>XXXXXX</cm:password><cm:driverClass>oracle.bi.jdbc.AnaJdbcDriver</cm:driverClass></cm:dsSignon><cm:enablePooling>false</cm:enablePooling><cm:dsConnPoolParams><cm:maxConnections>100</cm:maxConnections><cm:timeOut>600</cm:timeOut></cm:dsConnPoolParams></cm:dsConnMetadata>' )

[2017-02-10T12:29:40.243+01:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 2f60]  [16020] Metadata Database Type:  [[

Data Source Name: 192.168.1.36:1521/orcl

Data Source Type: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64b

]]

[2017-02-10T12:33:50.902+01:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 3cc] LCMAPIsUtil.DoesSIMetadataNeedRefresh-> called with token 2015-09-24T11:17:41.654-05:00 : False

-- no error msg in diagnostic.log

easy connect string is OK

D:\instantclient_11_2>sqlplus scott/xxxxx@//192.168.1.36:1521/orcl

SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 10 12:36:12 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL>

Attaching jetty log in which i can see WARNING and SEVERE but have no idea what i can do

Any ideas are welcome

Muriel

Answers

  • Muriel Fry
    Muriel Fry Rank 3 - Community Apprentice

    Finally found :

    As soon as I remove Env variable CLASSPATH, i was able to save

  • Smriti Koul
    Smriti Koul Rank 4 - Community Specialist

    Hi where did you change the CLASSPATH ?

    please share, I am having a same issue when connecting to Essbase(beta).

    thanks and regards,

    Smriti

  • Muriel Fry
    Muriel Fry Rank 3 - Community Apprentice

    Hi,

    Apologize, I did not see your update.

    I had it in my Windows Env

    Computer -> Properties -> Advanced system settings

    Button Environment Variables

    I don't remember if that was a User VAriables or System Variable

    I just removed the line and everything was OK

    Now I set CLASSPATH to compile java

    Hope this is not too late

    Muriel