Unable to view data on OAS — Oracle Analytics

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 view data on OAS

Received Response
11
Views
1
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead
edited Aug 13, 2024 5:19PM in Oracle Analytics Cloud and Server

Hi I installed OAS on Linux and also client Tools.

i connected the admin tool with the server via ODBC and this is ok.

I use ADW as data source and i set connection to  import tables etc.

When i click View data i can see data , but when i publish it on server and open RPD online i cant see data anymore when i ho on table--> View data. I am getting message

pastedImage_0.png

i set tnsnames.ora and sqlnet.ora on my linux machine on all paths i thought was neccesary

[DOMAIN_HOME]/config/fmwconfig/bienv/core

[DOMAIN_HOME]/bidata/components/core/serviceinstances/ssi/oracledb

I also placed wallet filesystem

My TNS_ADMIN looks on [DOMAIN_HOME]/bidata/components/core/serviceinstances/ssi/oracledb

But when i open RPD online i can import new tables, so OAS sees the database but I cant retrieve data from it

This happens in OAS analytics when i try to see data

pastedImage_1.png

I am becoming desperate at this point, so plese help.

Answers

  • Francesco Gregori
    Francesco Gregori Rank 1 - Community Starter

    Hi

    I'm connecting to ADW with OAS and I'm not facing your issue

    • sqlnet.ora and tnsnames.ora in [DOMAIN_HOME]/bidata/components/core/serviceinstances/ssi/oracledb
    • wallet folder in [DOMAIN_HOME]/bidata/components/core/serviceinstances/ssi/oracledb/wallets/client
    • nothing in [DOMAIN_HOME]/config/fmwconfig/bienv/core

    Did you include WALLET_LOCATION in sqlnet.ora?

    regards

    Francesco