Who is this article for?

All On-Premise Ideagen Quality Management Admins and IT staff with appropriate permissions.

Ideagen Quality Management site and Web Server accessis needed.

Customers may encounter issues with their ODBC connection for external list fields after a server move. 

To make troubleshooting this issue easier to learn, this article is split into three sections so that you can either walk through the steps in sequence or you can jump to the section relevant to what you are finding:

1. Issue Experienced
2. Resolution
3. Further Reading

1. Issue Experienced

This section will explain what occurs when the customer is experiencing the issue.

The customer will have noticed the workflow with the external list field is not updating after a server move. An error like the following will be logged:

Exception type: System.Exception Exception message: Error(s) in workflow validation:    Error: At least one list field does not have any possible values defined.                          Exception stack trace: at Ideagen Quality Management.Core.Workflows.WorkflowDefinition.PutOnLine(ITerms termsObject, List`1& returnFixes)                                                                                        2/18/2021 5:44:22 PM Exception type: System.Data.Odbc.OdbcException                    Exception message: ERROR [42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The SELECT permission was denied on the object 'PositionList', database 'Qual-Lists', schema 'dbo'.                                                                                                                          Exception stack trace: at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at Ideagen Quality Management.Core.CustomFields.ListCustomField.get_FieldValues()                                        2/18/2021 5:44:24 PM

2. Resolution 

This section will provide the resolution for external source field problems.

1. Check the ODBC connection on the web server and make sure all settings are still correct. 
2. Check the security on the root Ideagen Quality Management folder and the subfolders. 
3. The path is normally C:\Program Files\Ideagen Quality Management but can be installed on another drive. 
4. If the IIS Application Pool account for Ideagen Quality Management is missing, it will need to be reapplied. 
5. Follow the instructions in this article to apply security correctly. 

3. Further Reading

This section will provide important links to further troubleshooting and resources. 

1. External Link - information around the enumeration error when applying security to subfolders.