Re: [OBIEE EMG] After Configuring SSL Unable to login BIPS

[Sashii]

Did you check the option SSO enabled in EM ?

On Tuesday, October 27, 2015, Deva <devar...@gmail.com> wrote:

Hi All,   Configured SSL in our server, after configuring SSL we are able to login Weblogic console & em using SSL https URL. but we unable to login into BI Presentation server.   Error message in BIPS login page: " An error occurred during authentication. Try again later or contact your system administrator."   Note: tried with GUID refresh and restart all bi server but no luck. please help me to fix this issue. thanks guru :)   fyi, below is the nqserver and sawlog file,   nqserver.log ================= 2015-10-27T12:40:09.000+08:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 2310]  [13026] Error in getting roles from BI Security Service:  'An error message was received from the BI Security Service: [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[ [nQSError: 12010] Communication error connecting to remote end point: address = 10.197.208.106; port = 9804. [nQSError: 46119] Failed to open HTTP connection to server 10.197.208.106 at port 9804.' ]] [2015-10-27T12:40:09.000+08:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 2310]  [13037] Cannot connect to BI Security Service, please make sure this is running properly (with SSL or not) in EM. [2015-10-27T12:40:10.000+08:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 2310]  [46172] Database security store is not available, do not re-associate to this provider type. [2015-10-27T12:40:10.000+08:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 2310] nqsserver: Clustered Oracle BI Server (64-bit) started.  Version: 11.1.1.7.131017. [2015-10-27T12:40:11.000+08:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00iWQJosy6N6IRB_RX9Did0001oK00001z,0] [tid: 19f8]  [43071] A connection with Cluster Controller W01GMLRAPP12A.reg1.1bank.dbs.com:9706 was established. [2015-10-27T12:40:20.000+08:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00iWQJoj_9Z6IRB_RX9Did0001oK000018,0] [tid: 7bc] Could not connect to the authentication web service (taking OBIS offline) 10.197.208.106: [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[ [nQSError: 12010] Communication error connecting to remote end point: address = 10.197.208.106; port = 9804. [nQSError: 46119] Failed to open HTTP connection to server 10.197.208.106 at port 9804.   sawlog.log [2015-10-27T12:40:10.000+08:00] [OBIPS] [ERROR:16] [] [saw.security.userpopulationcache.populateapproleshierarchy] [ecid: 00iWQJoUuOf6IRB_RX9Did0001kC000000,0:1] [tid: 9408] 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 (W01GMLRAPP12A.reg1.1bank.dbs.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[ File:userpopulationcache.cpp Line:381 Location:  saw.security.userpopulationcache.populateapproleshierarchy  saw.RoleHierarchyCache.cache.cleanup  saw.taskScheduler.processJob  saw.threadpool.taskscheduler  saw.threads ecid: 00iWQJoUuOf6IRB_RX9Did0001kC000000,0:1 ThreadID: 9408 task: Cache/RoleHierarchyCache ]] [2015-10-27T12:42:37.000+08:00] [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: 0d4d42f6b15a80f1:-27ad4ed5:150a7986fa3:-8000-000000000000001f,0:1:1] [tid: 2188] 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 (W01GMLRAPP12A.reg1.1bank.dbs.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[ File:checkauthentication.cpp Line:1341 Location:  saw.securitysubsystem.checkauthentication.runimpl  saw.threadpool.asynclogon  saw.threads ecid: 0d4d42f6b15a80f1:-27ad4ed5:150a7986fa3:-8000-000000000000001f,0:1:1 ThreadID: 2188 ]] [2015-10-27T12:43:07.000+08:00] [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: 0d4d42f6b15a80f1:-27ad4ed5:150a7986fa3:-8000-0000000000000026,0:1:1] [tid: 9312] 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 (W01GMLRAPP12A.reg1.1bank.dbs.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[ File:checkauthentication.cpp Line:1341 Location:    Thanks Deva

--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Girish]

Looking at the errors I presume you've enabled SSL on WLS servers(Admin and Managed) but haven't yet properly enabled inter-component SSL for all BI components.

Oracle recommendation is to enable intercomponent SSL. If you don't want SSL across BI components(for whatever reasons) then you have leave http enabled on WLS and use an external firewall to block outside http traffic.

--

Regards,
Girish Lakshmanan

[Vijaygaligari]

Do you login using the systemuser?

You need to login as systemuser and change a little configuration in BIPS admin. 

Thanks,

Vijay Galigari

408-242-2214(c)