Hi All,
We see this error in our environment, and thinking of the below mentioned as a workaround solution.
If any of you have see this error in your experience or have an idea of such exception errors , please help with appropriate fix ?
Is this anyway related to DB configuration, do we need any DB parameter changes or any timeout settings at the database level or anything related to Java application ?
Oracle DB - 12c
1) The error log "Exception [java.io.IOException: IO Error:There is no process to read data written to a pipe.] oracle.jdbc.driver.OracleBlobOutputStream.write(OracleBlobOutputStream.java:157)"
2) Transaction 0000017077D5A74F00000001422F86F8D04EA99C4B516EB0AA383A518412D72D9AB07E440000017077D5A74F00000001422F86F8D04EA99C4B516EB0AA383A518412D72D9AB07E4400000001 has timed out after 480 seconds.
We are thinking of the below as workaround solution,
To replace the jar,
<Install Dir>/vendor/Libraries/Oracle12cR2/ojdbc8.jar is mapped in WAS > Environment > WebSphere variables & Shared libraries, and variable is mapped in WAS > Resources > JDBC > JDBC provider in classpath
To add JVM argument, add -Doracle.net.useZeroCopyIO = false in
Application servers > server1 > Process definition > Java Virtual Machine > Generic JVM arguments