The users are both pointed to the correct Integration Manager database however, one user is able to run the integration without error and the other one received the error
ERROR: Unable to open source queries because Query 'XXX' is not found in the database. – ADO Field is nothing
It is an Advanced ODBC source and there is a SQL query involved. It is a Terminal Server. Could this possibly be a permissions error? If so, what should we check?
Thanks!
*This post is locked for comments
This sure does sound like it could be SQL permissions causing this issue. If other users are able to run the same integration successfully I would look into what the difference is in SQL between the users.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (