Snaplogic SQLServer Insert Snap
Hi the snaplogic insert snap is throwing error when a trigger task is invoked and the FileId is coming as the parameter.
The error is below
java.sql.BatchUpdateException: Invalid column name ‘Fil...
Forum Discussion
I am not sure what is going on in the pipeline since I cannot see it. But based on the error message, I can say that the target table of insert which happens to be the foreign table (since it has FileId has the foreign key) does not seem to have the column “FileId”.
The reason your json generator might be working is that it is not passing the column name explicitly in the insert statement. Normally databases allow default values to be inserted into column if a positional values insert syntax is used rather an parameterized values construct based insert statement (if value is not specified) in which case it will not look for the column name, but based on the position, it will add a default value which may be null or whatever value is specified.
If you can send sql statement, I can take a look.
