Tag Archives: NQSERROR
TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach
When you get the error message (“TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach”)
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: 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)
the Data Source Name that is used in the connectionpool of the physical database that is used to show the report, is not found in the tnsnames.ora file.
This is how you can fix it;
- log in to the server
- go to the directory where the tnsnames.ora file is located
-
cd $FMW_HOME/Oracle_BI/network/admin
- create a copy of tnsnames.ora
-
cp tnsnames.ora tnsnames.ora[_orig]
- edit the file, for example with vi-editor
-
vi tnsnames.ora
- insert the entry
- save the tnsnames.ora
-
:wq
The error message will not be displayed anymore.
Het bericht TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach verscheen eerst op OBIEE 24/7.
TNS:no listener at OCI call OCIServerAttach
When you get the error message (“TNS:no listener at OCI call OCIServerAttach”)
the Data Source Name that is used in the connectionpool of the physical database that is used to show the report, is not found in the tnsnames.ora file.
This is how you can fix it;
- log in to the server
- go to the directory where the tnsnames.ora file is located
-
cd $FMW_HOME/Oracle_BI/network/admin
- create a copy of tnsnames.ora
-
cp tnsnames.ora tnsnames.ora[_orig]
- edit the file, for example with vi-editor
-
vi tnsnames.ora
- insert the entry
- save the tnsnames.ora
-
:wq
The error message will not be displayed anymore.
Het bericht TNS:no listener at OCI call OCIServerAttach verscheen eerst op OBIEE 24/7.
An error occured while trying to check out objects from the server
When you try to check out an object while you have the repository open in “online” mode, and get this error message;
Then maybe this object is allready checked out in another session of the Administration Tool.
- go to the other session
- close that session
- go back to your first session
- check out the object
Het bericht An error occured while trying to check out objects from the server verscheen eerst op OBIEE 24/7.
Multiply is not permitted on VARBINARY, DOUBLE PRECISION operand(s)
When you get this message in OBIEE;
Then maybe you are trying to multiply with a value of a column that has a datatype that is different from “integer” or “number”.
A possible solution is to change the datatype of that column to “integer” or “number”.
Het bericht Multiply is not permitted on VARBINARY, DOUBLE PRECISION operand(s) verscheen eerst op OBIEE 24/7.
Table or view does not exist at OCI call – query failed
When you try to view data from a table in the Oracle BI Administration Tool and get this message;
Then maybe the user that is defined in the connection pool, doesn’t have the grant to select.
You can run this statement in SQL-plus or SQL developer;
- GRANT SELECT ON [TABLE] TO [USER];
(TABLE and USER have to be replaced).
Het bericht Table or view does not exist at OCI call – query failed verscheen eerst op OBIEE 24/7.
