I’m getting “An open operation on table DRM_User_Favorites_VIEW failed accessing SQL data” error message when trying to print a report. The ANSI settings in the ODBC DSN connection are marked and they will need to be unmarked.
Recommendation:
1. Check your DSN connection you are using for Great Plains.
2. Unmark the ANSI settings.
3. Exit Great Plains
4. Log back into Great Plains and use DRM to print the report again
NOTE: Your DSN has to be set up per GP specifications or you will get this error message.