When trying to group a report based on SQL query by a column where title contains a space, grouping fails.

Products

Workflow Solution ServiceDesk

Issue/Introduction

When trying to group a report based on SQL query (both with and without parameters) by a column where title contains a space, grouping fails. For example a column titled 'SLA CASE' or 'Case Status'.

This only occurs with reports based on SQL query but does not occur with normal reports.

Application Name : ProcessManager

Log Level :Error

Log Category :global_asax

Message : 

Application 'LogicBase.Ensemble' error

Client: IP=xxx.xxx.xxx.xxx HostName=xxx.xxx.xxx.xxx Browser=xxx

System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Data.SyntaxErrorException: Syntax error: Missing operand after 'CASE' operator.

   at System.Data.ExpressionParser.Parse()

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

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

   at System.Data.DataTable.Select(String filterExpression)

   at LogicBase.Ensemble.Controls.Views.ReportViewRenderer.RowDataBoundEventHandler(GridViewRow row, String panelName, String innerGridName, Int32 groupByLevel, String imageButtonIDName, Int32 tableNumber, GridViewRowEventHandler rowDataBoundEventHandler, String[] childControlNames)

   at LogicBase.Ensemble.Controls.Views.ReportViewRenderer.reportsGridView_RowDataBound(Object sender, GridViewRowEventArgs e)

   at System.Web.UI.WebControls.GridView.OnRowDataBound(GridViewRowEventArgs e)

   at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)

   at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)

   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)

   at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)

   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)

   at LogicBase.Ensemble.Controls.Views.ReportViewRenderer.SetDataSource(DataSet data)

   at LogicBase.Ensemble.Controls.Views.ViewGrid.FillDataSet()

   at LogicBase.Ensemble.Controls.Views.ViewGrid.OnPreRender(EventArgs e)

   at System.Web.UI.Control.PreRenderRecursiveInternal()

   at System.Web.UI.Control.PreRenderRecursiveInternal()

   at System.Web.UI.Control.PreRenderRecursiveInternal()

   at System.Web.UI.Control.PreRenderRecursiveInternal()

   at System.Web.UI.Control.PreRenderRecursiveInternal()

   at System.Web.UI.Control.PreRenderRecursiveInternal()

   at System.Web.UI.Control.PreRenderRecursiveInternal()

   at System.Web.UI.Control.PreRenderRecursiveInternal()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

   at System.Web.UI.Page.HandleError(Exception e)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

   at System.Web.UI.Page.ProcessRequest()

   at System.Web.UI.Page.ProcessRequest(HttpContext context)

   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)

   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Environment

Workflow 8.1
ServiceDesk 8.1

Cause

Product defect.

Resolution

This issue has been reported to Symantec Engineering and will be addressed in a future version.

Workaround:

Avoid using space in the column title. If desired or needed use underscore (_) or dash (-).