Unable to compare Diagram with database

[dancj]

We've got quite a large DBSchema file that covers a large chunk of our system, and we've always intermittently used the compare option to pull any DB changes into this file.

Unfortunately since we upgraded to version 5.8.0 this doesn't work.

It works through the tables, views and foreign keys okay, but when it's comparing the procedures (which we don't want in DbSchema anyway, but can't find a way to turn off) it always errors with: java.lang.OutOfMemoryError: Java heap space

This is a big problem for us as it means all of our schema diagrams will gradually get more and more out of date.

I did file an error report several weeks ago, but have not had any reply.

Thanks

Dan Condon-Jones

[donose.mihai]

Hi Dan,

Upgrade to the latest version 6.0 and let me know if you still have the same issue.
(or uninstall dbschema, get the latest installer from our website) and use the same registration information to register DbSchema).

Best Regards,

Mihai

[dancj]

I've just done that. Unfortunately I still get the error.

[donose.mihai]

Try to edit DbSchema.bat or dbschema.sh (if your running on linux) and set the Java Memory.


Look for this default value:

SET MEMORY_JVM_ARGS=-Xms64M -Xmx750M

and try to change it with this value:

SET MEMORY_JVM_ARGS=-Xms128M -Xmx1024M

After that, run the bat file.


Waiting for your update.

Thanks

ps: how large is your database? (maybe we'll need to set a bigger memory chunk).

[dancj]

I tried that, but still get the error.

For the three schemas that I use in this file we have 1426 tables and 12173 objects overall.

Dan

[donose.mihai]

I tried that, but still get the error.

For the three schemas that I use in this file we have 1426 tables and 12173 objects overall.

Dan

Ok Dan,

Please provide me the next info:

1. OS
2. The Database that you're getting the error
3. Please upload dbschema log file
Win Vista & Win7 (C:\Users\Your_Username\.DbSchema\logs)
Win Xp (C:\Documents and Settings\YOUR_USER\.DbSchema\logs)
Linux ( \usr\.DbSchema\logs\)
Mac ( Open DbSchema.app -> Resources\Java\logs)


Thanks

[dancj]

1 - Windows 7 - 32 bit
2 - Oracle 10g Enterprise Edition Release 10.2.0.5.0
3 - File is attached

Ta

Dan

[donose.mihai]

In a few days we're going to release a new update, i hope your issue will be resolved.
If you have any other issues please let us know.

[dancj]

Thanks a lot

[donose.mihai]

Hello,

I was thinking in the mean time to try something, when trying to connect to the database can you try to uncheck views, procedures, triggers, sequences, functions, and leave only the tables, try to load only the tables and see if the out of memory exceptions still appears, and also give it the maximum memory available on your system,

Look for this default value in DbSchema.bat(open it with notepad):

and try to change it with this value:

of -Xmx1024M instead of 1024 put the maximum memory available on your system.


Hope this helps until we`re going to release the beta update with the fix.
I will appreciate your feedback related to this issues.
Thanks

Regards,

Mihai