Hi, this is most likely do to a timeout or network issue.
1) When does this occur (i.e. calling the database or when trying to return the data to the user)
2) Is the WebSphere Plugin involved in your configuration?
3) How long do these files normally take to create?
Brian
------------------------------
Brian S Paskin
Sr. WebSphere, Liberty and MQ Architecture
Cloud Automation
IBM Expert Labs
------------------------------
Original Message:
Sent: Wed May 19, 2021 08:16 AM
From: krisha guttha
Subject: 00000120 SystemErr R Caused by: java.io.IOException: Async IO operation failed (2), reason: RC: 32 Broken pipe
When exporting large files we are facing issues in production. users are trying to export data that has been returned from a database query to either a CSV or XML file. When the websphere app server tries to send the response file back to the browser the error is thrown. Everything works fine in all lower environments.
00000120 SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
00000120 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)
00000120 SystemErr R Caused by: java.io.IOException: Async IO operation failed (2), reason: RC: 32 Broken pipe
00000120 SystemErr R at com.ibm.io.async.AsyncLibrary$IOExceptionCache.<init>(AsyncLibrary.java:924)
00000120 SystemErr R at com.ibm.io.async.AsyncLibrary$IOExceptionCache.get(AsyncLibrary.java:937)
00000120 SystemErr R at com.ibm.io.async.AsyncLibrary.getIOException(AsyncLibrary.java:951)
00000120 SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:213)
00000120 SystemErr R ... 3 more
------------------------------
krisha guttha
------------------------------