Importing Solution 2.1.1 beta

Classic Servoy
1

I’m trying to import a solution into my production server using the web interface.

The import result page says:

Importing NZIJServoy.servoy…

[info] Import contains XML version 7 and repository version 24.
[warning] Reserved words used as table or column names: tables: role; columns: type action number password level type date time type;
[info] Imported style ‘nzij’.

The import options are:

Overwrite repository styles with import version [y]
Overwrite repository media with import version [y]
Overwrite repository group security settings with import version [y]

Allow reserved SQL keywords as table or column names [y]
Import solution sample data [n]
Import internationalization (i18n) data [n]
Insert new internationalization (i18n) keys only [n]

Merging options…

Merge solution if revision information is available, and when a merge conflict arises use: [n]
repository version
import version
Do not merge solution, and: [y]
overwrite repository forms with import version [y]
delete repository forms which do not exist in import version [y]

I get this error spurt out on the console of the server:

Oct 12, 2004 12:20:42 PM net.sf.hibernate.dialect.Dialect
INFO: Using dialect: net.sf.hibernate.dialect.PostgreSQLDialect
java.sql.SQLException: connection already closed or transaction in progress
java.sql.SQLException: connection already closed or transaction in progress
at com.servoy.j2db.persistence.datasource.TransactionConnection.close(Unknown Source)
at com.servoy.j2db.util.Utils.closeConnection(Unknown Source)
at com.servoy.j2db.persistence.e.a(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFileAs(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFile(Unknown Source)
at com.servoy.j2db.server.servlets.ConfigServlet.try(Unknown Source)
at com.servoy.j2db.server.servlets.ConfigServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:518)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)
at java.lang.Thread.run(Thread.java:534)
java.lang.Exception: SOLUTION TRANSACTION NOT CLOSED ON FLUSH: NZIJServoy
java.lang.Exception: SOLUTION TRANSACTION NOT CLOSED ON FLUSH: NZIJServoy
at com.servoy.j2db.persistence.ao.do(Unknown Source)
at com.servoy.j2db.persistence.l.a(Unknown Source)
at com.servoy.j2db.persistence.l.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.flushAllCachedData(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFileAs(Unknown Source)
at com.servoy.j2db.persistence.XMLImporter.importSolutionFromFile(Unknown Source)
at com.servoy.j2db.server.servlets.ConfigServlet.try(Unknown Source)
at com.servoy.j2db.server.servlets.ConfigServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
…
And a whole lot more of the tomcat stack.

After this, the solution has not been imported.

2

This is saying that you’re trying to import a solution from a NEWER version of Servoy into an OLDER version of Servoy.

Update your Servoy version and try the import again.

Bob Cusick

3

You sure?

I was using 2.1.1b at each time. I also sent it to servoy support and they didn’t know what the problem was either.

I have to send them my solution. I will post the solution when I do.

4

Yes please mail us the solution with the problems…
It seems to me you are importing an very old solution. (which should work fine do)