8 Replies Latest reply: Mar 7, 2013 1:11 PM by e_macmill RSS

    [nQSError: 12002] Socket communication error at call=recv: (Number=10038)

    737581
      Hi, When I try to run any reports in Oracle Answers I am getting the following error:
      Odbc driver returned an error (SQLExecDirectW).
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
      [nQSError: 12002] Socket communication error at call=recv: (Number=10038) An operation was attempted on something that is not a socket. (HY000)

      When I try to issue a 'Direct Database Request' from Answers, it is working fine. The error is occuring only when I select any columns from the Presentation Catalog and try to run the Adhoc report.

      Please could you help me fix this issue.

      Thanks
      Srikanth
        • 1. Re: [nQSError: 12002] Socket communication error at call=recv: (Number=10038)
          738077
          Hi There

          Can you please look into the query/server log and paste the content? That will help us debug it more

          Sunil S Ranka
          Blog :: http://sranka.wordpress.com
          "Superior BI is the antidote to Business Failure"
          • 2. Re: [nQSError: 12002] Socket communication error at call=recv: (Number=10038)
            737581
            Hi Sunil,
            Please see the log entries as below:

            NQSQuery.log
            ------------------
            Odbc driver returned an error (SQLExecDirectW).
            Error Details
            Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
            State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 12002] Socket communication error at call=recv: (Number=10038) An operation was attempted on something that is not a socket. (HY000)

            SQL Issued: SELECT Time."Year" saw_0, Time."Month" saw_1, "Marketing Schemes".Activity saw_2, "Marketing Schemes".Selection saw_3, "Marketing Schemes"."Response Code" saw_4, "Marketing Schemes"."Total Cost" saw_5, "Marketing Schemes"."Total Enquiries" saw_6, "Marketing Schemes"."Total Appointments" saw_7, "Marketing Schemes"."Total Sales" saw_8, IFNULL("Marketing Schemes"."Income from Transactions", 0) saw_9 FROM Marketing WHERE "Event Types"."Event Type" = 'New Marketing Campaign' ORDER BY saw_0 DESC, saw_1 DESC, saw_2 DESC

            ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

            SAWlog0.log
            ------------------
            Type: Error
            Severity: 40
            Time: Thu Nov 26 10:50:30 2009
            File: project/webodbcaccess/odbcstatementimpl.cpp Line: 196
            Properties: ConnId-1;StmtId-6;ThreadID-2248
            Location:
                 saw.odbc.statement.execute
                 saw.querycache.executeQuery
                 saw.threadPool
                 saw.threads

            Odbc driver returned an error (SQLExecDirectW).
            State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
            [nQSError: 12002] Socket communication error at call=recv: (Number=10038) An operation was attempted on something that is not a socket. (HY000)
            ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

            jhost0.log
            --------------
            Dec 1, 2009 12:09:16 PM Main main
            INFO: Listening for new connections
            Dec 1, 2009 3:00:08 PM MessageProcessorImpl processMessage
            WARNING: Unexpected exception. Connection will be closed
            java.io.EOFException
                 at com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocol.readInt(SAWProtocol.java:167)
                 at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:133)
                 at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223)
                 at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:205)
                 at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:153)
                 at java.lang.Thread.run(Thread.java:595)
            ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

            When we tried the OBI installation on a different server, every thing was smooth and no such above errors appear using the same DB and RPD. Our ODBC and Connection Pool settings were also same on both the servers.

            Thanks
            Srikanth
            • 3. Re: [nQSError: 12002] Socket communication error at call=recv: (Number=10038)
              742774
              Did you ever solve this, I ahve same error creating SQL direct request.
              • 4. Re: [nQSError: 12002] Socket communication error at call=recv: (Number=10038)
                783226
                It happend to me as well.

                Any ideas:
                What cause it?
                How can I solve it?
                • 5. Re: [nQSError: 12002] Socket communication error at call=recv: (Number=10038)
                  861799
                  HI All,


                  Even i have the same issue and OBI Server crashing intermittently. Please help me..


                  Thanks,
                  Ram.
                  • 6. [nQSError: 12002] Socket communication error at call=recv: (Number=10038)
                    861799
                    Due to the below error. The BI server was shutting down.
                    ==================================
                    Odbc driver returned an error (SQLExecDirectW).
                    Error Details
                    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
                    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 12002] Socket communication error at call=recv: (Number=10054) An existing connection was forcibly closed by the remote host. (HY000)

                    ===================================

                    Please help me. I'm new to OBIEE.

                    Thanks,
                    Ram.
                    • 7. Re: [nQSError: 12002] Socket communication error at call=recv: (Number=10038)
                      319739
                      each user has been locked out and the following error occured in the log - File:
                      [nQSError: 12002] Socket communication error at call=recv: (Number=10054) An existing connection was forcibly closed by the remote host.

                      Is there any solution?

                      Regards,

                      Stefan

                      P.:

                      ================================================================================

                      - <msg time="2012-02-10T13:57:31.000+00:00" comp_id="OracleBIServerComponent" type="ERROR" level="1" host_id="ip-0A6F4133" host_addr="192.168.1.123" tid="1090" ecid="00i5nBB3AnWFW7WFLz6UOA0000rK0002sP" rid="0">
                      <attr name="TARGET" value="/Farm_bifoundation_domain/instance1/coreapplication_obis1" />
                      <attr name="TARGET_TYPE" value="oracle_bi_server" />
                      <txt>[nQSError: 12002] Socket communication error at call=recv: (Number=10054) An existing connection was forcibly closed by the remote host.</txt>


                      ================================================================================
                      • 8. Re: [nQSError: 12002] Socket communication error at call=recv: (Number=10038)
                        e_macmill
                        Bumping this thread..

                        Recently changed my date field from varchar to date -- now one report in particular is crashing the system. This is the only error I receive:

                        [2013-03-07T13:42:30.000-05:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00iDTyWNmvY6eLCprC_AiY000268000000] [tid: 1c8c] [nQSError: 12002] Socket communication error at call=recv: (Number=10054) An existing connection was forcibly closed by the remote host.