ERROR: Incorrect syntax near xxx when a user logs into GoldMine and a filter is shown as active even though the user has no filters.

Version 1

    Details

    ERROR: Incorrect syntax near xxx  when a user logs into GoldMine and a filter is shown as active even though the user has no filters. (where X can be any number of items such as a filter name, symbol, or SQL word such as join) -


    Resolution

    1. There is a filter active upon login, which should not be possible. 2. Search the list of filters and saved SQL queries for the name of the filter that is active.  3. Deleted the saved Query. 4. You should now able to log in as the user without errors and the SQL Query should not active at login.