Forum Discussion

feenst's avatar
feenst
New Contributor III
9 years ago

Error when reading from SQLMX database via JDBC connector

I am working on a pipeline to pull data from a SQL Server database and insert into a SQLMX database. I got this pipeline working, but it fails after the first run as it’s trying to insert records t...
feenst's avatar
feenst
New Contributor III
9 years ago

Thanks @akidave for the tip on the output view. That worked in this scenario.
However, I don’t have any of the “limit” fields included in my UI so I’m not sure why the limit clause would be included in the query.

akidave's avatar
akidave
Employee
9 years ago

Did you get the LIMIT error during pipeline save? The preview data generation automatically adds a LIMIT to the SQL query in the SELECT snap. The LIMIT is not added during pipeline execution.