[ome-users] Error (EXTERNAL IP): /webadmin/load_drivespace/

Leon Kolchinsky lkolchin at gmail.com
Tue Sep 20 13:52:01 BST 2011


Hello,

I'm testing new version of Omero Server 4.3.2
When logged-in as root to webadmin interface I click on "Drive Space" and
get this message "Could not load piechart. Please contact Administrator".
I'm also getting the following e-mail:


Traceback (most recent call last):

 File "/srv/omeroserver/lib/python/django/core/handlers/base.py", line 92,
in get_response
   response = callback(request, *callback_args, **callback_kwargs)

 File "/srv/omeroserver/lib/python/omeroweb/webadmin/views.py", line 168, in
wrapped
   return f(request, *args, **kwargs)

 File "/srv/omeroserver/lib/python/omeroweb/webadmin/views.py", line 871, in
load_drivespace
   rv = usersData(conn, offset)

 File
"/srv/omeroserver/lib/python/omeroweb/webadmin/controller/drivespace.py",
line 99, in usersData
   "where m.child.id in (:pids)", p2, ctx)

 File "/srv/omeroserver/lib/python/omero/gateway/__init__.py", line 2959, in
__call__
   return self.handle_exception(e, *args, **kwargs)

 File
"/srv/OMERO.server-Beta-4.3.2/lib/python/omeroweb/webclient/webclient_gateway.py",
line 1652, in handle_exception
   e, *args, **kwargs)

 File "/srv/omeroserver/lib/python/omero/gateway/__init__.py", line 2956, in
__call__
   return self.f(*args, **kwargs)

 File "/srv/omeroserver/lib/python/omero_api_IQuery_ice.py", line 138, in
findAllByQuery
   return _M_omero.api.IQuery._op_findAllByQuery.invoke(self, ((query,
params), _ctx))

ApiUsageException: exception ::omero::ApiUsageException
{
   serverStackTrace = ome.conditions.ApiUsageException: unexpected end of
subtree [select m from ome.model.core.PixelsOriginalFileMap as m join fetch
m.parent where m.child.id 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 m.child.id in ()]
       at
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:660)
       at
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
       at
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
       at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
       at ome.logic.QueryImpl.execute(QueryImpl.java:142)
       at ome.logic.QueryImpl.findAllByQuery(QueryImpl.java:392)
       at sun.reflect.GeneratedMethodAccessor293.invoke(Unknown Source)
       at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:597)
       at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
       at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
       at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
       at ome.security.basic.EventHandler.invoke(EventHandler.java:150)
       at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at
org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111)
       at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108)
       at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at
ome.tools.hibernate.ProxyCleanupFilter$Interceptor.invoke(ProxyCleanupFilter.java:231)
       at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at ome.services.util.ServiceHandler.invoke(ServiceHandler.java:116)
       at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
       at $Proxy72.findAllByQuery(Unknown Source)
       at sun.reflect.GeneratedMethodAccessor293.invoke(Unknown Source)
       at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:597)
       at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
       at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
       at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
       at
ome.security.basic.BasicSecurityWiring.invoke(BasicSecurityWiring.java:83)
       at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at
ome.services.blitz.fire.AopContextInitializer.invoke(AopContextInitializer.java:43)
       at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
       at $Proxy72.findAllByQuery(Unknown Source)
       at sun.reflect.GeneratedMethodAccessor320.invoke(Unknown Source)
       at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:597)
       at
ome.services.blitz.util.IceMethodInvoker.invoke(IceMethodInvoker.java:179)
       at ome.services.throttling.Callback.run(Callback.java:56)
       at
ome.services.throttling.InThreadThrottlingStrategy.callInvokerOnRawArgs(InThreadThrottlingStrategy.java:56)
       at
ome.services.blitz.impl.AbstractAmdServant.callInvokerOnRawArgs(AbstractAmdServant.java:136)
       at
