Problem exporting and importing solution.

Classic Servoy
1

Hi there,

We are having problem to export and import our Servoy Solution.
After waiting for 45 minutes to export the solution in Servoy Developer 2.1, Servoy does not alert us if export has been completed nor alerts us if there has been any error exporting the solution.

Then we assume that the solution has been exported successfully. Then we tried to import it, but immediately after we start to import the solution we get the following error:

com.servoy.j2db.persistence.RepositoryException: java.util.zip.ZipException: error in opening zip file.

Servoy Developer
Version R2 2.1.2-build 315
Java version 1.5.0_04-b05 (Windows XP)

Plus, when we tried to upgrade Servoy from Help\Check for new version menu, nothing happens.

Please advice.

Thanks,

Abrahim

2

Looks like there is a problem with the export. Can you run servoy in tracing mode (-DSTACKTRACE=true) and send me the log created by Servoy Developer? Also what backend are you using?

3

In Servoy, what is the config file name that I need to set (-DSTACKTRACE=true)?

Please let me know.

Thanks,

Abrahim

4

You need to edit the servoy_developer.bat and start Servoy using that bat…

5

Here is the Log file:

Starting Servoy from D:\Servoy-08-16-05Servoy R2 2.1.2 build-315 on Windows XP using Java 1.5.0_04Looking for servoy.properties on C:\Documents and Settings\abk\servoy.propertiesLoading servoy.properties from D:\Servoy-08-16-05\servoy.propertiesLoading - DoneUsing RMI registry on port 1099java.sql.SQLException: connection already closed or transaction in progressjava.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.ac.a(Unknown Source)
at com.servoy.j2db.persistence.ac.a(Unknown Source)
at com.servoy.j2db.develop.h$10.run(Unknown Source)
at com.servoy.j2db.util.aq.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.OutOfMemoryError: Java heap spacejava.lang.OutOfMemoryError: Java heap space

or .Service_log
FATAL | wrapper | 2004/06/16 10:30:08 | OpenService failed - The specified service does not exist as an installed service. (0x424)
STATUS | wrapper | 2004/06/16 10:30:08 | Servoy Application Server installed.
FATAL | wrapper | 2004/06/25 11:10:11 | OpenService failed - The specified service does not exist as an installed service. (0x424)
STATUS | wrapper | 2004/06/25 11:10:11 | Servoy Application Server installed.
FATAL | wrapper | 2004/07/01 11:49:09 | OpenService failed - The specified service does not exist as an installed service. (0x424)
STATUS | wrapper | 2004/07/01 11:49:09 | Servoy Application Server installed.
STATUS | wrapper | 2004/07/06 11:01:42 | Servoy Application Server removed.
STATUS | wrapper | 2004/07/06 11:01:42 | Servoy Application Server installed.
STATUS | wrapper | 2004/08/23 09:25:07 | Servoy Application Server removed.
STATUS | wrapper | 2004/08/23 09:25:07 | Servoy Application Server installed.
STATUS | wrapper | 2004/10/19 08:45:15 | Servoy Application Server removed.
STATUS | wrapper | 2004/10/19 08:45:15 | Servoy Application Server installed.

Please let me know if this what we are looking for.

Thanks,

Abarhim

6

This is indeed what I need. It seems there is an out of memory error. How much memory do you have in the server, what kind of solution are you exporting? Are you exporting a lot of data, or a lot of binary data?

Can you send me the full log (the servoy developer log) via email?

7

For Development I have Windows XP with 1 Gig of ram\CPU 3 GHZ.
The solution that I’m exporting has around 230 forms in it.

Attached is the log file.

Thanks,

Abrahim

8

There are a lot of errors in your log file, some things that need fixing in your solution.

I’m wondering when you get the out of memory error, I don’t see you doing an export explicitly in the log. I’m not exactly sure what’s causing it, do you remember what actions you were taking when it happened?

Finally, can you have a look at the size of the zip file? It’s probably 0 bytes long (something which should be fixed in the new version of Servoy) because the export failed.

9

Sebastiaan,

I tried to export the soltuion again and sending you the log file and the exported solution files size.I tried to export the solution again and sending you the log file.

The exported solution files size is 3,924 KB.

Please let me know if you need any more info to resolve this issue.

Thanks in advance,

Abrahim

10

Hi,

Unfortunately I can’t tell much from the log file except that you’re getting an out of memory error.

There are several things you can try:

  1. increase the memory by adding a flag -Xmx256M before -DSTACKTRACE=true in your servoy_developer.bat file. This means that your heap is 256 megabytes. You can increase the 256 if necessary.
  2. When you export, try exporting the solution only without any sample data.
11

Finally, I was able to export the solution by increasing the memory in -Xmx700M
java -DSTACKTRACE=true to 700.

Then shutdown Servoy and increase the memory -Xmx700M
java -DSTACKTRACE=true to 2000.
, and then start Servoy and tried to import the solution but I still get the following error:

2005-08-20 19:44 : Loading servoy.properties from D:\08-17-05\Servoy\servoy.properties
2005-08-20 19:44 : Loading - Done
2005-08-20 19:44 : Using RMI registry on port 1099
2005-08-20 19:48 : 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.i.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.develop.j$6.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2005-08-20 19:48 : java.lang.OutOfMemoryError: Java heap space

By the way the exported solution size is 2,590KB.
Please let me know what can we do next.

Thanks,

Abrahim

12

Sebastiaan,

Any update on this problem?

Please let me know.

Thanks,

Abrahim

13

Hi,

Do you still have this problem with the latest release of Servoy?
If you do, please let me know and I will look into it.

14

Sebastiaan,

With Maartens help we fixed the problem.

@echo off
java -Xmx700M -jar servoy_developer.jar
rem c:\jdk1.3.1\bin\java -
classpath .;lib\activation.jar;lib\antlr.jar;lib\bootstrap.jar;lib\j2db.jar;lib\j2dbdev.jar;lib\compat141.jar;lib\jh.jar;lib\jndi.jar;lib\js.jar;lib\jta.jar;lib\kunststoff.jar;lib\mail.jar;lib\jug.jar;lib\jdbc2_0-stdext.jar;lib\naming-common.jar;lib\naming-resources.jar;lib\servlet.jar;lib\xerces.jar;server\lib\bootstrap.jar com.servoy.j2db.startup.Bootstrap

Abrahim