# select obj, minIndex(ws), maxIndex(ws)  from Plate as obj join fetch obj.wells wells left outer join fetch wells.wellSamples ws where obj.id in (:ids) group by obj.id


2017-01-23 16:50:16,095 INFO  [ome.services.sessions.state.SessionCache] (2-thread-5) Synchronizing session cache. Count = 4
2017-01-23 16:50:16,095 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Executor.doWork -- ome.services.sessions.SessionManagerImpl.reload[5e9cdf94-4184-40ee-a3da-9c5693f55812]
2017-01-23 16:50:16,095 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Args:	[null, InternalSF@33779587]
2017-01-23 16:50:16,108 INFO  [         ome.security.basic.EventHandler] (2-thread-5)  Auth:	user=0,group=0,event=null(Sessions),sess=d30fd532-ae16-47a0-a3cc-5dbb3a9b3a91
2017-01-23 16:50:16,116 INFO  [                 org.perf4j.TimingLogger] (2-thread-5) start[1485190216095] time[20] tag[omero.call.success.ome.services.sessions.SessionManagerImpl$6.doWork]
2017-01-23 16:50:16,116 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Rslt:	(ome.model.meta.Experimenter:Id_0, ome.model.meta.ExperimenterGroup:Id_5, (5, 1, 4, ... 4 more), ... 4 more)
2017-01-23 16:50:16,116 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Executor.doWork -- ome.services.sessions.SessionManagerImpl.reload[d30fd532-ae16-47a0-a3cc-5dbb3a9b3a91]
2017-01-23 16:50:16,116 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Args:	[null, InternalSF@33779587]
2017-01-23 16:50:16,117 INFO  [         ome.security.basic.EventHandler] (2-thread-5)  Auth:	user=0,group=0,event=null(Sessions),sess=d30fd532-ae16-47a0-a3cc-5dbb3a9b3a91
2017-01-23 16:50:16,121 INFO  [                 org.perf4j.TimingLogger] (2-thread-5) start[1485190216116] time[4] tag[omero.call.success.ome.services.sessions.SessionManagerImpl$6.doWork]
2017-01-23 16:50:16,121 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Rslt:	(ome.model.meta.Experimenter:Id_0, ome.model.meta.ExperimenterGroup:Id_0, (5, 1, 4, ... 4 more), ... 4 more)
2017-01-23 16:50:16,121 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Executor.doWork -- ome.services.sessions.SessionManagerImpl.reload[d7a45350-3746-461e-bfdb-05b8d40c37b9]
2017-01-23 16:50:16,121 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Args:	[null, InternalSF@33779587]
2017-01-23 16:50:16,121 INFO  [         ome.security.basic.EventHandler] (2-thread-5)  Auth:	user=0,group=0,event=null(Sessions),sess=d30fd532-ae16-47a0-a3cc-5dbb3a9b3a91
2017-01-23 16:50:16,125 INFO  [                 org.perf4j.TimingLogger] (2-thread-5) start[1485190216121] time[4] tag[omero.call.success.ome.services.sessions.SessionManagerImpl$6.doWork]
2017-01-23 16:50:16,125 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Rslt:	(ome.model.meta.Experimenter:Id_3, ome.model.meta.ExperimenterGroup:Id_5, (5, 1, 4, ... 5 more), ... 4 more)
2017-01-23 16:50:16,125 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Executor.doWork -- ome.services.sessions.SessionManagerImpl.reload[e13b7a2f-8770-437c-b212-354bf8a9f573]
2017-01-23 16:50:16,125 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Args:	[null, InternalSF@33779587]
2017-01-23 16:50:16,126 INFO  [         ome.security.basic.EventHandler] (2-thread-5)  Auth:	user=0,group=0,event=null(Sessions),sess=d30fd532-ae16-47a0-a3cc-5dbb3a9b3a91
2017-01-23 16:50:16,130 INFO  [                 org.perf4j.TimingLogger] (2-thread-5) start[1485190216125] time[4] tag[omero.call.success.ome.services.sessions.SessionManagerImpl$6.doWork]
2017-01-23 16:50:16,130 INFO  [        ome.services.util.ServiceHandler] (2-thread-5)  Rslt:	(ome.model.meta.Experimenter:Id_0, ome.model.meta.ExperimenterGroup:Id_5, (5, 1, 4, ... 4 more), ... 4 more)
2017-01-23 16:50:16,130 INFO  [                 org.perf4j.TimingLogger] (2-thread-5) start[1485190216095] time[34] tag[omero.sessions.synchronization]
2017-01-23 16:50:16,130 INFO  [ome.services.sessions.state.SessionCache] (2-thread-5) Synchronization took 34 ms.
2017-01-23 16:50:18,627 INFO  [ ome.services.blitz.fire.SessionManagerI] (.Server-88) Found session locally: d7a45350-3746-461e-bfdb-05b8d40c37b9
2017-01-23 16:50:18,628 INFO  [ ome.services.blitz.fire.SessionManagerI] (.Server-88) Rejoining session ServiceFactoryI(session-10f88724-f71d-46b6-bd83-c35afe17db3c/d7a45350-3746-461e-bfdb-05b8d40c37b9) (agent=OMERO.webapi)
2017-01-23 16:50:18,631 INFO  [                      omero.cmd.SessionI] (.Server-84) Added servant to adapter: d7a45350-3746-461e-bfdb-05b8d40c37b9/10f88724-f71d-46b6-bd83-c35afe17db3comero.api.IQuery(omero.api._IQueryTie@4ced4278)
2017-01-23 16:50:18,632 INFO  [        ome.services.util.ServiceHandler] (.Server-88)  Meth:	interface ome.api.IQuery.projection
2017-01-23 16:50:18,632 INFO  [        ome.services.util.ServiceHandler] (.Server-88)  Args:	[select obj, minIndex(ws), maxIndex(ws)  from Plate as obj join fetch obj.wells wells left outer join, PARAMS:ids=ArrayList(1) ]
2017-01-23 16:50:18,633 INFO  [    ome.security.basic.BasicEventContext] (.Server-88)  cctx:	group=-1
2017-01-23 16:50:18,635 INFO  [         ome.security.basic.EventHandler] (.Server-88)  Auth:	user=3,group=-1,event=null(User),sess=d7a45350-3746-461e-bfdb-05b8d40c37b9
2017-01-23 16:50:18,637 INFO  [                 org.perf4j.TimingLogger] (.Server-88) start[1485190218632] time[5] tag[omero.call.exception]
2017-01-23 16:50:18,639 WARN  [        ome.services.util.ServiceHandler] (.Server-88) InvalidDataAccessResourceUsageException thrown.

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select plate0_.id as col_0_0_, min(wellsample2_.well_index) as col_1_0_, max(wellsample2_.well_index) as col_2_0_, wells1_.id as id143_1_, wellsample2_.id as id146_2_, plate0_.id as id109_0_, wells1_.id as id143_1_, wellsample2_.id as id146_2_, plate0_.columnNamingConvention as columnNa2_109_0_, plate0_.columns as columns109_0_, plate0_.defaultSample as defaultS4_109_0_, plate0_.description as descript5_109_0_, plate0_.creation_id as creation17_109_0_, plate0_.external_id as external18_109_0_, plate0_.group_id as group19_109_0_, plate0_.owner_id as owner20_109_0_, plate0_.permissions as permissi6_109_0_, plate0_.update_id as update21_109_0_, plate0_.externalIdentifier as external7_109_0_, plate0_.name as name109_0_, plate0_.rowNamingConvention as rowNamin9_109_0_, plate0_."rows" as rows10_109_0_, plate0_.status as status109_0_, plate0_.version as version109_0_, plate0_.wellOriginXUnit as wellOri13_109_0_, plate0_.wellOriginX as wellOri14_109_0_, plate0_.wellOriginYUnit as wellOri15_109_0_, plate0_.wellOriginY as wellOri16_109_0_, wells1_.alpha as alpha143_1_, wells1_.blue as blue143_1_, wells1_."column" as column4_143_1_, wells1_.creation_id as creation14_143_1_, wells1_.external_id as external15_143_1_, wells1_.group_id as group16_143_1_, wells1_.owner_id as owner17_143_1_, wells1_.permissions as permissi5_143_1_, wells1_.update_id as update18_143_1_, wells1_.externalDescription as external6_143_1_, wells1_.externalIdentifier as external7_143_1_, wells1_.green as green143_1_, wells1_.plate as plate143_1_, wells1_.red as red143_1_, wells1_."row" as row10_143_1_, wells1_.status as status143_1_, wells1_.type as type143_1_, wells1_.version as version143_1_, wells1_.plate as plate109_0__, wells1_.id as id0__, wellsample2_.creation_id as creation9_146_2_, wellsample2_.external_id as external10_146_2_, wellsample2_.group_id as group11_146_2_, wellsample2_.owner_id as owner12_146_2_, wellsample2_.permissions as permissi2_146_2_, wellsample2_.update_id as update13_146_2_, wellsample2_.image as image146_2_, wellsample2_.plateAcquisition as plateAc15_146_2_, wellsample2_.posXUnit as posXUnit146_2_, wellsample2_.posX as posX146_2_, wellsample2_.posYUnit as posYUnit146_2_, wellsample2_.posY as posY146_2_, wellsample2_.timepoint as timepoint146_2_, wellsample2_.version as version146_2_, wellsample2_.well as well146_2_, wellsample2_.well as well143_1__, wellsample2_.id as id1__, wellsample2_.well_index as well17_1__ from plate plate0_ inner join well wells1_ on plate0_.id=wells1_.plate and
(
  1 = ? OR
  1 = ? OR
  (wells1_.group_id in (?)) OR
  (wells1_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = wells1_.group_id)) OR
  (wells1_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = wells1_.group_id)) OR
  ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = wells1_.group_id))
) left outer join wellsample wellsample2_ on wells1_.id=wellsample2_.well and
(
  1 = ? OR
  1 = ? OR
  (wellsample2_.group_id in (?)) OR
  (wellsample2_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = wellsample2_.group_id)) OR
  (wellsample2_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = wellsample2_.group_id)) OR
  ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = wellsample2_.group_id))
) where
(
  1 = ? OR
  1 = ? OR
  (plate0_.group_id in (?)) OR
  (plate0_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = plate0_.group_id)) OR
  (plate0_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = plate0_.group_id)) OR
  ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = plate0_.group_id))
) and (plate0_.id in (?)) group by plate0_.id]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
	at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:629) ~[spring-orm.jar:3.0.1.RELEASE]
	at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) ~[spring-orm.jar:3.0.1.RELEASE]
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) ~[spring-orm.jar:3.0.1.RELEASE]
	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339) ~[spring-orm.jar:3.0.1.RELEASE]
	at ome.logic.QueryImpl.projection(QueryImpl.java:415) ~[server.jar:na]
	at sun.reflect.GeneratedMethodAccessor1012.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_65]
	at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_65]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) [spring-aop.jar:3.0.1.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop.jar:3.0.1.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop.jar:3.0.1.RELEASE]
	at ome.security.basic.EventHandler.invoke(EventHandler.java:154) ~[server.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE]
	at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) ~[spring-orm.jar:3.0.1.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108) ~[spring-tx.jar:3.0.1.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE]
	at ome.tools.hibernate.ProxyCleanupFilter$Interceptor.invoke(ProxyCleanupFilter.java:249) ~[server.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE]
	at ome.services.util.ServiceHandler.invoke(ServiceHandler.java:121) ~[server.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE]
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop.jar:3.0.1.RELEASE]
	at com.sun.proxy.$Proxy80.projection(Unknown Source) [na:na]
	at sun.reflect.GeneratedMethodAccessor1012.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_65]
	at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_65]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) [spring-aop.jar:3.0.1.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop.jar:3.0.1.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop.jar:3.0.1.RELEASE]
	at ome.security.basic.BasicSecurityWiring.invoke(BasicSecurityWiring.java:93) [server.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE]
	at ome.services.blitz.fire.AopContextInitializer.invoke(AopContextInitializer.java:43) [blitz.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE]
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop.jar:3.0.1.RELEASE]
	at com.sun.proxy.$Proxy80.projection(Unknown Source) [na:na]
	at sun.reflect.GeneratedMethodAccessor1090.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_65]
	at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_65]
	at ome.services.blitz.util.IceMethodInvoker.invoke(IceMethodInvoker.java:172) [blitz.jar:na]
	at ome.services.throttling.Callback.run(Callback.java:56) [blitz.jar:na]
	at ome.services.throttling.InThreadThrottlingStrategy.callInvokerWithMappedArgs(InThreadThrottlingStrategy.java:70) [blitz.jar:na]
	at ome.services.blitz.impl.AbstractAmdServant.callInvokerOnMappedArgs(AbstractAmdServant.java:149) [blitz.jar:na]
	at ome.services.blitz.impl.QueryI.projection_async(QueryI.java:122) [blitz.jar:na]
	at sun.reflect.GeneratedMethodAccessor1089.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_65]
	at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_65]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) [spring-aop.jar:3.0.1.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop.jar:3.0.1.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop.jar:3.0.1.RELEASE]
	at omero.cmd.CallContext.invoke(CallContext.java:78) [blitz.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE]
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop.jar:3.0.1.RELEASE]
	at com.sun.proxy.$Proxy81.projection_async(Unknown Source) [na:na]
	at omero.api._IQueryTie.projection_async(_IQueryTie.java:126) [blitz.jar:na]
	at omero.api._IQueryDisp.___projection(_IQueryDisp.java:601) [blitz.jar:na]
	at omero.api._IQueryDisp.__dispatch(_IQueryDisp.java:718) [blitz.jar:na]
	at IceInternal.Incoming.invoke(Incoming.java:222) [ice.jar:na]
	at Ice.ConnectionI.invokeAll(ConnectionI.java:2482) [ice.jar:na]
	at Ice.ConnectionI.dispatch(ConnectionI.java:1258) [ice.jar:na]
	at Ice.ConnectionI.message(ConnectionI.java:1213) [ice.jar:na]
	at IceInternal.ThreadPool.run(ThreadPool.java:321) [ice.jar:na]
	at IceInternal.ThreadPool.access$300(ThreadPool.java:12) [ice.jar:na]
	at IceInternal.ThreadPool$EventHandlerThread.run(ThreadPool.java:693) [ice.jar:na]
	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65]
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) ~[hibernate-core.jar:na]
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core.jar:na]
	at org.hibernate.loader.Loader.doList(Loader.java:2452) ~[hibernate-core.jar:na]
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192) ~[hibernate-core.jar:na]
	at org.hibernate.loader.Loader.list(Loader.java:2187) ~[hibernate-core.jar:na]
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) ~[hibernate-core.jar:na]
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) ~[hibernate-core.jar:na]
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) ~[hibernate-core.jar:na]
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1260) ~[hibernate-core.jar:na]
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) ~[hibernate-core.jar:na]
	at ome.services.query.Query.doInHibernate(Query.java:241) ~[server.jar:na]
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ~[spring-orm.jar:3.0.1.RELEASE]
	... 61 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: column "wells1_.id" must appear in the GROUP BY clause or be used in an aggregate function
  Position: 116
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) ~[postgresql.jar:9.4]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998) ~[postgresql.jar:9.4]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[postgresql.jar:9.4]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) ~[postgresql.jar:9.4]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) ~[postgresql.jar:9.4]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305) ~[postgresql.jar:9.4]
	at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_65]
	at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_65]
	at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64) ~[btm.jar:2.1.3]
	at com.sun.proxy.$Proxy8.executeQuery(Unknown Source) ~[na:na]
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate-core.jar:na]
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1869) ~[hibernate-core.jar:na]
	at org.hibernate.loader.Loader.doQuery(Loader.java:718) ~[hibernate-core.jar:na]
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270) ~[hibernate-core.jar:na]
	at org.hibernate.loader.Loader.doList(Loader.java:2449) ~[hibernate-core.jar:na]
	... 70 common frames omitted
