✍ Kashif M
Trends

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.
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: 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.

Kashif
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"

1 comments:

Blog Archive