<div dir="ltr">Hello,<div><br></div><div>I'm testing new version of Omero Server 4.3.2</div><div>When logged-in as root to webadmin interface I click on "Drive Space" and get this message "Could not load piechart. Please contact Administrator".</div>
<div>I'm also getting the following e-mail:<br clear="all"><div dir="ltr"><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse;color:rgb(80, 0, 80)"><div><br></div></span></div><div class="gmail_quote">
<br>Traceback (most recent call last):<br>
<br>
File "/srv/omeroserver/lib/python/django/core/handlers/base.py", line 92, in get_response<br>
response = callback(request, *callback_args, **callback_kwargs)<br>
<br>
File "/srv/omeroserver/lib/python/omeroweb/webadmin/views.py", line 168, in wrapped<br>
return f(request, *args, **kwargs)<br>
<br>
File "/srv/omeroserver/lib/python/omeroweb/webadmin/views.py", line 871, in load_drivespace<br>
rv = usersData(conn, offset)<br>
<br>
File "/srv/omeroserver/lib/python/omeroweb/webadmin/controller/drivespace.py", line 99, in usersData<br>
"where <a href="http://m.child.id" target="_blank">m.child.id</a> in (:pids)", p2, ctx)<br>
<br>
File "/srv/omeroserver/lib/python/omero/gateway/__init__.py", line 2959, in __call__<br>
return self.handle_exception(e, *args, **kwargs)<br>
<br>
File "/srv/OMERO.server-Beta-4.3.2/lib/python/omeroweb/webclient/webclient_gateway.py", line 1652, in handle_exception<br>
e, *args, **kwargs)<br>
<br>
File "/srv/omeroserver/lib/python/omero/gateway/__init__.py", line 2956, in __call__<br>
return self.f(*args, **kwargs)<br>
<br>
File "/srv/omeroserver/lib/python/omero_api_IQuery_ice.py", line 138, in findAllByQuery<br>
return _M_omero.api.IQuery._op_findAllByQuery.invoke(self, ((query, params), _ctx))<br>
<br>
ApiUsageException: exception ::omero::ApiUsageException<br>
{<br>
serverStackTrace = ome.conditions.ApiUsageException: unexpected end of subtree [select m from ome.model.core.PixelsOriginalFileMap as m join fetch m.parent where <a href="http://m.child.id" target="_blank">m.child.id</a> in ()]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select m from ome.model.core.PixelsOriginalFileMap as m join fetch m.parent where <a href="http://m.child.id" target="_blank">m.child.id</a> in ()]<br>
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:660)<br>
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)<br>
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)<br>
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)<br>
at ome.logic.QueryImpl.execute(QueryImpl.java:142)<br>
at ome.logic.QueryImpl.findAllByQuery(QueryImpl.java:392)<br>
at sun.reflect.GeneratedMethodAccessor293.invoke(Unknown Source)<br>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br>
at java.lang.reflect.Method.invoke(Method.java:597)<br>
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)<br>
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)<br>
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)<br>
at ome.security.basic.EventHandler.invoke(EventHandler.java:150)<br>
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br>
at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111)<br>
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br>
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108)<br>
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br>
at ome.tools.hibernate.ProxyCleanupFilter$Interceptor.invoke(ProxyCleanupFilter.java:231)<br>
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br>
at ome.services.util.ServiceHandler.invoke(ServiceHandler.java:116)<br>
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br>
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)<br>
at $Proxy72.findAllByQuery(Unknown Source)<br>
at sun.reflect.GeneratedMethodAccessor293.invoke(Unknown Source)<br>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br>
at java.lang.reflect.Method.invoke(Method.java:597)<br>
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)<br>
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)<br>
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)<br>
at ome.security.basic.BasicSecurityWiring.invoke(BasicSecurityWiring.java:83)<br>
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br>
at ome.services.blitz.fire.AopContextInitializer.invoke(AopContextInitializer.java:43)<br>
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br>
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)<br>
at $Proxy72.findAllByQuery(Unknown Source)<br>
at sun.reflect.GeneratedMethodAccessor320.invoke(Unknown Source)<br>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br>
at java.lang.reflect.Method.invoke(Method.java:597)<br>
at ome.services.blitz.util.IceMethodInvoker.invoke(IceMethodInvoker.java:179)<br>
at ome.services.throttling.Callback.run(Callback.java:56)<br>
at ome.services.throttling.InThreadThrottlingStrategy.callInvokerOnRawArgs(InThreadThrottlingStrategy.java:56)<br>
at ome.services.blitz.impl.AbstractAmdServant.callInvokerOnRawArgs(AbstractAmdServant.java:136)<br>
at ome.services.blitz.impl.QueryI.findAllByQuery_async(QueryI.java:66)<br>
at omero.api._IQueryTie.findAllByQuery_async(_IQueryTie.java:92)<br>
at omero.api._IQueryDisp.___findAllByQuery(_IQueryDisp.java:366)<br>
at omero.api._IQueryDisp.__dispatch(_IQueryDisp.java:496)<br>
at IceInternal.Incoming.invoke(Incoming.java:159)<br>
at Ice.ConnectionI.invokeAll(ConnectionI.java:2037)<br>
at Ice.ConnectionI.message(ConnectionI.java:972)<br>
at IceInternal.ThreadPool.run(ThreadPool.java:577)<br>
at IceInternal.ThreadPool.access$100(ThreadPool.java:12)<br>
at IceInternal.ThreadPool$EventHandlerThread.run(ThreadPool.java:971)<br>
<br>
serverExceptionClass = ome.conditions.ApiUsageException<br>
message = unexpected end of subtree [select m from ome.model.core.PixelsOriginalFileMap as m join fetch m.parent where <a href="http://m.child.id" target="_blank">m.child.id</a> in ()]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select m from ome.model.core.PixelsOriginalFileMap as m join fetch m.parent where <a href="http://m.child.id" target="_blank">m.child.id</a> in ()]<br>
}<br>
<br>
<br>
<WSGIRequest<br>
GET:<QueryDict: {}>,<br>
POST:<QueryDict: {}>,<br>
COOKIES:{'__utma': '192312886.126904984.1289803522.1316045304.1316486455.52',<br>
'__utmz': '192312886.1316486455.52.35.utmcsr=<a href="http://monash.edu" target="_blank">monash.edu</a>|utmccn=(referral)|utmcmd=referral|utmcct=/',<br>
'sessionid': '5fd671309cdddd3b278bf04c5d2f0580'},<br>
META:{'CONTENT_TYPE': 'application/json; charset=utf-8',<br>
'DOCUMENT_ROOT': '/srv/webstart',<br>
'GATEWAY_INTERFACE': 'CGI/1.1',<br>
'HTTPS': 'on',<br>
'HTTP_ACCEPT': 'application/json, text/javascript, */*',<br>
'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.3',<br>
'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch',<br>
'HTTP_ACCEPT_LANGUAGE': 'en-US,en;q=0.8',<br>
'HTTP_CONNECTION': 'keep-alive',<br>
'HTTP_COOKIE': '__utma=203357902.1484366806.1315973805.1315973805.1316391535.2; __utmz=203357902.1315973805.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); __utma=192312886.126904984.1289803522.1316045304.1316486455.52; __utmz=192312886.1316486455.52.35.utmcsr=<a href="http://monash.edu" target="_blank">monash.edu</a>|utmccn=(referral)|utmcmd=referral|utmcct=/; sessionid=5fd671309cdddd3b278bf04c5d2f0580',<br>
'HTTP_HOST': '<a href="http://vera145.its.monash.edu.au" target="_blank">server.its.monash.edu.au</a>',<br>
'HTTP_REFERER': '<a href="https://vera145.its.monash.edu.au/webadmin/drivespace/" target="_blank">https://server.its.monash.edu.au/webadmin/drivespace/</a>',<br>
'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.163 Safari/535.1',<br>
'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest',<br>
'PATH': '/sbin:/usr/sbin:/bin:/usr/bin',<br>
'PATH_INFO': u'/webadmin/load_drivespace/',<br>
'PATH_TRANSLATED': '/srv/omeroserver/var/omero.fcgi/webadmin/load_drivespace/',<br>
'QUERY_STRING': '',<br>
'REMOTE_ADDR': '110.174.176.101',<br>
'REMOTE_PORT': '4153',<br>
'REQUEST_METHOD': 'GET',<br>
'REQUEST_URI': '/webadmin/load_drivespace/',<br>
'SCRIPT_FILENAME': '/srv/omeroserver/var/omero.fcgi',<br>
'SCRIPT_NAME': u'',<br>
'SERVER_ADDR': '130.194.245.190',<br>
'SERVER_ADMIN': 'root@localhost',<br>
'SERVER_NAME': '<a href="http://vera145.its.monash.edu.au" target="_blank">server.its.monash.edu.au</a>',<br>
'SERVER_PORT': '443',<br>
'SERVER_PROTOCOL': 'HTTP/1.1',<br>
'SERVER_SIGNATURE': '<address>Apache/2.2.3 (Red Hat) Server at <a href="http://vera145.its.monash.edu.au" target="_blank">server.its.monash.edu.au</a> Port 443</address>\n',<br>
'SERVER_SOFTWARE': 'Apache/2.2.3 (Red Hat)',<br>
'wsgi.errors': <flup.server.fcgi_base.TeeOutputStream object at 0x10e30ed0>,<br>
'wsgi.input': <flup.server.fcgi_base.InputStream object at 0x10c98410>,<br>
'wsgi.multiprocess': True,<br>
'wsgi.multithread': False,<br>
'wsgi.run_once': False,<br>
'wsgi.url_scheme': 'https',<br>
'wsgi.version': (1, 0)}><br>
</div><br></div><div><br></div><div>Any idea what the problem is and how to resolve it?</div><div><br></div><div>P.S.:</div><div>This worked perfectly in 4.2.2.</div><div><br></div><div>Cheers,</div><div>Leon</div></div>