2017-01-23 16:50:18,639 INFO  [        ome.services.util.ServiceHandler] (.Server-88)  Excp:	org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select plate0_.id as col_0_0_, min(wellsample2_.well_index) as col_1_0_, max(wellsample2_.well_index) as col_2_0_, wells1_.id as id143_1_, wellsample2_.id as id146_2_, plate0_.id as id109_0_, wells1_.id as id143_1_, wellsample2_.id as id146_2_, plate0_.columnNamingConvention as columnNa2_109_0_, plate0_.columns as columns109_0_, plate0_.defaultSample as defaultS4_109_0_, plate0_.description as descript5_109_0_, plate0_.creation_id as creation17_109_0_, plate0_.external_id as external18_109_0_, plate0_.group_id as group19_109_0_, plate0_.owner_id as owner20_109_0_, plate0_.permissions as permissi6_109_0_, plate0_.update_id as update21_109_0_, plate0_.externalIdentifier as external7_109_0_, plate0_.name as name109_0_, plate0_.rowNamingConvention as rowNamin9_109_0_, plate0_."rows" as rows10_109_0_, plate0_.status as status109_0_, plate0_.version as version109_0_, plate0_.wellOriginXUnit as wellOri13_109_0_, plate0_.wellOriginX as wellOri14_109_0_, plate0_.wellOriginYUnit as wellOri15_109_0_, plate0_.wellOriginY as wellOri16_109_0_, wells1_.alpha as alpha143_1_, wells1_.blue as blue143_1_, wells1_."column" as column4_143_1_, wells1_.creation_id as creation14_143_1_, wells1_.external_id as external15_143_1_, wells1_.group_id as group16_143_1_, wells1_.owner_id as owner17_143_1_, wells1_.permissions as permissi5_143_1_, wells1_.update_id as update18_143_1_, wells1_.externalDescription as external6_143_1_, wells1_.externalIdentifier as external7_143_1_, wells1_.green as green143_1_, wells1_.plate as plate143_1_, wells1_.red as red143_1_, wells1_."row" as row10_143_1_, wells1_.status as status143_1_, wells1_.type as type143_1_, wells1_.version as version143_1_, wells1_.plate as plate109_0__, wells1_.id as id0__, wellsample2_.creation_id as creation9_146_2_, wellsample2_.external_id as external10_146_2_, wellsample2_.group_id as group11_146_2_, wellsample2_.owner_id as owner12_146_2_, wellsample2_.permissions as permissi2_146_2_, wellsample2_.update_id as update13_146_2_, wellsample2_.image as image146_2_, wellsample2_.plateAcquisition as plateAc15_146_2_, wellsample2_.posXUnit as posXUnit146_2_, wellsample2_.posX as posX146_2_, wellsample2_.posYUnit as posYUnit146_2_, wellsample2_.posY as posY146_2_, wellsample2_.timepoint as timepoint146_2_, wellsample2_.version as version146_2_, wellsample2_.well as well146_2_, wellsample2_.well as well143_1__, wellsample2_.id as id1__, wellsample2_.well_index as well17_1__ from plate plate0_ inner join well wells1_ on plate0_.id=wells1_.plate and
(
  1 = ? OR
  1 = ? OR
  (wells1_.group_id in (?)) OR
  (wells1_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = wells1_.group_id)) OR
  (wells1_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = wells1_.group_id)) OR
  ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = wells1_.group_id))
) left outer join wellsample wellsample2_ on wells1_.id=wellsample2_.well and
(
  1 = ? OR
  1 = ? OR
  (wellsample2_.group_id in (?)) OR
  (wellsample2_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = wellsample2_.group_id)) OR
  (wellsample2_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = wellsample2_.group_id)) OR
  ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = wellsample2_.group_id))
) where
(
  1 = ? OR
  1 = ? OR
  (plate0_.group_id in (?)) OR
  (plate0_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = plate0_.group_id)) OR
  (plate0_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = plate0_.group_id)) OR
  ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = plate0_.group_id))
) and (plate0_.id in (?)) group by plate0_.id]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query