Oracle Bulk Load Snap Failing with Error Writing Input to the Data File Due to Broken Pipe Error
Hi Everyone, Could you please help me understand and resolve the error below? The Oracle Bulk Load Snap is failing with the error mentioned below. I am unable to identify the root cause or understand what is triggering the issue. Any guidance or suggestions would be greatly appreciated, as I need to resolve this as soon as possible. Thank you in advance for your support and assistance. Error writing input to the data file Resolution: Please file a defect against the snap Reason: Broken pipe Hide Details... Write Oracle STG2 Price[5d8e00959248c560fbcf7117_b13e2019-844b-4471-8e60-be1659dd06fa -- 5c10b3fb-0778-496c-b961-eecbbc1a5a37] com.snaplogic.snap.api.SnapDataException: Error writing input to the data file at com.snaplogic.snaps.oracle.BulkLoad.processDocument(BulkLoad.java:628) at com.snaplogic.snaps.sql.SimpleSqlSnap.process(SimpleSqlSnap.java:494) at com.snaplogic.snaps.oracle.BulkLoad.execute(BulkLoad.java:528) at com.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:836) at com.snaplogic.cc.snap.common.SnapRunnableImpl.execute(SnapRunnableImpl.java:599) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:901) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:447) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:119) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: java.io.IOException: Broken pipe at java.base/java.io.FileOutputStream.writeBytes(Native Method) at java.base/java.io.FileOutputStream.write(Unknown Source) at java.base/sun.nio.cs.StreamEncoder.writeBytes(Unknown Source) at java.base/sun.nio.cs.StreamEncoder.implFlushBuffer(Unknown Source) at java.base/sun.nio.cs.StreamEncoder.implFlush(Unknown Source) at java.base/sun.nio.cs.StreamEncoder.flush(Unknown Source) at java.base/java.io.OutputStreamWriter.flush(Unknown Source) at java.base/java.io.BufferedWriter.flush(Unknown Source) at com.snaplogic.snaps.oracle.BulkLoad.processDocument(BulkLoad.java:626) ... 13 more Reason: Broken pipe Resolution: Please file a defect against the snap Error Fingerprint[0] = efp:com.snaplogic.snaps.oracle.ctb9jSj5 Error Fingerprint[1] = efp:java.io.UaHETxDF Write Oracle STG2 Price[5d8e00959248c560fbcf7117_b13e2019-844b-4471-8e60-be1659dd06fa -- 5c10b3fb-0778-496c-b961-eecbbc1a5a37] com.snaplogic.cc.snap.common.ThreadDetails: prio=4 Id=346649 RUNNABLE at java.base@11.0.24/java.lang.StringBuilder.append(Unknown Source) at java.base@11.0.24/sun.net.util.URLUtil.urlNoFragString(Unknown Source) at java.base@11.0.24/java.security.CodeSource.<init>(Unknown Source) at java.base@11.0.24/java.net.URLClassLoader.defineClass(Unknown Source) at java.base@11.0.24/java.net.URLClassLoader$1.run(Unknown Source) at java.base@11.0.24/java.net.URLClassLoader$1.run(Unknown Source) at java.base@11.0.24/java.security.AccessController.doPrivileged(Native Method) at java.base@11.0.24/java.net.URLClassLoader.findClass(Unknown Source) ... at java.base@11.0.24/java.lang.StringBuilder.append(Unknown Source) at java.base@11.0.24/sun.net.util.URLUtil.urlNoFragString(Unknown Source) at java.base@11.0.24/java.security.CodeSource.<init>(Unknown Source) at java.base@11.0.24/java.net.URLClassLoader.defineClass(Unknown Source) at java.base@11.0.24/java.net.URLClassLoader$1.run(Unknown Source) at java.base@11.0.24/java.net.URLClassLoader$1.run(Unknown Source) at java.base@11.0.24/java.security.AccessController.doPrivileged(Native Method) at java.base@11.0.24/java.net.URLClassLoader.findClass(Unknown Source) at org.eclipse.jetty.webapp.WebAppClassLoader.foundClass(WebAppClassLoader.java:642) at org.eclipse.jetty.webapp.WebAppClassLoader.loadAsResource(WebAppClassLoader.java:615) at org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:529) at java.base@11.0.24/java.lang.ClassLoader.loadClass(Unknown Source) at com.snaplogic.snaps.sql.SimpleSqlSnap.handleSnapException(SimpleSqlSnap.java:525) at com.snaplogic.snaps.sql.SimpleSqlSnap.process(SimpleSqlSnap.java:502) at com.snaplogic.snaps.oracle.BulkLoad.execute(BulkLoad.java:528) at com.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:836) at com.snaplogic.cc.snap.common.SnapRunnableImpl.execute(SnapRunnableImpl.java:599) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:901) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:447) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:119) at java.base@11.0.24/java.util.concurrent.FutureTask.run(Unknown Source) at java.base@11.0.24/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base@11.0.24/java.util.concurrent.FutureTask.run(Unknown Source) at java.base@11.0.24/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base@11.0.24/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base@11.0.24/java.lang.Thread.run(Unknown Source) Error Fingerprint[0] = efp:java.lang.DuhpYimn
