ISSUE/ERROR:
While generating result for a simple analysis in OBIEE getting below error when clicked on result tab :
While generating result for a simple analysis in OBIEE getting below error when clicked on result tab :
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: 17001] Oracle Error code: 12154, message: ORA-12154:
TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach.
[nQSError: 17014] Could not connect to Oracle database. (HY000)
SOLUTION:
This error indicate that when OBI reports/servers
tries to connect to database something not working/appropraite at
client(browser/BI server) and DB connectivity level. In OBIEE (an other apps
too) it could primarily due to below reasons:
1.) At rpd level there is incorrect details of Data Source Name (DSN) in your connection pool configuration. Make sure it matches to what you have in your tnsnames.ora file
2.) At rpd
details of Data Source Name (DSN) is correct but in tnsnames.ora file DSN
details are not correct. Make sure it matches to what you have in your
tnsnames.ora file
3.) Possibly you
have multiple tnsnames.ora on the machine server names. (OBIEE usees
tnsnames.ora file present at <FMW_HOME>\Oracle_BI1\network\admin for
example C:\app\Manish\product\11.2.0\OBIEE11.1.1.6.0\Oracle_BI1\network\admin
In my case its was scenario-3 for the issue. Below are the steps I followed to resolve the issue.
1.) log in to the server
2.) go to the directory where the tnsnames.ora file
is located
cd $FMW_HOME/Oracle_BI/network/admin
3.) create a copy of tnsnames.ora
cp tnsnames.ora tnsnames.ora[_orig_date]
4.) edit the tnsnames.ora file and add the entr for your DSN name. Save and Exit.
5.) Restart all the bI services to pick the latest tns/dsn entries.
