Unable to get all records from mysql database in Generic JDBC execute or Select snap
Hello, I am seeing a different behavior in Generic JDBC execute or Select snap when it has upstream and downstream. I have a table with 10000 records and the query used in both snaps is "select * from . where pipl id =‘1’ " and this query is giving same count in mysql and when the snap(execute,select) is not having any input/output connected but if there is a input/output, i am not getting same count in output and the record count is not consistent. Sometimes i get 10,20 … but not 10000. Tried all troubleshooting steps like clearing cache, re deploying snap, restarting snap plex… but no luck. Snap version - com-snaplogic-snaps-jdbc-execute-1-main19844 Did anyone face this issue? Appreciate any solution here. Thank you in advance. Harish
Input not completely consumed
I have a parent pipeline calling another. Which runs successfully when you validate but errors when you execute. Why is this? It seems that the issue is coming form a pyton script in the child pipeline. The purpose of the script is the call a bat.file on a server and wait for the .bat file to complete and return the error message if any before the pipleline completes. If i validate the parent pipeline it calls the child pipeline and execute this script without issues but this is not the case when i execute. I am either getting an error saying on the script snap “Input not completely consumed” or other times “root pipeline no longer running” the following is the script code Import the interface required by the Script snap. from com.snaplogic.scripting.language import ScriptHook import java.util, os, subprocess class TransformScript(ScriptHook): def init(self, input, output, error, log): self.input = input self.output = output self.error = error self.log = log # The "execute()" method is called once when the pipeline is started # and allowed to process its inputs or just send data to its outputs. def execute(self): filepath="C:\\Profisee\\ProfiseeMatch.bat & exit" p = subprocess.Popen(filepath, shell=True, stdout = subprocess.PIPE) p.communicate() p.wait() self.output.write (p.returncode) The Script Snap will look for a ScriptHook object in the “hook” variable. The snap will then call the hook’s “execute” method. hook = TransformScript(input, output, error, log) Any ideas what may be causing this and how this can be solved?