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...
akidave's avatar
akidave
Employee
9 years ago

SQL/MX does not seem to support the LIMIT clause. You can use the Generic JDBC Execute snap, add an output view to be able to link it to downstream snaps.

  • 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.