OBIEE Answers not showing results

oracle oracle11g business-intelligence obiee
P.Nichols picture P.Nichols · Mar 4, 2013 · Viewed 36.2k times · Source

I recently installed OBIEE 11.1.1.6.0. I imported the repository I had from 11.1.1.5 which was working fine till now.

In the administration tool, I can query my data and update the rows, I can connect with the same credentials as the connection pool without problems in SQLPLUS.

Users have the RESOURCE and CONNECT privileges.

My weblogic user as all the privileges and has been granted read/write to my Subject area. I have set the environment variables, modified the instancesconfig.xml and tried all the things i could've found on the OTN but BI Answers continues to give me this ERROR

View Display Error

Odbc driver returned an error (SQLExecDirectW).

Error Details

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] 
[nQSError: 10058] A general error has occurred. 
[nQSError: 43113] Message returned from OBIS. 
[nQSError: 43119] Query Failed: 
[nQSError: 17001] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied at OCI call OCISessionBegin. 
[nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: SELECT 0 s_0, "SAP_AVIS"."Fait SAP AVIS"."Avis" s_1 FROM "SAP_AVIS" FETCH FIRST 65001 ROWS ONLY

Please help, I am desperate.

Answer

P.Nichols picture P.Nichols · Mar 6, 2013

I have been able to resolve my OCI ORA-01017 error.

The problem was caused by my connection pools.

I had a connection amed "A" to access tables in a certain schema in my DB and another connection named "B" this time to access tables in another schema but in the same DB.

In Oracle BI Answers (presentation), I was trying to view data whitin the connection B but strangely OBIEE Answers was using the connection A.

In the end I removed/renamed the connection A and everthing worked like nothing never happend.

I am not saying that this is the best method. Maybe i skipped a config that assigns the default connection pool to use but it did the job.

Related questions

How to change the date format in Oracle BI Publisher?

How do I change the format of the date while creating a report using data model which I created using a simple SQL query which fetches aggregated data from a data warehouse? I need the date in a simple dd-mon-yy …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?

Read More