Ravi
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
How to fetch field values after group by snap which are not part of group
Hi, After using group by logic for combination of fields the downstream snaps are loosing the values. Example: Input file fields: field1, field2 field3, field4,Test1,test2 group by Logic Used for: field1, field2 field3 after above step : values are not finding for field4,Test1,test2. how to get original values. Thanks,4.8KViews0likes3CommentsRe: Handling Oracle non-standard CSV exports
Hi, Thanks for reply, will this resolve issue with only double quotes or also non english characters are mapped in transformation. (if possible can you include the formula used in transformation.) can you please tell the reason for including document to binary before csv parser. Thank you in advance.2.9KViews0likes2CommentsGetting Snap aborted error when executing script file
Snap was aborted Hide Details… Script[5d35a4b567ad1a03d5af51a6_8067c2d5-703e-432b-a5aa-3dfe73595b42 – 99f07565-a279-430f-9660-184162b1c909] com.snaplogic.cc.snap.common.ThreadDetails: Waiting to receive data from s3.amazonaws.com/XX.XXX.XX.XX:XXX at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at com.snaplogic.instrument.TracingInputStream.read(TracingInputStream.java:88) at sun.security.ssl.InputRecord.readFully(InputRecord.java:465) at sun.security.ssl.InputRecord.read(InputRecord.java:503) at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:983) at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:940) at sun.security.ssl.AppInputStream.read(AppInputStream.java:105) at org.apache.http.impl.io.AbstractSessionInputBuffer.fillBuffer(AbstractSessionInputBuffer.java:161) at org.apache.http.impl.io.SocketInputBuffer.fillBuffer(SocketInputBuffer.java:82) at org.apache.http.impl.io.AbstractSessionInputBuffer.readLine(AbstractSessionInputBuffer.java:276) at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:138) at org.apache.http.impl.conn.DefaultHttpResponseParser.parseHead(DefaultHttpResponseParser.java:56) at org.apache.http.impl.io.AbstractMessageParser.parse(AbstractMessageParser.java:259) at org.apache.http.impl.AbstractHttpClientConnection.receiveResponseHeader(AbstractHttpClientConnection.java:294) at org.apache.http.impl.conn.DefaultClientConnection.receiveResponseHeader(DefaultClientConnection.java:257) at org.apache.http.impl.conn.ManagedClientConnectionImpl.receiveResponseHeader(ManagedClientConnectionImpl.java:207) at org.apache.http.protocol.HttpRequestExecutor.doReceiveResponse(HttpRequestExecutor.java:273) at org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.java:125) at org.apache.http.impl.client.DefaultRequestDirector.tryExecute(DefaultRequestDirector.java:679) at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:481) at org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:835) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:108) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56) at com.snaplogic.util.HttpUtils.executeRequest(HttpUtils.java:67) at com.snaplogic.common.url.protocol.sldb.SldbUrlConnection.getSlfsFile(SldbUrlConnection.java:449) at com.snaplogic.common.url.protocol.sldb.SldbUrlConnection.lambda$getInputStream$2(SldbUrlConnection.java:438) at com.snaplogic.common.url.protocol.sldb.SldbUrlConnection$$Lambda$176/718525149.call(Unknown Source) at net.jodah.failsafe.SyncFailsafe.call(SyncFailsafe.java:145) at net.jodah.failsafe.SyncFailsafe.get(SyncFailsafe.java:56) at com.snaplogic.common.url.protocol.sldb.SldbUrlConnection.doRequest(SldbUrlConnection.java:545) at com.snaplogic.common.url.protocol.sldb.SldbUrlConnection.getInputStream(SldbUrlConnection.java:427) at java.net.URL.openStream(URL.java:1045) at com.snaplogic.scripting.language.ScriptExecutorImpl.getScriptInputStream(ScriptExecutorImpl.java:149) at com.snaplogic.scripting.language.ScriptExecutorImpl.loadHookFor(ScriptExecutorImpl.java:85) at com.snaplogic.snaps.script.BinaryExecuteScript.createScriptHookFor(BinaryExecuteScript.java:146) at com.snaplogic.snaps.script.CommonExecute.execute(CommonExecute.java:121) at com.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:768) at com.snaplogic.cc.snap.common.SnapRunnableImpl.execute(SnapRunnableImpl.java:550) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:834) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:400) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:116) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Error Fingerprint[0] = efp:java.net._gJ9MJ0I4.8KViews0likes3Commentssnap.out.totalCount variable
Hi, I’m trying to use two counters snap.in.totalCount, snap.out.totalCount to compare the total record count before the snap parsed and after parsed like to catch if the count is differ.The above variable gives running counter document like 1,2,3… but i need the variable value “20” records if it has 20 records to use in router for writing the different files. Like if $in == $out output0 else output1. can you suggest how can i attain this.6.2KViews0likes3Comments
Groups
Higher Ed Users Group
This user group is for customers within higher education.0 Posts
