This discussion is archived
6 Replies Latest reply: Aug 20, 2013 8:00 AM by hyperipwn RSS

OBIEE SSO with AD@WIN03 Server: Can not login answers at all.

$uresh Newbie
Currently Being Moderated

Hi All

 

No Answer found here, No problemos i will sort this out.

 

I am trying to configure SSO on following environment. But I am failing to log on answers using weblogic user.

Without ADAutho I am able to login but as soon as i setup the ADAuth with following information its failing.

 

OS: Windows 2003 Server

OBI: 11.1.1.7

Windows login: Administrator/Admin123 ( I have also created weblogic Windows user)

OBIEE Login: weblogic/Admin123

Hostname:  test.dev.local

 

cn
Host:localhost
Port:389
Principal:CN=Administrator,CN=Users,DC=dev,DC=local
Credential:password
Confirm Credential:password
User Base DN:CN=Users,DC=dev,DC=local
All Users Filter:(&(cn=*)(objectclass=user))
User From Name Filter:(&(cn=%u)(objectclass=user))
User Search Scope:subtree
User Name Attribute:
User Object Class:user
Use Retrieved User Name as Principalunchecked
Group Base DN:CN=Builtin,DC=dev,DC=local
All Groups Filter:(&(Administrators=*)(|(objectclass=groupofUniqueNames)(objectclass=orcldynamicgroup)))
Group From Name Filter:(&(Administrators=%g)(objectclass=group))
Group Search Scope:subtree
Group Membership Searching:unlimited

 

oracle.bi.system -> system.user = weblogic/Admin123

 

I have added Administrator and weblogic users under
weblogic Domain -> bifoundaton_domain -> Security -> Applicaton Role -> BISystem -> weblogic/Administrator
weblogic Domain -> bifoundaton_domain -> Security -> Security Provider Configuration -> Identity Store Provider
       user.login.attr = weblogic
       username.attr = weblogic
       virtualize = false

 

Please help where i am making mistake?

 

 

log:

 

46.000+00:00] [NOTIFICATION:1] [] [] [ecid: 00iFv3bqAEyFg4WFLzbQ8A0000tW000000] [tid: fb0]  [85004] MDX Member Name Cache subsystem recovered entries: 0, size: 0 bytes.

49.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bqAEyFg4WFLzbQ8A0000tW000000] [tid: fb0] An error message was received from the BI Security Service: oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed - the system user profile could not be found in the identity store.

49.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bqAEyFg4WFLzbQ8A0000tW000000] [tid: fb0]  [13026] Error in getting roles from BI Security Service:  'An error message was received from the BI Security Service: oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed - the system user profile could not be found in the identity store.'

49.000+00:00] [NOTIFICATION:1] [] [] [ecid: 00iFv3bqAEyFg4WFLzbQ8A0000tW000000] [tid: fb0]  [46172] Database security store is not available, do not re-associate to this provider type.

49.000+00:00] [NOTIFICATION:1] [] [] [ecid: 00iFv3bqAEyFg4WFLzbQ8A0000tW000000] [tid: fb0] nqsserver: Clustered Oracle BI Server started.  Version: 11.1.1.7.0.

50.000+00:00] [NOTIFICATION:1] [] [] [ecid: 00iFv3bqAEyFg4WFLzbQ8A0000tW000000] [tid: 144c]  [43071] A connection with Cluster Controller test.dev.local:9706 was established.

17.000+00:00] [ERROR:1] [] [] [ecid: 73e4b32acf5b3b94:57149bf0:13fc5437f64:-8000-0000000000000074] [tid: 1148] oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed - the system user profile could not be found in the identity store.

17.000+00:00] [ERROR:1] [] [] [ecid: 73e4b32acf5b3b94:57149bf0:13fc5437f64:-8000-0000000000000074] [tid: 1148]  [nQSError: 43126] Authentication failed: invalid user/password.

29.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: ce4] oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed - the system user profile could not be found in the identity store.

29.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: ce4]  [nQSError: 43126] Authentication failed: invalid user/password.

14.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: 28c] oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed - the system user profile could not be found in the identity store.

14.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: 28c]  [nQSError: 43126] Authentication failed: invalid user/password.

59.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: 103c] oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed - the system user profile could not be found in the identity store.

59.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: 103c]  [nQSError: 43126] Authentication failed: invalid user/password.

44.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: 11d0] oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed - the system user profile could not be found in the identity store.

44.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: 11d0]  [nQSError: 43126] Authentication failed: invalid user/password.

15.000+00:00] [ERROR:1] [] [] [ecid: 73e4b32acf5b3b94:57149bf0:13fc5437f64:-8000-000000000000025a] [tid: 17e4] oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed - the system user profile could not be found in the identity store.

15.000+00:00] [ERROR:1] [] [] [ecid: 73e4b32acf5b3b94:57149bf0:13fc5437f64:-8000-000000000000025a] [tid: 17e4]  [nQSError: 43126] Authentication failed: invalid user/password.

29.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: 1658] oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed - the system user profile could not be found in the identity store.

29.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: 1658]  [nQSError: 43126] Authentication failed: invalid user/password.

14.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: 108c] oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed - the system user profile could not be found in the identity store.

14.000+00:00] [ERROR:1] [] [] [ecid: 00iFv3bnU^dFg4WFLzbQ8A0000r8000000] [tid: 108c]  [nQSError: 43126] Authentication failed: invalid user/password.

 

 

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points