BarTender Integration returns “No Records Found” but Print Preview shows correct SQL results

Jayden Forrest

• 2026年04月13日 15:34

Hi,

I’m having an issue with a BarTender label through Integration Builder.

I’ve tested:

• direct connection to the SQL server
• extracted CSV file

Both give the same result: “No Records Found”

Version:
BarTender Designer 2022 R5 11.3/197999 (64-bit)

What’s odd is that in Print Preview the correct result comes through from the join, but when it runs through the integration it returns “No Records Found”.

I am joining on an address on the .txt label file to another address in the SQL database and returning a separate field.

The integration user has select access, and it’s the same user the integration is using, so permissions should be okay. The same user can also access the CSV file. I have also tried storing the separate credentials with the label file too.

I’ve also tried spacing out the characters in case the incoming value was the problem.

Could the label file .txt values get altered during the integration, so it no longer matches the SQL/CSV data?

Modifying the .txt file in anyway makes it garbled by the integration and there is nothing useful in the logs

Thanks

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 2026年04月27日 15:46

  How is the connection to the SQL configured? The “user” that runs the Integration is by default the Local System Account and so if you are using the access rights of the user than that could be the issue.  

  1

サインインしてコメントを残してください。