summary reports

I get the following error when trying to "Requests received summary by date by technician". We have upgraded to 5003.

HTTP Status 500 -

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

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Korn, David - IS' GROUP BY DT' at line 1"
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:72)
com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:100)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)

root cause

java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Korn, David - IS' GROUP BY DT' at line 1"
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1902)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1106)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1200)
com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1161)
com.mysql.jdbc.Connection.execSQL(Connection.java:2084)
com.mysql.jdbc.Connection.execSQL(Connection.java:2034)
com.mysql.jdbc.Statement.executeQuery(Statement.java:1153)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:250)
com.adventnet.servicedesk.utils.DBUtilities.getResultAsHashtable(DBUtilities.java:658)
com.adventnet.servicedesk.reports.helpdesk.action.RequestSummaryAction.getRequiredNumbers(RequestSummaryAction.java:172)
com.adventnet.servicedesk.reports.helpdesk.action.RequestSummaryAction.getReportData(RequestSummaryAction.java:140)
com.adventnet.servicedesk.reports.helpdesk.action.RequestSummaryAction.execute(RequestSummaryAction.java:65)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:72)
com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:100)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.