java.sql.SQLException: java.net.SocketTimeoutException: Read timed out

Oracle Community | 2770443 | 2 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    When running a job report on BI Publisher we get an exception for queries lasting more than 3 minutes

    Oracle Community | 2 years ago | 2770443
    java.sql.SQLException: java.net.SocketTimeoutException: Read timed out

    Root Cause Analysis

    1. java.sql.SQLException

      java.net.SocketTimeoutException: Read timed out

      at oracle.bi.jdbc.AnaJdbcStatementImpl.executeQuery()
    2. oracle.bi.jdbc
      AnaJdbcPreparedStatementImpl.executeQuery
      1. oracle.bi.jdbc.AnaJdbcStatementImpl.executeQuery(AnaJdbcStatementImpl.java:377)
      2. oracle.bi.jdbc.AnaJdbcStatementImpl.execute(AnaJdbcStatementImpl.java:258)
      3. oracle.bi.jdbc.AnaJdbcPreparedStatementImpl.execute(AnaJdbcPreparedStatementImpl.java:504)
      4. oracle.bi.jdbc.AnaJdbcPreparedStatementImpl.executeQuery(AnaJdbcPreparedStatementImpl.java:202)
      4 frames
    3. oracle.xdo.dataengine
      XMLPGEN.processSQLDataSource
      1. oracle.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1529)
      2. oracle.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:420)
      2 frames