[ome-users] Beta 3.1.1 does not start

[Paulo Almeida]

Hi,

I get the same error when upgrading, using PostgreSQL 8.1.11 :

CREATE VIEW
ERROR:  syntax error at or near "," at character 975
LINE 23:         FOR dup1, dup2 IN EXECUTE sql LOOP
                         ^
ERROR:  current transaction is aborted, commands ignored until end of 
transaction block


- Paulo

On Tuesday 14 October 2008 12:56, josh.moore at gmx.de wrote:
> Hi Mario,
>
> Mario Valle writes:
>  > Dear all,
>  > inital testing of 3.0.1 were successful. Now upgraded to 3.1.1 and no
>  > way to start the server.
>  > OK, I was not able to upgrade the database due the SQL syntax error
>  > (covered on another mail on the list).
>  > I do not know if the hanging of the server during initialization is due
>  > to the incomplete upgrade or not. But here it is.
>
> Yes, the server will refuse to start if the database does not have the
> proper version. Can you clarify: you are having the same SQL upgrade
> error as Oliver:
>
> CREATE VIEW
>
> FEHLER:  Fehler »syntax error« bei »,« bei Zeichen 975
>
> ZEILE 23:         FOR dup1, dup2 IN EXECUTE sql LOOP
>
>
> (though probably without the German) ? What postgres version are you
> working with?
>
> ~Josh
>
>  > The last line of the server log  is:
>  >
>  > 10:30:41,434 INFO  [Log4jService$URLWatchTimerTask] Configuring from
>  > URL: resource:jboss-log4j.xml
>  >
>  > If I try to connect using the WebAdmin interface, the message is:
>  >
>  > Connection failure: Error creating bean with name 'init' defined in
>  > class path resource [ome/client/spring.xml]: Cannot resolve reference to
>  > bean 'managed-ome.api.ISession' while setting bean property
>  > 'sessionService'; nested exception is
>  > org.springframework.beans.factory.BeanCreationException: Error creating
>  > bean with name 'managed-ome.api.ISession': FactoryBean threw exception
>  > on object creation; nested exception is ome.client.OutOfService: Cannot
>  > initialize service proxy
>  >
>  > Thanks for your help!
>  >                                           mario
>  >
>  >
>  > --
>  > Mario Valle
>  > Somewere @ Manno
>  > http://www.cscs.ch/~mvalle/
>  >
>  > _______________________________________________
>  > ome-users mailing list
>  > ome-users at lists.openmicroscopy.org.uk
>  > http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users