Opened 9 years ago

Closed 9 years ago

#784 closed defect (fixed)

Can't create new histology work list

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: critical Milestone: Reggie v3.3.3
Component: net.sf.basedb.reggie Keywords:
Cc:

Description

Start the "Lab tracking protocol for FFPE/HE" wizard and click the "Create new work list" button. A big red error error message appears:

Error: could not resolve property: bioMaterialLists of:
net.sf.basedb.core.data.SampleData 
[SELECT smp FROM net.sf.basedb.core.data.SampleData smp 
INNER JOIN FETCH smp.creationEvent ce  
LEFT JOIN FETCH smp.bioWell bw  
LEFT JOIN FETCH bw.bioPlate bp  
WHERE (smp.itemSubtype.id = 49) AND (ce.eventDate IS NULL) 
AND (smp <> ALL (SELECT smp FROM net.sf.basedb.core.data.SampleData smp 
INNER JOIN smp.bioMaterialLists lst  
WHERE ((lst.externalId = :P9add1f83a026c9cfe99067e10aca1464) 
AND (lst.removed = false)))) 
ORDER BY coalesce(bp.name, 'zzzz') ASC, bw.row ASC, bw.column ASC, smp.id ASC]
Wizard</internal.asyncCallbackWrapper@http://127.0.0.1:9080/3.5-stable/extensions/reggie.jar/reggie-2.js?v=3.4-dev:968:13

And a stacktrace in the error log:

net.sf.basedb.core.BaseException: could not resolve property: bioMaterialLists of: net.sf.basedb.core.data.SampleData [SELECT smp FROM net.sf.basedb.core.data.SampleData smp INNER JOIN FETCH smp.creationEvent ce  LEFT JOIN FETCH smp.bioWell bw  LEFT JOIN FETCH bw.bioPlate bp  WHERE (smp.itemSubtype.id = 49) AND (ce.eventDate IS NULL) AND (smp <> ALL (SELECT smp FROM net.sf.basedb.core.data.SampleData smp INNER JOIN smp.bioMaterialLists lst  WHERE ((lst.externalId = :P9add1f83a026c9cfe99067e10aca1464) AND (lst.removed = false)))) ORDER BY coalesce(bp.name, 'zzzz') ASC, bw.row ASC, bw.column ASC, smp.id ASC]
	at net.sf.basedb.core.HibernateUtil.createQuery(HibernateUtil.java:1693)
	at net.sf.basedb.core.AbstractHqlQuery.getMainHqlQuery(AbstractHqlQuery.java:240)
	at net.sf.basedb.core.ItemQuery.list(ItemQuery.java:92)
	at net.sf.basedb.reggie.dao.Histology.findUnembeddedHistologyItems(Histology.java:90)
	at net.sf.basedb.reggie.servlet.HistologyServlet.doGet(HistologyServlet.java:127)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:618)

Change History (3)

comment:1 by Nicklas Nordborg, 9 years ago

Seems like the fixes in #750 that should take care of the BioMaterialList to ItemList change in BASE 3.5 didn't fix all places.

comment:2 by Nicklas Nordborg, 9 years ago

Milestone: Reggie v3.xReggie v3.3.3
Status: newassigned

comment:3 by Nicklas Nordborg, 9 years ago

Resolution: fixed
Status: assignedclosed

(In [3339]) Fixes #784: Can't create new histology work list

The query for selecting histology items needed quite a bit of re-work. It would have been useful to have something in the BASE API to filter on item list membership but it seems like it is missing...

Note: See TracTickets for help on using tickets.