OBIEE Answers not showing results.
Hi experts,
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.