Error creating report:

Dear All,

While I'm creating custom report it show this error message. how can I rectify this?

John

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: 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 '4,32,50,49,7)) AND (BINARY RDTDefinition.TYPE_NAME IN ('java.lang.Integer','java' 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.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:66)
com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:100)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)

root cause

com.adventnet.persistence.DataAccessException: 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 '4,32,50,49,7)) AND (BINARY RDTDefinition.TYPE_NAME IN ('java.lang.Integer','java' at line 1"
com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:102)
com.adventnet.persistence.DataAccess.get(DataAccess.java:1153)
com.adventnet.persistence.DataAccess.get(DataAccess.java:1143)
com.adventnet.persistence.ejb.interceptor.CorePersistenceInterceptor.process(CorePersistenceInterceptor.java:110)
com.adventnet.authorization.AuthorizationInterceptor.process(AuthorizationInterceptor.java:232)
com.adventnet.persistence.ejb.interceptor.NotificationPersistenceInterceptor.process(NotificationPersistenceInterceptor.java:148)
com.adventnet.cis.ejb.CISPersistenceInterceptor.process(CISPersistenceInterceptor.java:59)
com.adventnet.persistence.ejb.PersistenceBean.get(PersistenceBean.java:259)
sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
com.adventnet.authorization.AuthorizationInterceptor.invoke(AuthorizationInterceptor.java:88)
com.adventnet.authentication.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:108)
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
org.jboss.ejb.Container.invoke(Container.java:709)
sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97)
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
com.adventnet.authentication.interceptor.ClientPrincipalAssociator.invoke(ClientPrincipalAssociator.java:47)
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
com.adventnet.persistence.ejb.interceptor.ConstructDOProxyInterceptor.invoke(ConstructDOProxyInterceptor.java:37)
org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
$Proxy65.get(Unknown Source)
com.adventnet.servicedesk.helpdesk.reports.utils.CustomReportDesigner.getColumnDetails(CustomReportDesigner.java:1470)
com.adventnet.servicedesk.reports.helpdesk.action.CustomReportHandler.execute(CustomReportHandler.java:247)
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.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:66)
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.