Client has installed obiee 11g in a server sitting at different place. We have deployed our own repository and catalog. Now we can't login to obiee analytics. It does not accept any username or password created in weblogic console. But if we deploy oracle's default SampleSales repository, then we could login. Can't understand what's the problem!
It's throwing the following error:
[OBIPS] [ERROR:31]  [saw.security.odbcuserpopulationimpl.searchidentities] [ecid: 004tnN1tfkXFw0XpLs_Aie0004ds000000,0:162] [tid: 3327710976] Error retrieving user/group data from Oracle BI Server's User Population API.
Unable to create a system user connection to BI Server while running user population queries
Odbc driver returned an error (SQLDriverConnectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (aaobiee.mm.co.za) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
Please help how do I resolve!!
nqsserver.log file says:
[2013-09-25T21:53:42.000+02:00] [OracleBIServerComponent] [ERROR:1]   [ecid: 004tn^TjyltFw0XpLs_Aie0002MT000000] [tid: ce942700] [nQSError: 17010] SQL statement preparation failed. [[
[nQSError: 17001] Oracle Error code: 936, message: ORA-00936: missing expression
at OCI call OCIStmtExecute.
also i can't tnsping the data source name and it looks incorrect to me!
I can't view any data offline. when i do update row count, it complains. can't even ping the data source name they have given. when i did a tnsping it fails.
But how does it blocks my login to analytics? i guess, it must give my report view display error once logged in and not finding the data source name. now i cant login even which is wired!!
do this in your DSN field for the connection pool add this hostname:port/ServiceName or use this (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =ora11g))) and then try to update the rowcount or view results for tables if its success then restart the entire opmnctl components and see if it allows you to login or not
This is the exact format how my tnsnames.ora file looks. sorry, I can ping it in command prompt now. In my connection pool i tried first DSN = ab.bc.xy.zx, did not work. Then I saw oracle's default repository and changed my DSN to your suggested format starting from "DESCRPTION" to rest. Still no luck Do you think, i should put the same TNS in my local machine??
#(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.30.110)(PORT = 1521))
#(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.30.120)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.30.130)(PORT = 1521))
(LOAD_BALANCE = yes)
(SERVER = DEDICATED)
(SID = cap2)
I am looking offline coz i cant connect online to the server sitting at another country. very slow. I will put now.
Could you please write here the syntax you have suggested based on my tnsnames i have given. Just want to double check and make sure i am giving correctly.