[nQSError: 12017] Unexpected socket read timeout: connection terminated by network, e.g. by the fire — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

[nQSError: 12017] Unexpected socket read timeout: connection terminated by network, e.g. by the fire

Received Response
236
Views
12
Comments
Vamshi Pulumati
Vamshi Pulumati Rank 2 - Community Beginner
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

Hi Folks,

We are facing an issue intermittently in OBIEE 12C. When we hit the URL sometimes it stuck at "signing" page and after some time it gives OBIEE login page as below

pastedImage_0.png

Sametime in presentation server logs it throws below error,

[2017-05-17T04:11:59Z] [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: f3368185-7b51-4d64-9201-37afbcc5971c-00003799,0:3:1] [tid: 1194919680] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Odbc driver returned an error (SQLDriverConnectW).

State: HY000.  Code: 10058.  [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

(HY000)

State: HY000.  Code: 12017.  [nQSError: 12017] Unexpected socket read timeout: connection terminated by network, e.g. by the firewall. (HY000)[[

File:checkauthentication.cpp

Line:1607

Location:

        saw.securitysubsystem.checkauthentication.runimpl

        saw.threadpool.asynclogon

        saw.threads

]]

Any help will be greatly appreciated. Thanks in advance.

«1

Answers

  • 3310714
    3310714 Rank 6 - Analytics Lead

    Hi,

    Are you trying to log into using your AD account or local account?   I had an intermittent issue before with logging with the local account and it took about 1 minute.  I re-ordered the Providers in Weblogic Console and it is fine now.   If it's your AD authentication, you may also want to check your AD configuration settings. 

  • Vamshi Pulumati
    Vamshi Pulumati Rank 2 - Community Beginner

    Hi,

    Thanks a lot for your reply, we are using AD account. Could you please let us know what are all the configuration settings we need to check?

  • Vamshi Pulumati
    Vamshi Pulumati Rank 2 - Community Beginner

    One more update , this is an intermittent issue we saw this issue using local account also sometimes. So with both logins its giving issue.

  • 3310714
    3310714 Rank 6 - Analytics Lead

    What is the order of your authentication provider?  I have 1) DefaultAuthenticator 2) MSAD


    When you have this issue, what did you do to fix it?  Bounce the servers?  

  • Vamshi Pulumati
    Vamshi Pulumati Rank 2 - Community Beginner

    Hi,

    same order we follow as well,

    1) DefaultAuthenticator 2) MSAD

    As a workaround whenever we face this issue we either refresh the page or enter the credentials manually.

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Hi Vamshi,

    You have said in your Original Post that "some time it gives AD login page as below", just a correction its not AD login page its BIEE Login Page.

    You have already mentioned error captured in sawlog(X).log could you also look for error logged into obis1-diagnostics.log , bi_server1.log and bi_server1-diagnostics.log at the same time when login into BI application fails, so that you could get more information on what caused the failure.

    Thanks and Regards,

    Syed Hamd Salman

  • 3310714
    3310714 Rank 6 - Analytics Lead

    are you trying to do single-sign on?  You said sometimes you enter the credentials manually. 

  • Vamshi Pulumati
    Vamshi Pulumati Rank 2 - Community Beginner

    Hi Syed,

    Thanks for the correction.

    Sorry for the delay in reply , we checked all the logs for same time frame and no significant errors found.

  • Vamshi Pulumati
    Vamshi Pulumati Rank 2 - Community Beginner

    Hi,

    Sorry for the delay in reply.

    Yes we do use SSO, this error is after passing the SSO.  After the error in the same screen we enter the credentials manually.

    Thanks

  • Vamshi Pulumati
    Vamshi Pulumati Rank 2 - Community Beginner

    We are still seeing the issue , any help would be greatly appreciated.