Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) ERROR: Unable to open ...

ERROR: Unable to open source queries because Query 'XXX' is not found in the database. – ADO Field is nothing

(0) Share

Report

Posted on by Community Member

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

All responses (1)

Answers (0)

Jonathan Fear on at

Like (0)

Report

RE: ERROR: Unable to open source queries because Query 'XXX' is not found in the database. – ADO Field is nothing

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.