Issue 293 - Compendium version 1.5.1 beta 2 - project backup problem
: Compendium version 1.5.1 beta 2 - project backup problem
Status: RESOLVED FIXED
Product: Compendium
Database
: 1.5.1
: PC Windows
: Undecided Bug-Normal (vote)
Assigned To: Michelle Bachler
:
: Waiting_for_info
:
:
  Show dependency treegraph
 
Reported: 2006-12-22 02:12 GMT by Ron Kendall
Modified: 2007-05-22 04:40 BST (History)
1 user (show)

See Also:


Attachments


Note

You need to log in before you can comment on or make changes to this issue.


Description Ron Kendall 2006-12-22 02:12:37 GMT
Application hangs ('Backing up Project' box displayed and sits at 0% completed)
when perform backup to Zip w ref. files. (Backup to SQL worked fine). Prior to
this, I did open the files in the new version of Compendium and then saved
them, without incident.
Comment 1 Michelle Bachler 2006-12-24 08:38:33 GMT
Is there anything in the log file for the time this happened.
<compendium folder>/System/resources/Logs

If there is, can you attached the log file.
Thanks
Comment 2 Michelle Bachler 2007-01-08 13:30:56 GMT
I have just tested this and it definately works fine.
I really need your log file to give me a clue.
Does it do this with all your projects or just that one?
Have you tried it again since?
Comment 3 Michelle Bachler 2007-01-22 09:36:07 GMT
(there were many offline exchanges offline, none of which where successful at
diagnosing the problem)

I really don't know what is happening on your machine.
Producing the Zip backup does not do anything that unusual.
I am running out of ideas of how to help you with this.

Maybe Compendium needs reinstalling? (Not that I can really see how that would
help!).

Compendium 1.5.2 will be coming out in 3 or 4 weeks.
Hopefully if you install that over the Beta, it will all just work fine.
Comment 4 Damien 2007-05-08 17:46:58 BST
This is still a problem with version 1.5.2. In my case it is a relatively small
database.

- MySQL is running on the local machine, same one as Compendium.
- User used to access MySQL is not root (all privileges granted)
- Project name has a space in it

