I can no longer export my solution with data. Servoy does not give an error but the Batch File window shows a java out of memory error. It does not work even if I start the developer with 512 M of memory. I did it once while watching the memory use window in Servoy and it is using up alot of memory for something as it exports the solution with data. No problem exporting without data. I export almost daily and upgrade the Betas as soon as available. I think this has been a problem for a couple of Betas as the last time I succeeded in exporting with data was 5/18/04. I have alot of BLOBs in my data and perhaps it has a hard time dealing with them.
John McCann
2.1 Beta 3
MS SQL Server
Windows XP
The out of memory error can be caused by many large blobs. The ``sample data’’ feature is meant for sample data for solutions only, not for backups of the database. In that case it is better to use a database backup tool (otherwise the export solution files also become very huge).
For sample data it is thus best to reduce the number/size/quality of the images, so that the export remains reasonable in size.
Sebster,
I back up my data and the repository using the methods built into Entrerprise Manager each evening so I don’t expext to use the export solution with data step as a backup mechanism.
I have a fair number of problems with Servoy related to BLOBS. The Servoy team sometimes has trouble reproducing the problems. It is hard to send the team an example of the problem if I can’t send some sample BLOBS. Perhaps you could limit the number of BLOBS in the export to about 100 per table. This would solve the problem. The problem with the method you suggest is that it takes me greater than 50 hours of processor time to reduce my data set to one that I can export. It is not very practical.
John McCann