Build 7014 loses attachments
Adventnet:
After migrating from 7011 to 7014 we have found that tickets that have attachments that were included in subsequent emails (ie: the attachments in question were not in the original request) we are not able to pull up the subsequent attachments. When we do we get an Apache/Tomcat 5.0.28 error as follows:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: No rows found for the table SDeskAttachment in this DataObject
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.workorder.FileDownload_jsp._jspService(FileDownload_jsp.java:187)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:92)
com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:112)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
root cause
com.adventnet.persistence.DataAccessException: No rows found for the table SDeskAttachment in this DataObject
com.adventnet.persistence.WritableDataObject.getFirstRow(WritableDataObject.java:632)
com.adventnet.persistence.WritableDataObject.getFirstValue(WritableDataObject.java:838)
org.apache.jsp.workorder.FileDownload_jsp._jspService(FileDownload_jsp.java:109)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:92)
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.
Please advise.
After migrating from 7011 to 7014 we have found that tickets that have attachments that were included in subsequent emails (ie: the attachments in question were not in the original request) we are not able to pull up the subsequent attachments. When we do we get an Apache/Tomcat 5.0.28 error as follows:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: No rows found for the table SDeskAttachment in this DataObject
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.workorder.FileDownload_jsp._jspService(FileDownload_jsp.java:187)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:92)
com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:112)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
root cause
com.adventnet.persistence.DataAccessException: No rows found for the table SDeskAttachment in this DataObject
com.adventnet.persistence.WritableDataObject.getFirstRow(WritableDataObject.java:632)
com.adventnet.persistence.WritableDataObject.getFirstValue(WritableDataObject.java:838)
org.apache.jsp.workorder.FileDownload_jsp._jspService(FileDownload_jsp.java:109)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:92)
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.
Please advise.