Unable to view data on OAS

mmajdana1

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

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

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

Francesco Gregori

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