This content has been marked as final. Show 30 replies
OBIEESERVER OFFICE (2:08 PM):
+[2013-04-14T14:05:52.000+04:00] [OBIPS] [ERROR:31] +
+[tid: 5960] 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
Odbc driver returned an error (SQLDriverConnectW).
+State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004]+
+[nQSError: 10018] Access for the requested connection is refused.+
+[nQSError: 43113] Message returned from OBIS.+
+[nQSError: 43126] Authentication failed: invalid user/password. (08004)[[+
What password you are using ?.. Admin123 ??.
Also confirm if there is any integration is being used like SSO,EBS-OBIEE integration,MSAD or OID etc.
One more thing Can you check RPD version by logging into EM-->Business Intelligence-->Capacity Management --> Deployed defalult RPD name
Or check it from NQsconfig.ini and try opening it in offline mode?..
Post your results.
Looks like BISystemUser is corrupted otherwise locked.
Follow these steps to reset the password for the BISystemUser.
1)Login to weblogic console -->Security reallms-->USer and groups -->BISystemUser -->Change the password or reset it to weblogic password.
2)You need to do the same in credential store as well.
login to em -->weblogic domain -->bifoundation_domain-->right click and locate credential store -->click on oracle.bi.system -->system.user -->Change the password or reset it to weblogic password
Ensure This password and password reset in the 1st step should match.
Restart BI services.Post your results after doing this.
Hi Sher ,
Did you get any luck on this issue?
Me also got struck at this moment.
Caould you please tel me how to trouble shoot this issue...
I tried many ways to resovle this issue....
ex:- NQS congilg file change - Parameter to YES
instance config file change - adding one more parameter as available in OTN Discuossin
Rpd deployments sevral time
Change the and retype the pwd's via EM and webcosnloe
check the username whether it is locked or unlocked in DB level ......etc
If you know any thing couald you please help me out ...
i am using OBIEE 18.104.22.168 and OBIA 22.214.171.124
after installation OBIA i was gettign the same error as you mentioned.
I am also using same versions. even i re-installed 3 times same issue happens after installing BI Apps (any version of apps)
i tried all means and ways to fix this issue Till now i didn't got any solution and i also looking for solution. I can't rise SR. so if you have can please do so.
Edited by: Sher Ullah Baig on Apr 18, 2013 8:43 AM