Have a question about SnapLogic for your use case? Ask here for technical advice from fellow SnapLogic practitioners and experts!
610 members
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
Hi Everyone I have question around Groundplex which has 2 feeder and 3 jcc node. The feeder node has 8gb and JCC has 16gb RAM. Initially we were seeing uneven traffic request distribution across nodes and capture max file descriptor, swap space were not uniform. So we have changed and adopted recommendation value. We have kept Max Slot 4000. And since max slot is setup on Snaplex level the feeder node also have 4k config. The Snap official document says for 8Gb Ram it is 2k slot recommend and for 16gb it is 4k. The problem is that we are sometime observing "No Slot available" error or trigger pipeline not getting invoke. Can someone help here.
Hello everyone! I am working with fixed-width files that contain hundreds and even thousands of fields. I have been using the Fixed-Width Parser snap, however I have to manually add every single column name which takes hours upon hours. I am wondering if anyone has any experience with parsing fixed-width files that have hundreds of fields, what are other options than the fixed-width parser snap or how can I make the fixed-width parser snap more dynamic?
Hello everyone, I am using a source query as below SELECT BUSINESS_UNIT AS DEGREE_UNIT,BU_DESCR AS DESCR FROM BUSINESS_UNIT_DIM WHERE or BUSINESS_UNIT != '' or BUSINESS_UNIT != ' ' GROUP BY BUSINESS_UNIT, BU_DESCR In the BUSINESS_UNIT_DIM table there is a row with BU_DESCR = 'Unassigned'and BUSINESS_UNIT = ' ' We want to discard this record in the target. Somehow Snaplogic is still picking this particular record up using this source query and failing at the target. How do I handle this situation. Any suggestions are welcome!
Hello everyone, I'm trying to create a MCP server as per the quick start tutorial and everything worked as expected while I built the components following the instructions, but my client cannot connect to the URL generated, I'm getting this error message:
2026-09-01 20:55:01.595 [info] Connection state: Error Error sending message to https://pa2s-sdjc-ifx0c6uynsd61asd4:8081/mcpserver/6a9771d5ht39yt72cmwr82ea/mcp: TypeError: fetch failed: getaddrinfo ENOTFOUND pa2s-sdjc-ifx0c6uynsd61asd4
Anyone else also had this issue? Many thanks in advance! JF
Hello ! Please, I would have a question about groundplex space. I see total use of node disk is almost 100%. Analyzing metrics, I've found a lot of jsonl files, I suppose temp files. Could I erase them ? Do you have best practice to save space ? Thank you. Giuseppe.
How can we run a pipeline on a specific node ??
Hi Team, We have salesforce account created using "Salesforce.com account" by providing username,pwd and url. We are using REST/BULK API calls while using Salesforce snaps in the pipeline to read or write data. But wanted to understand how the account is getting validated/authenticated by using SOAP or BULK or REST api? This helps in understanding the impact due to "Salesforce SOAP API Versions 31.0 Through 64.0 Is Being Retired"
Cross-Charging / Chargeback Dashboard: For several of our customers, cross-charging their SnapLogic costs is a pain point, as this is important for the operation of the SnapLogic platform in their environment. I've created an app that addresses this and demonstrates how we can support their cross-charging efforts by reusing our own platform APIs. Streamlit version of the Dashboard: snaplogic-chargeback-console.streamlit.app HTML version of the Dashboard: d2zxh8bw7u6rsc.cloudfront.net Documentation: jc-apps.snaplogic-demo.com/sl/jc-hosted/others/snaplogic-chargeback-solution-v2-0.pdf It would be great to get your feedback on this. If it could be helpful, what needs to change, etc.
I am getting an error saying the below while trying to run pipelines. Any suggestions?
Unable to prepare pipeline on node: uadvdev-slgc-01 (6a61d8b61b2a535bd6fa81e3)
Reason:Unable to contact CC to start runtime.
Resolution:Check network connectivity with the Snaplex node.Couldn't find any Documentation on how to use Snapcode using Claude code, Can someone help ?
Hello everyone, Quick question if anyone can help... Is there any Snap or technique/workaround known that can be used to compare 2 strings and calculate the difference between them to generate quantitative data (for example the Levenshtein distance)? Thanks all in advance!
I'm having trouble implementing pagination in my HTTP Client Snap. I have 'Has next' in Pagination set to $.entity.meta.page.hasMore == true but it doesn't seem to be iterating. How do I specify the next URL to export all pages from the API?
Hello, Can someone tell me how can I disable an account? I would like to keep it but prevent anything from using it. Thanks Andrei
