2 Replies Latest reply: Apr 15, 2014 12:59 PM by Jcgo-Oracle RSS

    java.sql.SQLTimeoutException: ORA-03111: break received on communication channel

    Jcgo-Oracle

      Hi,

       

      I am getting these errors on my WLS server logs.

      *****************

      SEVERE: Exception fetching data for theme JDBC_THEMEDAA.

      Message:null

      Description: Nested exception is:

      Description: Nested exception is:

      java.sql.SQLTimeoutException: ORA-03111: break received on communication channel

       

      java.sql.SQLTimeoutException: ORA-03111: break received on communication channel

       

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

              at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)

              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(Oracle

      at oracle.sdovis.theme.DynGeomThemeProducer.loadFeaturesInAdjustedMBR(DynGeomThemeProducer.java:386)
          at oracle.sdovis.theme.DynGeomThemeProducer.prepareData(DynGeomThemeProducer.java:892)
          at oracle.sdovis.Theme.prepareData(Theme.java:206)
          at oracle.sdovis.LoadThemeData2.run(LoadThemeData2.java:90)
          at oracle.sdovis.DBMapMaker.prepareThemes2(DBMapMaker.java:2250)
          at oracle.sdovis.DBMapMaker.prepareThemes(DBMapMaker.java:2184)
          at oracle.lbs.foi.FOIDataProducer.getFoiDataFromJDBCTheme(FOIDataProducer.java:218)
          at oracle.lbs.foi.ThemeRenderingThread.getFeatures(ThemeRenderingThread.java:871)
          at oracle.lbs.foi.ThemeRenderingThread.getFeatures(ThemeRenderingThread.java:795)
          at oracle.lbs.foi.ThemeRenderingThread.render(ThemeRenderingThread.java:308)
         

      at oracle.lbs.foi.ThemeRenderingThread.run(ThemeRenderi

       

       

      ***********************

       

      thanks

       

      Action Taken:

      On DB side:

       

      SQLNET.RECV_TIMEOUT = 3000

      SQLNET.EXPIRE_TIME = 50

      SQLNET.INBOUND_CONNECT_TIMEOUT = 1000