✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com


Sunday, 16 February 2014

View Display Error in OBIEE 11g

By on February 16, 2014

ODBC driver returned an error (SQLExecDirectW)
So many times we may face this error. 

It’s because of the down services of database in the database installed machine.

Click on Error details to view the type of error.

So the error throws the TNS: No listener

Error Codes.
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: 12541, message: ORA-12541: TNS:no listener at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)

Go to the location of Database installed drive or Client.
<drive>\app\***\product\11.2.0\client _1\network\admin

Check the tsnnames.ora file and its entries.

Check the names which you connected to the database.

Go to command prompt, use the command “tnsping Gan”, and check the status of the database connection.
So the database not connecting the error shows TNS: has no listener.
Check with the database installed machine whether the services got down restart the services and refresh the BI.

Automatically it will get up and the reports will get display.

mkashu: View Display Error in OBIEE 11g
Review : Kashif | Kashif
Update: February 16, 2014 | Rating: 4.5

Comment for "View Display Error in OBIEE 11g"


Blog Archive