XNAT 1.4 rc1: Retrieving project list

[Simon Doran]

Tim,

Ignoring the previous error that I reported just now, I have
proceeded with setting up a new installation. However, on startup
(home page), the system is not able successfully to retrieve the list
of projects. I get the "downloading symbol" rotating away but nothing
happens. The error log in catalina.out is below (segment from login
forwards to first display of homepage).

I have successfully managed to store details of a new project and
they can be retrieved via My Projects in the left sidebar. However, as
soon as I proceed to Upload Images, I get a popup dialog window
directly from the browser with the message
"http://localhost:8080 ERROR 200: Failed to parse project list."

Any ideas? Is it significant that the error message does not have
""http://localhost:8080/xnat"?

Simon

User Init(testuser): 2ms
User(login) Loaded (6)ms
User(login,password) Loaded (6)ms
Item modifications stored. 1 triggers.
org.postgresql.util.PSQLException: ERROR: operator does not exist:
character varying = integer

at org.postgresql.util.PSQLException.parseServerError
(PSQLException.java:139)
at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:
152)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute
(AbstractJdbc1Statement.java:517)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute
(AbstractJdbc2Statement.java:50)
at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery
(AbstractJdbc1Statement.java:233)
at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery
(AbstractJdbc1Statement.java:221)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery
(DelegatingStatement.java:205)
at org.nrg.xft.db.PoolDBUtils.executeSelectQuery(PoolDBUtils.java:
433)
at org.nrg.xft.search.TableSearch.Execute(TableSearch.java:205)
at org.nrg.xdat.search.DisplaySearch.execute(DisplaySearch.java:162)
at org.nrg.xdat.search.DisplaySearch.execute(DisplaySearch.java:1071)
at
org.nrg.xnat.restlet.resources.ProjectListResource.getRepresentation
(ProjectListResource.java:323)
at org.restlet.resource.Resource.handleGet(Resource.java:463)
at org.restlet.Finder.handle(Finder.java:351)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Router.handle(Router.java:502)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Filter.doHandle(Filter.java:150)
at com.noelios.restlet.StatusFilter.doHandle(StatusFilter.java:130)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at com.noelios.restlet.ChainHelper.handle(ChainHelper.java:124)
at com.noelios.restlet.application.ApplicationHelper.handle
(ApplicationHelper.java:112)
at org.restlet.Application.handle(Application.java:342)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Router.handle(Router.java:502)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Router.handle(Router.java:502)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at com.noelios.restlet.ChainHelper.handle(ChainHelper.java:124)
at org.restlet.Component.handle(Component.java:888)
at org.restlet.Server.handle(Server.java:331)
at com.noelios.restlet.ServerHelper.handle(ServerHelper.java:68)
at com.noelios.restlet.http.HttpServerHelper.handle
(HttpServerHelper.java:147)
at com.noelios.restlet.ext.servlet.ServerServlet.service
(ServerServlet.java:790)
at org.nrg.xnat.restlet.servlet.XNATRestletServlet.service
(XNATRestletServlet.java:24)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:175)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service
(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:
447)
at java.lang.Thread.run(Thread.java:613)
org.postgresql.util.PSQLException: ERROR: operator does not exist:
character varying = integer

