ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 172334

calendar_today

Updated On:

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)

Cause

Product defect.

Environment

Workflow 8.1
ServiceDesk 8.1

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 (-).