Custom Views
Whenever I try to save a custom view I get an error .. It had worked up until today.. nothing has been changed on the server..
once this error occurs, the view no longer appears in the drop down menu in the requests view
once this error occurs, the view no longer appears in the drop down menu in the requests view
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 mmInfo 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:90) 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 mmInfo 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:6380) com.adventnet.servicedesk.workorder.action.CustomFilterAction.createCVSQL(CustomFilterAction.java:1180) com.adventnet.servicedesk.workorder.action.CustomFilterAction.execute(CustomFilterAction.java:192) 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:90) 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.