BarTender Integration returns “No Records Found” but Print Preview shows correct SQL results
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
Please sign in to leave a comment.
Comments
0 comments