Symptom:

When running analysis in Ultimate Survey Enterprise survey software via your web browser, an error is thrown that looks similar to the following:

Server Error in '/UltimateSurvey' Application.

-----------------------------------------------------------

Syntax error: Missing operand after 'In' operator.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SyntaxErrorException: Syntax error: Missing operand after 'In' operator.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SyntaxErrorException: Syntax error: Missing operand after 'In' operator.]

System.Data.ExpressionParser.Parse() +2811

System.Data.DataExpression..ctor(String expression, DataTable table, Type type) +149

System.Data.Select..ctor(DataTable table, String filterExpression, String sort, DataViewRowState recordStates) +76

System.Data.DataTable.Select(String filterExpression) +36

Prezza.Response.Filter.FilterManager.FilterDataSet(String answerFilter, DataSet currentData, Boolean reverseSelection) +272

Prezza.Response.Filter.FilterManager.FilterResponses(DataSet responseData, FilterCollection filters) +589

Prezza.Analysis.Items.SummaryItem.Run(DataSet responseMetaData) +191

Prezza.Analysis.Analysis.Run(Int32 firstItemIndex, Int32 lastItemIndex) +339

UltimateSurvey.Analysis.RunAnalysis.RenderAnalysis(Int32 startIndex, Int32 endIndex) +566

UltimateSurvey.Analysis.RunAnalysis.Page_Load(Object sender, EventArgs e) +881

System.Web.UI.Control.OnLoad(EventArgs e) +67

System.Web.UI.Control.LoadRecursive() +35

System.Web.UI.Page.ProcessRequestMain() +750

Cause:

You have set multiple filters on one or more analysis items in Ultimate Survey that are based upon the same question. For example, you set filters to only see responses where a user answered "Yes" AND "No" to the same question.

Resolution:

Do not add multiple filters to an analysis item, based off of the response to the same question.

In the next version of Ultimate Survey Enterprise .NET Edition, you will not be able to set up these problematic filter sets.