Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Error 403--Forbidden in OBIEE Analytics page after configuring SSO with SAML 2.0

Hi All ,
I have Configured SSO in OBIEE with SAML and siteminder .
SAML respose file is passing the Username (abc123) , of the entered EMAIL ID (miller.john@domain.com) from Active Directory , to OBIEE .
So , I created a user 'abc123' in OBIEE , assinged this to Administrators and BIAdministrators groups .
It seems the SSO is working . After hitting OBIEE analytics URL (http://localhost:9704/analytics) , its redirecting to siteminder agent gateway (SSO login Page) .
After Loggin in with EMAIL ID (miller.john@domain.com)and password , its getting redirected to the OBIEE analytics page .
Which is throwing "Error 403--Forbidden" .
sawlog0 and nqserver log files are giving below error :
Error in getting roles from BI Security Service
System user validation failed - the system user profile could not be found in the identity store.
Error retrieving user/group data from Oracle BI Server's User Population API.
Error searching roles in the backend to resolve GUIDs during user population manager initialization
Error initializing/loading existing Catalog: /u01/app/obiee/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite.
AND at the end its keep on logging below error in sawlog0.log :
Unable to get a system user connection to BI Server (attempt 101 of 500). Sleeping for 4 seconds before trying again.
I Performed the below troubleshooting's , nothing resolved the issue .
1. Resetting BISytemUser password in console and EM .
2. Providers - > defaultAuthenticator - > control flag … SUFFICIENT
3. Added weblogic user under
weblogic Domain -> bifoundaton_domain -> Security -> Applicaton Role -> BISystem
4. Added custom property “virtualize=false” in Identity store configuration in EM
5. Performed GUID refresh .
6. Checked all services (Admin , managed servers and BI components are up and running)
Please Help .
Answers
-
just in case verify your config with doc id 1350125.1
and 1928807.1
0 -
Hi Srini ,
I validated the steps . All are good .
I also validated the SAML response in bi_server1.log , its giving me the usename and relevant group :
<ns2:NameID Format="urn:oasis:names:tc:SAML:1.1:nameid-format:unspecified">HITTCB7</ns2:NameID>
</ns2:AuthnStatement>
<ns2:AttributeStatement>
<ns2:Attribute Name="DomainUsers" NameFormat="urn:oasis:names:tc:SAML:2.0:attrname-format:unspecified">
Which , means SAML token is getting passed , successfully , however , OBIEE is failed to receive it ?
=====================================
However while checking the sawlog1 . I got the below error . Its getting written to sawlog1 , every time we are trying to log in :
Unable to get a system user connection to BI Server
Error retrieving user/group data from Oracle BI Server's User Population API. Could not create a system user connection to Oracle BI Server during start-up
Thanks
Sayak
0 -
Look at security integration user!
0 -
Hi Srini ,
Can you please elaborate "security integration user".
Thanks
Sayak
0 -
related to this config
http://3.bp.blogspot.com/-AYhcYzxZTiQ/UAKN7kDbadI/AAAAAAAAAQM/26q2n5xcDzA/s1600/72.png
0