Server Refusing To Import

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

Server Refusing To Import

Postby bcusick » Tue Jul 12, 2016 10:52 pm

I have a very strange thing happening - the server is refusing to import a solution.

I get this message:

Importing cris_sj_conf.servoy...

[warning] Reserved words used as table or column names: columns: role active;
[info] Deleting existing Style 'cris'.
[error] Solution 'cris_sj_conf' already exists. Import failed.
[error] Operation cancelled

Here's what I've done so far:
- Rebuilt the repository (new database and started using -updateRepository option);
- Deleted the solution (and modules) and restarted the server (same result)

ANY IDEAS on what's going on?

Server Config:

Server Information
Servoy version 7.4.4 -releaseNumber 2039
Port used by RMI Registry: 1100
Repository version 44

JVM Information
java.vm.name=Java HotSpot(TM) Client VM
java.version=1.8.0_91
java.vm.info=mixed mode
java.vm.vendor=Oracle Corporation

Operating System Information
os.name=Windows Server 2012
os.version=6.2
os.arch=x86

From the server log:

Code: Select all
com.servoy.j2db.persistence.RepositoryException: Operation cancelled
       at com.servoy.j2db.server.Zc.Zk.getRootObjectNameForImport(Zk.java:361)
       at com.servoy.j2db.server.Zc.Zdb.Za(Zdb.java:93)
       at com.servoy.j2db.server.Zc.Zdb.importFromJarFile(Zdb.java:363)
       at com.servoy.j2db.server.servlets.ConfigServlet.Zi(ConfigServlet.java:3017)
       at com.servoy.j2db.server.servlets.ConfigServlet.service(ConfigServlet.java:1312)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
       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:191)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
       at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
       at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
       at java.lang.Thread.run(Unknown Source)
2016-07-12 12:56   http-8181-2   ERROR   com.servoy.j2db.util.Debug   Throwable       
java.sql.SQLException: no transaction in progress
       at com.servoy.j2db.datasource.Zo.rollback(Zo.java:117)
       at com.servoy.j2db.util.Utils.rollback(Utils.java:1598)
       at com.servoy.j2db.server.Zc.Zk.importingDone(Zk.java:464)
       at com.servoy.j2db.server.Zc.Zdb.Za(Zdb.java:142)
       at com.servoy.j2db.server.Zc.Zdb.importFromJarFile(Zdb.java:363)
       at com.servoy.j2db.server.servlets.ConfigServlet.Zi(ConfigServlet.java:3017)
       at com.servoy.j2db.server.servlets.ConfigServlet.service(ConfigServlet.java:1312)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
       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:191)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
       at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
       at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
       at java.lang.Thread.run(Unknown Source)
Bob Cusick
bcusick
 
Posts: 1255
Joined: Wed Apr 23, 2003 11:27 pm
Location: Thousand Oaks, CA USA

Re: Server Refusing To Import

Postby Andrei Costescu » Wed Jul 13, 2016 9:41 am

Interesting. It's almost like trying to do a clean import twice on top of an empty repo (so it thinks there's another solution with the same name in there (uuids don't match)).
Do you manually import it or do you use a tool/post? (I'm thinking that somehow import is started twice quickly) Is clean import checked?

Can you also enable tracing for the import log statements? In your servoy.properties set log4j.logger.com.servoy.j2db.persistence.XMLInMemoryImportHandlerVersions11AndHigher=TRACE
Andrei Costescu
Servoy
Andrei Costescu
 
Posts: 1018
Joined: Tue Jun 26, 2007 3:14 pm

Re: Server Refusing To Import

Postby bcusick » Wed Jul 13, 2016 2:34 pm

Thanks Andrei for your response!

I will add the tracing.

I do the import manually - no automated tool.

I'll let you know the results.
Bob Cusick
bcusick
 
Posts: 1255
Joined: Wed Apr 23, 2003 11:27 pm
Location: Thousand Oaks, CA USA

Re: Server Refusing To Import

Postby bcusick » Wed Jul 13, 2016 3:11 pm

OK - so I added that line to the servoy.properties file, restarted the Servoy Application Server, and tried to import again (same result).

The log was the same as well....

Code: Select all
java.sql.SQLException: no transaction in progress
   at com.servoy.j2db.datasource.Zo.rollback(Zo.java:117)
   at com.servoy.j2db.util.Utils.rollback(Utils.java:1598)
   at com.servoy.j2db.server.Zc.Zk.importingDone(Zk.java:464)
   at com.servoy.j2db.server.Zc.Zdb.Za(Zdb.java:142)
   at com.servoy.j2db.server.Zc.Zdb.importFromJarFile(Zdb.java:363)
   at com.servoy.j2db.server.servlets.ConfigServlet.Zi(ConfigServlet.java:3017)
   at com.servoy.j2db.server.servlets.ConfigServlet.service(ConfigServlet.java:1312)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   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:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)
2016-07-13 06:09:05,621 ERROR [http-8181-1] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: Operation cancelled
   at com.servoy.j2db.server.Zc.Zk.getRootObjectNameForImport(Zk.java:361)
   at com.servoy.j2db.server.Zc.Zdb.Za(Zdb.java:93)
   at com.servoy.j2db.server.Zc.Zdb.importFromJarFile(Zdb.java:363)
   at com.servoy.j2db.server.servlets.ConfigServlet.Zi(ConfigServlet.java:3017)
   at com.servoy.j2db.server.servlets.ConfigServlet.service(ConfigServlet.java:1312)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   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:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Unknown Source)
Bob Cusick
bcusick
 
Posts: 1255
Joined: Wed Apr 23, 2003 11:27 pm
Location: Thousand Oaks, CA USA

Re: Server Refusing To Import

Postby Andrei Costescu » Wed Jul 13, 2016 4:13 pm

Hmm. You didn't say if you use clean import or not.

But anyway, if you don't import twice and the repo. is empty initially it's strange.
Maybe it's something related to the .servoy file that you are importing. I guess the problem is specific to that one .servoy right?
Andrei Costescu
Servoy
Andrei Costescu
 
Posts: 1018
Joined: Tue Jun 26, 2007 3:14 pm


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 7 guests