6 Replies Latest reply: Aug 20, 2013 10:00 AM by hyperipwn RSS

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

    $uresh

      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