at org.postgresql.util.PSQLException.parseServerError
(PSQLException.java:139)
at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:
152)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute
(AbstractJdbc1Statement.java:517)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute
(AbstractJdbc2Statement.java:50)
at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery
(AbstractJdbc1Statement.java:233)
Feb 23, 2009 11:01:15 AM com.noelios.restlet.LogFilter afterHandle
INFO: 2009-02-23 11:01:15 127.0.0.1 - 127.0.0.1 8080 GET /xnat/REST/
projects format=json&recent=true&stamp=1235386875592 200 0 - 7
http://localhost:8080 Mozilla/5.0 (Macintosh; U; Intel Mac OS X
10_5_6; en-us) AppleWebKit/525.27.1 (KHTML, like Gecko) Version/3.2.1
Safari/525.27.1 http://localhost:8080/xnat/app/action/XDATLoginUser
at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery
(AbstractJdbc1Statement.java:221)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery
(DelegatingStatement.java:205)
at org.nrg.xft.db.PoolDBUtils.executeSelectQuery(PoolDBUtils.java:
433)
at org.nrg.xft.search.TableSearch.Execute(TableSearch.java:205)
at org.nrg.xdat.search.DisplaySearch.execute(DisplaySearch.java:162)
at org.nrg.xdat.search.DisplaySearch.execute(DisplaySearch.java:1071)
at
org.nrg.xnat.restlet.resources.ProjectListResource.getRepresentation
(ProjectListResource.java:323)
at org.restlet.resource.Resource.handleGet(Resource.java:463)
at org.restlet.Finder.handle(Finder.java:351)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Router.handle(Router.java:502)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Filter.doHandle(Filter.java:150)
at com.noelios.restlet.StatusFilter.doHandle(StatusFilter.java:130)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at com.noelios.restlet.ChainHelper.handle(ChainHelper.java:124)
at com.noelios.restlet.application.ApplicationHelper.handle
(ApplicationHelper.java:112)
at org.restlet.Application.handle(Application.java:342)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Router.handle(Router.java:502)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at org.restlet.Router.handle(Router.java:502)
at org.restlet.Filter.doHandle(Filter.java:150)
at org.restlet.Filter.handle(Filter.java:195)
at com.noelios.restlet.ChainHelper.handle(ChainHelper.java:124)
at org.restlet.Component.handle(Component.java:888)
at org.restlet.Server.handle(Server.java:331)
at com.noelios.restlet.ServerHelper.handle(ServerHelper.java:68)
at com.noelios.restlet.http.HttpServerHelper.handle
(HttpServerHelper.java:147)
at com.noelios.restlet.ext.servlet.ServerServlet.service
(ServerServlet.java:790)
at org.nrg.xnat.restlet.servlet.XNATRestletServlet.service
(XNATRestletServlet.java:24)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:175)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:102)
Feb 23, 2009 11:01:15 AM com.noelios.restlet.http.HttpServerConverter
commit
WARNING: A response with an unavailable entity was returned. Ignoring
the entity for resource "http://localhost:8080/xnat/REST/projects?
format=json&recent=true&stamp=1235386875592.
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service
(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:
447)
at java.lang.Thread.run(Thread.java:613)
Feb 23, 2009 11:01:15 AM com.noelios.restlet.LogFilter afterHandle
INFO: 2009-02-23 11:01:15 127.0.0.1 - 127.0.0.1 8080 GET /xnat/REST/
projects format=json&recent=true&owner=true 200 0 - 7 http://localhost:8080
Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_6; en-us) AppleWebKit/
525.27.1 (KHTML, like Gecko) Version/3.2.1 Safari/525.27.1
http://localhost:8080/xnat/app/action/XDATLoginUser
Feb 23, 2009 11:01:15 AM com.noelios.restlet.http.HttpServerConverter
commit
WARNING: A response with an unavailable entity was returned. Ignoring
the entity for resource "http://localhost:8080/xnat/REST/projects?
format=json&recent=true&owner=true.
Feb 23, 2009 11:01:15 AM com.noelios.restlet.LogFilter afterHandle
INFO: 2009-02-23 11:01:15 127.0.0.1 - 127.0.0.1 8080 GET /xnat/REST/
experiments format=json&recent=true 200 - - 17 http://localhost:8080
Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_6; en-us) AppleWebKit/
525.27.1 (KHTML, like Gecko) Version/3.2.1 Safari/525.27.1
http://localhost:8080/xnat/app/action/XDATLoginUser

[Timothy Olsen]

If you log out and log back in, does the project list still fail to render? We had a bug related to new projects not showing up in the project list (which I thought was resolved).

Which browser version are you using?

Tim

[Timothy Olsen]

I think this is related to the PostgreSQL exception which you and Alex reported. I'm looking into it.

Tim

-----Original Message-----
From: xnat_di...@googlegroups.com [mailto:xnat_di...@googlegroups.com] On Behalf Of Simon Doran
Sent: Monday, February 23, 2009 5:08 AM
To: xnat_discussion
Subject: XNAT 1.4 rc1: Retrieving project list

[Timothy Olsen]

Simon & Alex,

 

I've checked in a change to the xnat_1_4rc1 branch which should resolve this bug.  I'm guessing the issue was exposed by a different version of PostgreSQL then the one I am running.  Which version of PostgreSQL are you running?

 

The bug would cause errors in the population of the project view on the Index page.

 

To process the change, you could either re-install.  Or,

 

1.  Run ‘cvs –update’

2.  cp plugin-resources/project-skeletons/xnat/src/schemas/xnat/display/xnat_projectData_display.xml projects/xnat/src/schemas/xnat/display/

3.  Run ‘bin/update.sh’

4.  Run ‘ psql –f deployments/xnat/sql/xnat-update.sql …’

5.  Restart Tomcat

 

Tim

 

-----Original Message-----
From: xnat_di...@googlegroups.com [mailto:xnat_di...@googlegroups.com] On Behalf Of Simon Doran
Sent: Monday, February 23, 2009 5:08 AM
To: xnat_discussion
Subject: XNAT 1.4 rc1: Retrieving project list

 

 

Tim,

[Simon Doran]

Tim,

Thanks for looking at this so speedily. I am out of the office till
Friday, but when I get back in, I will checkout your update.

Simon

On Feb 23, 5:49 pm, Timothy Olsen <t...@npg.wustl.edu> wrote:
> Simon & Alex,
>
> I've checked in a change to the xnat_1_4rc1 branch which should resolve this bug.  I'm guessing the issue was exposed by a different version of PostgreSQL then the one I am running.  Which version of PostgreSQL are you running?
>
> The bug would cause errors in the population of the project view on the Index page.
>
> To process the change, you could either re-install.  Or,
>

> 1.  Run 'cvs -update'
>
> 2.  cp plugin-resources/project-skeletons/xnat/src/schemas/xnat/display/xnat_proje ctData_display.xml projects/xnat/src/schemas/xnat/display/
>
> 3.  Run 'bin/update.sh'
>
> 4.  Run ' psql -f deployments/xnat/sql/xnat-update.sql ...'

> ...
>
> read more »

[Simon Doran]

Tim,

I think this problem is now resolved. I followed your instructions
and it seemed to work. For info, I am using PostgreSQL 8.3.

Simon

> ...
>
> read more »