Cannot Delete Custom Report

Post subject: Cant delete custom report by "wchung " on Thu May 03, 2007 states an error while deleting a custom report, I'm having the exact same trouble.

Below is the error , please help

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: SQLException occured while retrieving candidate rows from the master table Filters
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
com.adventnet.sa.jsp.WEB_002dINF.jsp.deleteReport_jsp._jspService(deleteReport_jsp.java:151)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
org.apache.struts.action.RequestProcessor.internalModuleRelativeForward(RequestProcessor.java:1012)
org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:345)
org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:582)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:260)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

root cause

com.adventnet.persistence.DataAccessException: SQLException occured while retrieving candidate rows from the master table Filters
com.adventnet.persistence.DeleteUtil.loadCandidateMasterRows(DeleteUtil.java:685)
com.adventnet.persistence.DeleteUtil.fetchRows(DeleteUtil.java:489)
com.adventnet.persistence.DeleteUtil.fetchRowsForSlave(DeleteUtil.java:803)
com.adventnet.persistence.DeleteUtil.fetchRows(DeleteUtil.java:548)
com.adventnet.persistence.DeleteUtil.deleteData(DeleteUtil.java:343)
com.adventnet.persistence.DeleteUtil.delete(DeleteUtil.java:149)
com.adventnet.persistence.DataAccess.delete(DataAccess.java:841)
com.adventnet.persistence.DataAccess.delete(DataAccess.java:832)
com.adventnet.sa.jsp.WEB_002dINF.jsp.deleteReport_jsp._jspService(deleteReport_jsp.java:93)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
org.apache.struts.action.RequestProcessor.internalModuleRelativeForward(RequestProcessor.java:1012)
org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:345)
org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:582)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:260)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

--------------------------------------------------------------------------------

Apache Tomcat/5.0.28