Creating Custom Request View causes Tomcat Error
Hey Hey,
Whenever I try to create a new Custom Request View, I receive the following error from Tomcat:
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: Invalid Table alias prod specified
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:112)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
root cause
java.lang.IllegalArgumentException: Invalid Table alias prod specified
com.adventnet.ds.query.util.QueryUtil.getTable(QueryUtil.java:873)
com.adventnet.ds.query.util.QueryUtil.setDataType(QueryUtil.java:836)
com.adventnet.db.api.RelationalAPI.setDataType(RelationalAPI.java:915)
com.adventnet.db.api.RelationalAPI.getSelectSQL(RelationalAPI.java:290)
com.adventnet.servicedesk.reports.utils.CoreReportDesigner.getQuery(CoreReportDesigner.java:6128)
com.adventnet.servicedesk.filter.action.CustomFilterAction.createCVSQL(CustomFilterAction.java:1108)
com.adventnet.servicedesk.filter.action.CustomFilterAction.execute(CustomFilterAction.java:216)
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:112)
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.
Apache Tomcat/5.0.28
Any help would be appreciated.
New to ADSelfService Plus?