Adding a view fails
Hi
Has anyone run into the following error when adding a view to SC, I pick a condition with support rep as a requirement for requests, but adding the view fails, if anyone has seen this and knows what it is a reply would be greatly appriciated, otherwise I'll have to take it up with support, my level is build 7511.
Kind Regards
Stefan Thor Hreinsson
type Exception report
Has anyone run into the following error when adding a view to SC, I pick a condition with support rep as a requirement for requests, but adding the view fails, if anyone has seen this and knows what it is a reply would be greatly appriciated, otherwise I'll have to take it up with support, my level is build 7511.
Kind Regards
Stefan Thor Hreinsson
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 rc 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 rc 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:6386)
com.adventnet.servicedesk.filter.action.CustomFilterAction.createCVSQL(CustomFilterAction.java:1408)
com.adventnet.servicedesk.filter.action.CustomFilterAction.execute(CustomFilterAction.java:224)
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)