Log to follow.
Comment 5 Damien 2007-05-08 17:52:09 BST
09-May-2007_02-20-14: [Fatal Error] :-1:-1: Premature end of file.
org.xml.sax.SAXParseException: Premature end of file.
09-May-2007_02-20-14:     at
org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown
Source)
09-May-2007_02-20-14:     at
org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source)
09-May-2007_02-20-14:     at
org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
09-May-2007_02-20-14:     at
org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
09-May-2007_02-20-14:     at
org.apache.xerces.impl.XMLVersionDetector.determineDocVersion(Unknown Source)
09-May-2007_02-20-14:     at
org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
09-May-2007_02-20-14:     at
org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
09-May-2007_02-20-14:     at org.apache.xerces.parsers.XMLParser.parse(Unknown
Source)
09-May-2007_02-20-14:     at org.apache.xerces.parsers.DOMParser.parse(Unknown
Source)
09-May-2007_02-20-14:     at
com.compendium.io.xml.XMLReader.read(XMLReader.java:52)
09-May-2007_02-20-14:     at
com.compendium.ui.toolbars.UIToolBarManager.createToolbars(UIToolBarManager.java:171)
09-May-2007_02-20-14:     at
com.compendium.ui.ProjectCompendiumFrame.init(ProjectCompendiumFrame.java:706)
09-May-2007_02-20-14:     at
com.compendium.ui.ProjectCompendiumFrame.initialiseFrame(ProjectCompendiumFrame.java:587)
09-May-2007_02-20-14:     at
com.compendium.ProjectCompendium.<init>(ProjectCompendium.java:139)
09-May-2007_02-20-14:     at
com.compendium.ProjectCompendium.main(ProjectCompendium.java:86)
java.lang.Exception: Toolbar data could not be loaded
09-May-2007_02-20-14:     at
com.compendium.ui.toolbars.UIToolBarManager.createToolbars(UIToolBarManager.java:174)
09-May-2007_02-20-14:     at
com.compendium.ui.ProjectCompendiumFrame.init(ProjectCompendiumFrame.java:706)
09-May-2007_02-20-14:     at
com.compendium.ui.ProjectCompendiumFrame.initialiseFrame(ProjectCompendiumFrame.java:587)
09-May-2007_02-20-14:     at
com.compendium.ProjectCompendium.<init>(ProjectCompendium.java:139)
09-May-2007_02-20-14:     at
com.compendium.ProjectCompendium.main(ProjectCompendium.java:86)
SQL Exception: Database 'UTS Capstone' not found.
09-May-2007_02-20-18:     at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
09-May-2007_02-20-18:     at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
09-May-2007_02-20-18:     at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
09-May-2007_02-20-18:     at
org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
09-May-2007_02-20-18:     at
org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
09-May-2007_02-20-18:     at
org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
09-May-2007_02-20-18:     at
org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
09-May-2007_02-20-18:     at
org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
09-May-2007_02-20-18:     at
org.apache.derby.jdbc.Driver169.connect(Driver169.java)
09-May-2007_02-20-18:     at java.sql.DriverManager.getConnection(Unknown
Source)
09-May-2007_02-20-18:     at java.sql.DriverManager.getConnection(Unknown
Source)
09-May-2007_02-20-18:     at
com.compendium.core.db.management.DBConnectionManager.connect(DBConnectionManager.java:353)
09-May-2007_02-20-18:     at
com.compendium.core.db.management.DBConnectionManager.newConnection(DBConnectionManager.java:328)
09-May-2007_02-20-18:     at
com.compendium.core.db.management.DBConnectionManager.getConnection(DBConnectionManager.java:472)
09-May-2007_02-20-18:     at
com.compendium.core.db.management.DBDatabaseManager.requestConnection(DBDatabaseManager.java:231)
09-May-2007_02-20-18:     at
com.compendium.core.db.management.DBAdminDatabase.getSchemaStatusForDatabase(DBAdminDatabase.java:403)
09-May-2007_02-20-18:     at
com.compendium.ui.dialogs.UILogonDialog.actionPerformed(UILogonDialog.java:335)
09-May-2007_02-20-18:     at
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
09-May-2007_02-20-18:     at
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
09-May-2007_02-20-18:     at
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
09-May-2007_02-20-18:     at javax.swing.DefaultButtonModel.setPressed(Unknown
Source)
09-May-2007_02-20-18:     at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
09-May-2007_02-20-18:     at java.awt.Component.processMouseEvent(Unknown
Source)
09-May-2007_02-20-18:     at javax.swing.JComponent.processMouseEvent(Unknown
Source)
09-May-2007_02-20-18:     at java.awt.Component.processEvent(Unknown Source)
09-May-2007_02-20-18:     at java.awt.Container.processEvent(Unknown Source)
09-May-2007_02-20-18:     at java.awt.Component.dispatchEventImpl(Unknown
Source)
09-May-2007_02-20-18:     at java.awt.Container.dispatchEventImpl(Unknown
Source)
09-May-2007_02-20-18:     at java.awt.Component.dispatchEvent(Unknown Source)
09-May-2007_02-20-18:     at
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
09-May-2007_02-20-18:     at
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
09-May-2007_02-20-18:     at
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
09-May-2007_02-20-18:     at java.awt.Container.dispatchEventImpl(Unknown
Source)
09-May-2007_02-20-18:     at java.awt.Window.dispatchEventImpl(Unknown Source)
09-May-2007_02-20-18:     at java.awt.Component.dispatchEvent(Unknown Source)
09-May-2007_02-20-18:     at java.awt.EventQueue.dispatchEvent(Unknown Source)
09-May-2007_02-20-18:     at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
09-May-2007_02-20-18:     at
java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
09-May-2007_02-20-18:     at
java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
09-May-2007_02-20-18:     at java.awt.Dialog$1.run(Unknown Source)
09-May-2007_02-20-18:     at java.awt.event.InvocationEvent.dispatch(Unknown
Source)
09-May-2007_02-20-18:     at java.awt.EventQueue.dispatchEvent(Unknown Source)
09-May-2007_02-20-18:     at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
09-May-2007_02-20-18:     at
java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
09-May-2007_02-20-18:     at java.awt.EventDispatchThread.pumpEvents(Unknown
Source)
09-May-2007_02-20-18:     at java.awt.EventDispatchThread.pumpEvents(Unknown
Source)
09-May-2007_02-20-18:     at java.awt.EventDispatchThread.run(Unknown Source)
09-May-2007_02-20-18: Error: (DBConnectionManager.getConnection) Database 'UTS
Capstone' not found.
Comment 6 Michelle Bachler 2007-05-10 10:11:25 BST
The log does not really help as the error message is to do with problems
loading the toolbar XML. 

If you do nothing but open Compendium and try and backup, is this all you get
in the log file?

I am trying to remember what we already tried. So sorry if I am repeating
myself. You say it is a small project, but does it have any really large
attched reference files? 

Did you already send me an XML export to Zip with references, so I can see what
the issue is?

If you can successfully export to XML zip, maybe you could create a new
project, import the XML and tell me if that backups up?
Comment 7 Damien 2007-05-11 02:02:04 BST
> If you do nothing but open Compendium and try and backup, is this all you get
> in the log file?

Yes it is. I deleted all the log files, opened Compendium and that's all I get.
As you said, there isn't anything there about backup!

However, I have discovered how to reproduce the bug, at least on my machine.

I CAN backup to zip successfully, with all files referenced copied into the
linked files sub folder. To do this I did:

1) Opened Compendium and opened the database straight away.
2) Selected Backup from the File menu
3) Exported to Zip

All went smoothly (resultant Zip file was about 55k)

Now to get it to lock up:

1) Open Compendium and select Cancel to not open a database
2) From the file menu, select Project Management
3) Click the Backup button.
4) Enter username and password as requested
5) Select the Export to zip option.

The above steps result in a progress dialog that sits at 0% and I have to kill
the program from the Task Manager.

So in short, backup to zip works for me, yet only when the project is open.

Regards,

Damien.
Comment 8 Michelle Bachler 2007-05-11 09:18:12 BST
OK, I will do some testing here.
Comment 9 Michelle Bachler 2007-05-16 10:54:54 BST
I almost never backup from there, so had not looked at this option before when
testing backup for your bug report. I get exactly the same result as you. So
there is a definate bug there. I will invesgiate and fix for the next release.

At leaset there is a work around for now. Thanks for reporting this in so much
detail. It really helps.
Comment 10 Michelle Bachler 2007-05-16 13:05:00 BST
OK. I have fixed it. 
Thanks again for finding a reproducable path for the bug. It helped me
instantly identify the bug and fix it.
Comment 11 Damien 2007-05-22 04:40:22 BST
No problem, glad to be of help!

Damien.