4 Replies Latest reply on Jun 22, 2011 8:31 PM by 870726

    Broken PIPE exeption error.

    870726

      application users are running batch cycle and first time it is giving the error for broken pipe and when restarting the batch cycle then they getting success.

      any idea about this error?

      is it database related issue?


      [2011-06-06 21:02:30,611] DEBUG - [] [main] - Method initializeLog4j End.
      [2011-06-06 21:03:58,488] FATAL - [] [main] - [DATE = Mon Jun 06 21:03:58 HST 2011 ][DEBUG MSG= Io exception: Broken pipe] [SQLERRCODE= 17002 ][SQLSTATE= null ][DETAIL MSG= Io exception: Broken pipe ]
      java.sql.SQLException: Io exception: Broken pipe
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)
      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
      at java.sql.DriverManager.getConnection(DriverManager.java:525)
      at java.sql.DriverManager.getConnection(DriverManager.java:171)
      at com.aig.policy.BatchUtil.PASBatchUtil.getConnection(PASBatchUtil.java:616)
      at com.aig.policy.BatchUtil.PASBatchUtil.getNextProcDate(PASBat ,.chUtil.java:1106)
      at com.aig.policy.BatchUtil.PASBatchDriver.selectBatch(PASBatchDriver.java:144)
      at com.aig.BatchDriver.main(BatchDriver.java:116)
      [2011-06-06 21:03:58,500] FATAL - [] [main] - [DATE = Mon Jun 06 21:03:58 HST 2011 ][DEBUG MSG= Io exception: Broken pipe] [DETAIL MSG= Io exception: Broken pipe ]
      com.aig.policy.common.PASBatchException: Io exception: Broken pipe
      at com.aig.policy.BatchUtil.PASBatchUtil.getConnection(PASBatchUtil.java:618)
      at com.aig.policy.BatchUtil.PASBatchUtil.getNextProcDate(PASBatchUtil.java:1106)
      at com.aig.policy.BatchUtil.PASBatchDriver.selectBatch(PASBatchDriver.java:144)
      at com.aig.BatchDriver.main(BatchDriver.java:116)
      Caused by: java.sql.SQLException: Io exception: Broken pipe
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)
      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
      at java.sql.DriverManager.getConnection(DriverManager.java:525)
      at java.sql.DriverManager.getConnection(DriverManager.java:171)
      at com.aig.policy.BatchUtil.PASBatchUtil.getConnection(PASBatchUtil.java:616)
      ... 3 more
      [2011-06-06 21:03:58,504] ERROR - [] [main] - Logged by Driver
      com.aig.policy.common.PASBatchException: Io exception: Broken pipe
      at com.aig.policy.BatchUtil.PASBatchDriver.selectBatch(PASBatchDriver.java:157)
      at com.aig.BatchDriver.main(BatchDriver.java:116)
      Caused by: com.aig.policy.common.PASBatchException: Io exception: Broken pipe
      at com.aig.policy.BatchUtil.PASBatchUtil.getConnection(PASBatchUtil.java:618)
      at com.aig.policy.BatchUtil.PASBatchUtil.getNextProcDate(PASBatchUtil.java:1106)
      at com.aig.policy.BatchUtil.PASBatchDriver.selectBatch(PASBatchDriver.java:144)
      ... 1 more
      Caused by: java.sql.SQLException: Io exception: Broken pipe
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)
      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
      at java.sql.DriverManager.getConnection(DriverManager.java:525)
      at java.sql.DriverManager.getConnection(DriverManager.java:171)
      at com.aig.policy.BatchUtil.PASBatchUtil.getConnection(PASBatchUtil.java:616)
      ... 3 more
      [2011-06-06 21:03:58,510] DEBUG - [] [main] - Total time taken by this batch =87940ms
      [2011-06-06 21:03:58,510] DEBUG - [] [main] - ========================DETAILS LOG ENDS==========================
      [2011-06-06 21:15:25,547] DEBUG - [] [main] - Method initializeLog4j End.
      [2011-06-06 21:15:29,012] ERROR - [] [main] - Batch Run Date Cannot be a future date.
      [2011-06-06 21:15:29,014] FATAL - [] [main] - [DATE = Mon Jun 06 21:15:29 HST 2011 ][DEBUG MSG= Not a scheduled date for this batch.] [DETAIL MSG=  ]
      [2011-06-06 21:15:29,017] DEBUG - [] [main] - Problem in Next Proc date.
      [2011-06-06 21:15:29,018] DEBUG - [] [main] - Total time taken by this batch =3506ms
      [2011-06-06 21:15:29,018] DEBUG - [] [main] - ========================DETAILS LOG ENDS==========================