History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: XPR-93
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Critical Critical
Assignee: Mateusz Prokopowicz
Reporter: Jacques Morel
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
xplanner

Search content will throw an exception on orphan note?

Created: 27/Aug/05 04:16 PM   Updated: 30/Nov/05 02:23 AM
Component/s: Model
Affects Version/s: 0.7
Fix Version/s: 0.7

Time Tracking:
Original Estimate: 12 hours
Original Estimate - 12 hours
Remaining Estimate: 12 hours
Remaining Estimate - 12 hours
Time Spent: Not Specified
Remaining Estimate - 12 hours

Database: staging site http://apdbuild3/xplanner_0.7b2


 Description  « Hide
Searching for 'test' we get this exception even in production or staging
javax.servlet.ServletException: net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: 92199, of class: com.technoetic.xplanner.file.File
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.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.technoetic.xplanner.filters.RequestCharacterEncodingFilter.doFilter(RequestCharacterEncodingFilter.java:37)
com.technoetic.xplanner.security.filter.AbstractSecurityFilter.doFilter(AbstractSecurityFilter.java:51)
com.technoetic.xplanner.filters.ServletRequestFilter.doFilter(ServletRequestFilter.java:24)
com.technoetic.xplanner.db.hibernate.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:62)

the note is attached to task http://apdbuild3/xplanner_0.7b2/do/view/task?oid=91627 and it gets an exception trying to display the notes. In production we get the wrong message (cannot perform the action!!!)

Time Log:

Start Time End Time Reported Date Dur. Pair
2005-03-10 0.5 Angela Stanley
Edit | Delete | Move/Continue | Edit Time |
Export | History | Print [ServletException in:/WEB-INF/jsp/layout/viewLayout.jsp] net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: 92199, of class: com.technoetic.xplanner.file.File'

Both exception (search and note display ) should be hardened to not throw exception but handle this gracefully.
In addition we have the wrong message when we get the exception: (cannot perform the action).


 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Guili Sun - 12/Sep/05 03:03 PM
This problem occurred due to missing data in the database. It will be fixed after the database is cleaned up.

Jacques Morel - 05/Oct/05 09:01 PM
Must have a clean up utility to remove orphan files and null out attachment_id of notes that are pointing to deleted files