ome.services.blitz.impl.QueryI.findAllByQuery_async(QueryI.java:66)
       at omero.api._IQueryTie.findAllByQuery_async(_IQueryTie.java:92)
       at omero.api._IQueryDisp.___findAllByQuery(_IQueryDisp.java:366)
       at omero.api._IQueryDisp.__dispatch(_IQueryDisp.java:496)
       at IceInternal.Incoming.invoke(Incoming.java:159)
       at Ice.ConnectionI.invokeAll(ConnectionI.java:2037)
       at Ice.ConnectionI.message(ConnectionI.java:972)
       at IceInternal.ThreadPool.run(ThreadPool.java:577)
       at IceInternal.ThreadPool.access$100(ThreadPool.java:12)
       at IceInternal.ThreadPool$EventHandlerThread.run(ThreadPool.java:971)

   serverExceptionClass = ome.conditions.ApiUsageException
   message = unexpected end of subtree [select m from
ome.model.core.PixelsOriginalFileMap as m join fetch m.parent where
m.child.id 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 m.child.id in ()]
}


<WSGIRequest
GET:<QueryDict: {}>,
POST:<QueryDict: {}>,
COOKIES:{'__utma':
'192312886.126904984.1289803522.1316045304.1316486455.52',
 '__utmz': '192312886.1316486455.52.35.utmcsr=monash.edu
|utmccn=(referral)|utmcmd=referral|utmcct=/',
 'sessionid': '5fd671309cdddd3b278bf04c5d2f0580'},
META:{'CONTENT_TYPE': 'application/json; charset=utf-8',
 'DOCUMENT_ROOT': '/srv/webstart',
 'GATEWAY_INTERFACE': 'CGI/1.1',
 'HTTPS': 'on',
 'HTTP_ACCEPT': 'application/json, text/javascript, */*',
 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.3',
 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch',
 'HTTP_ACCEPT_LANGUAGE': 'en-US,en;q=0.8',
 'HTTP_CONNECTION': 'keep-alive',
 '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=monash.edu|utmccn=(referral)|utmcmd=referral|utmcct=/;
sessionid=5fd671309cdddd3b278bf04c5d2f0580',
 'HTTP_HOST': 'server.its.monash.edu.au <http://vera145.its.monash.edu.au>',
 'HTTP_REFERER':
'https://server.its.monash.edu.au/webadmin/drivespace/<https://vera145.its.monash.edu.au/webadmin/drivespace/>
',
 'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/535.1 (KHTML,
like Gecko) Chrome/14.0.835.163 Safari/535.1',
 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest',
 'PATH': '/sbin:/usr/sbin:/bin:/usr/bin',
 'PATH_INFO': u'/webadmin/load_drivespace/',
 'PATH_TRANSLATED':
'/srv/omeroserver/var/omero.fcgi/webadmin/load_drivespace/',
 'QUERY_STRING': '',
 'REMOTE_ADDR': '110.174.176.101',
 'REMOTE_PORT': '4153',
 'REQUEST_METHOD': 'GET',
 'REQUEST_URI': '/webadmin/load_drivespace/',
 'SCRIPT_FILENAME': '/srv/omeroserver/var/omero.fcgi',
 'SCRIPT_NAME': u'',
 'SERVER_ADDR': '130.194.245.190',
 'SERVER_ADMIN': 'root at localhost',
 'SERVER_NAME': 'server.its.monash.edu.au <http://vera145.its.monash.edu.au>
',
 'SERVER_PORT': '443',
 'SERVER_PROTOCOL': 'HTTP/1.1',
 'SERVER_SIGNATURE': '<address>Apache/2.2.3 (Red Hat) Server at
server.its.monash.edu.au <http://vera145.its.monash.edu.au> Port
443</address>\n',
 'SERVER_SOFTWARE': 'Apache/2.2.3 (Red Hat)',
 'wsgi.errors': <flup.server.fcgi_base.TeeOutputStream object at
0x10e30ed0>,
 'wsgi.input': <flup.server.fcgi_base.InputStream object at 0x10c98410>,
 'wsgi.multiprocess': True,
 'wsgi.multithread': False,
 'wsgi.run_once': False,
 'wsgi.url_scheme': 'https',
 'wsgi.version': (1, 0)}>


Any idea what the problem is and how to resolve it?

P.S.:
This worked perfectly in 4.2.2.

Cheers,
Leon
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20110920/c55d0a62/attachment.html>


More information about the ome-users mailing list