1

I am using StreamSets to build a pipeline to land data from a table that sits in a sqlserver db to a table on postgres db. 

JDBC Query Consumer  --> Timestamp --> JDBC Producer

The pipeline passes validation checks and runs successfully on preview mode. However, the problem is that the data does not land into the postgres table. I have checked the connection string and credentials and these should be right.

This is the error it throws in the logs.

No parameters found for record with YY SELECT 'XX' AS fieldA, YY AS fieldB, ZZ AS fieldC::rowCount:#; skipping

How can I resolve this issue?

jarlh
  • 42,561
  • 8
  • 45
  • 63
Shoaib Maroof
  • 369
  • 1
  • 3
  • 13

1 Answers1

1

'No parameters found' means that there were no fields on the record that could be mapped to database columns. Check your field-to-column mappings. If they look correct, it might be a problem with case. Try enabling Enclose Object Names on the JDBC tab.

metadaddy
  • 4,234
  • 1
  • 22
  • 46