Restore from backup v3.4.3 problem

Discussions around using and interfacing with the Church MLS program.
Locked
rickm
New Member
Posts: 3
Joined: Sun Apr 15, 2012 9:04 am

Restore from backup v3.4.3 problem

#1

Post by rickm »

On Sunday we received the download for MLS 3.4.3 and the update appears to go well, there was one error when I did a send/recieve after restarting MLS, but subsequent transmissions everything seemed ok. The problem we have is that we have a couple of computers (only 1 which ever transmits and received to SLC) and one we keep in sync by using the backup/restore procedure. After this update we cannot restore our backups to the same version of MLS (downloaded from the mls.lds.org website). I have completely removed MLS per the instructions on this website, and when I reinstall MLS (3.4.3) it appears normal, asking for the setup information etc. Then when I proceed to restore the backup from the other machine (same OS etc.) we get the an error. (This process has worked for years BTW). The error indicates the operation could not occur and to check the device for sufficient space. I have tried the backup file from a USB stick/hard drive etc. No change. At this point, I am concerned that we can no longer prepare "restorable" backups. Has anyone else encountered this problem or tried to do a restore from 3.4.3?

thanks!!!
giffordrb
Member
Posts: 115
Joined: Tue Mar 01, 2011 8:24 am
Location: Eagle Mountain UT

#2

Post by giffordrb »

rickm - this isn't normal behavior and I would recommend calling local unit support about it. It also might be worth starting a new thread on this forum with this issue - the title of the new thread would get more attention than this one. I can't offer support on this right now but was wondering if you could pm me your unit #? Thanks.
Ryan Gifford
MLS
nognielsen
New Member
Posts: 37
Joined: Tue Feb 14, 2012 7:54 am

#3

Post by nognielsen »

I had the same problem, still trying to find a resolution....
nognielsen
New Member
Posts: 37
Joined: Tue Feb 14, 2012 7:54 am

#4

Post by nognielsen »

I fixed the issue by giving the "clerk" account on the computer "admin" rights... I don't know if this preffered or not, as this is the first machine I've received from the church with Windows 7 on it. It seems like without a user account labled as an "admin" they weren't able to do MLS upgrades/restore from backups. As soon as I made this change the problem went away...
User avatar
aebrown
Community Administrator
Posts: 15153
Joined: Tue Nov 27, 2007 8:48 pm
Location: Draper, Utah

#5

Post by aebrown »

nognielsen wrote:I fixed the issue by giving the "clerk" account on the computer "admin" rights... I don't know if this preffered or not, as this is the first machine I've received from the church with Windows 7 on it. It seems like without a user account labled as an "admin" they weren't able to do MLS upgrades/restore from backups. As soon as I made this change the problem went away...
Giving the clerk account admin rights is not just preferred -- it is required. Any administrative computer set up following the official instructions will have a "clerk" account with admin rights.

Thanks for report this -- it will help others who may mistakenly give lesser rights to the clerk account and have similar problems.
Questions that can benefit the larger community should be asked in a public forum, not a private message.
rickm
New Member
Posts: 3
Joined: Sun Apr 15, 2012 9:04 am

#6

Post by rickm »

Just letting everyone know on this thread that the account was running with administrator priviledges. This is the error that I get on the multiple machines:

This is the exact error that I get (I would upload a screen shot of it but it comes out too small to be readable).

"An error occurred when you tried to restore the database. Please make sure you have sufficient space on the disk to which you are restoring"

And yes, I have validated space on the device that has the backup file (tried it on USB stick and on the hard disk) and the computer's hard drive is no where near full. :-)

If I was to venture a guess, it is somewhere trying to import one of the tables, because even though the restore fails, the users are loaded (all the users are populated in the login screen but it won't let me login) - Those users were not there in beginning, because on the fresh install, I only put in the 1 required administrator account. It would appear that the backup creation routine has a bug or the import funtion does or my migration to 3.4.3 failed.... Does anyone know if there is some logging that I could look at?

Thanks for everyone's help.
Attachments
mlsrestoreerror.jpg
(35.55 KiB) Downloaded 77 times
mlsrestoreerror.jpg
(72.73 KiB) Downloaded 75 times
giffordrb
Member
Posts: 115
Joined: Tue Mar 01, 2011 8:24 am
Location: Eagle Mountain UT

#7

Post by giffordrb »

rickm wrote:Does anyone know if there is some logging that I could look at?

Windows 7 = C:\ProgramData\LDS Church\MLS\data\mlslog.txt

You can also hold down the CTRL key while starting MLS - this opens a cmd window and tails the log while MLS is running.
Ryan Gifford
MLS
rickm
New Member
Posts: 3
Joined: Sun Apr 15, 2012 9:04 am

#8

Post by rickm »

Sorry for the long post but this is a snippet of the failure. You can see as the data base restore happens that I am getting a duplicate row into the database. Seems like a bad backup file was generated or a inconsistency in the database schema for this restore.

.
.
.
{Sun 2012-04-22 07:42:05} Adding table MODCES_STUDENTS
{Sun 2012-04-22 07:42:05} Adding table MODCES_SCHOOL
{Sun 2012-04-22 07:42:05} Adding table MODCES_ATTEND
[E] {Sun 2012-04-22 07:42:20} DatabaseBackupRestore: com.pointbase.me.jdbc.jdbcSQLException: Row already exists: INSERT INTO "PARENT"("ID","SURNAME1","GIVEN_NAME1","SUFFIX_NAME1","SURNAME2","GIVEN_NAME2","SUFFIX_NAME2","MRN","BIRTH_DATE","IS_MEMBER","TYPE","MEMBER_ID","LINKED_RECORD") VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?);

[*]
at com.pointbase.me.jdbc.jdbcPreparedStatement.executeUpdate([DashoPro-V2.1-110100])
at shared.mls.data.DatabaseLoadUnload.executeCmd(Unknown Source)
at shared.mls.data.DatabaseLoadUnload.load(Unknown Source)
at shared.mls.data.DatabaseLoadUnload.loadDatabase(Unknown Source)
at shared.mls.data.DBObject$1.process(Unknown Source)
at shared.mls.util.BFRestore.processBackup(Unknown Source)
at shared.mls.data.DBObject.load(Unknown Source)
at mls.util.DatabaseBackupRestore.restoreDatabase(Unknown Source)
at mls.shell.MLSActions.doDBUpdate(Unknown Source)
at mls.shell.actions.CmdRestore.doCmd(Unknown Source)
at mls.shell.CMDAction.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
com.pointbase.me.SQLException: Row already exists: INSERT INTO "PARENT"("ID","SURNAME1","GIVEN_NAME1","SUFFIX_NAME1","SURNAME2","GIVEN_NAME2","SUFFIX_NAME2","MRN","BIRTH_DATE","IS_MEMBER","TYPE","MEMBER_ID","LINKED_RECORD") VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?);
[*]
at com.pointbase.me.SQLException.a([DashoPro-V2.1-110100])
at com.pointbase.me.PreparedStatement.a([DashoPro-V2.1-110100])
at com.pointbase.me.PreparedStatement.b([DashoPro-V2.1-110100])
at com.pointbase.me.PreparedStatement.a([DashoPro-V2.1-110100])
at com.pointbase.me.PreparedStatement.executeUpdate([DashoPro-V2.1-110100])
at com.pointbase.me.jdbc.jdbcPreparedStatement.executeUpdate([DashoPro-V2.1-110100])
at shared.mls.data.DatabaseLoadUnload.executeCmd(Unknown Source)
at shared.mls.data.DatabaseLoadUnload.load(Unknown Source)
at shared.mls.data.DatabaseLoadUnload.loadDatabase(Unknown Source)
at shared.mls.data.DBObject$1.process(Unknown Source)
at shared.mls.util.BFRestore.processBackup(Unknown Source)
at shared.mls.data.DBObject.load(Unknown Source)
at mls.util.DatabaseBackupRestore.restoreDatabase(Unknown Source)
at mls.shell.MLSActions.doDBUpdate(Unknown Source)
at mls.shell.actions.CmdRestore.doCmd(Unknown Source)
at mls.shell.CMDAction.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
java.lang.Error: 3
at com.pointbase.me.SQLException.a([DashoPro-V2.1-110100])
at com.pointbase.me.h.d([DashoPro-V2.1-110100])
at com.pointbase.me.h.d([DashoPro-V2.1-110100])
at com.pointbase.me.h.d([DashoPro-V2.1-110100])
at com.pointbase.me.h.d([DashoPro-V2.1-110100])
at com.pointbase.me.h.a([DashoPro-V2.1-110100])
at com.pointbase.me.d.b([DashoPro-V2.1-110100])
at com.pointbase.me.d.b([DashoPro-V2.1-110100])
at com.pointbase.me.PreparedStatement.a([DashoPro-V2.1-110100])
at com.pointbase.me.PreparedStatement.b([DashoPro-V2.1-110100])
at com.pointbase.me.PreparedStatement.a([DashoPro-V2.1-110100])
at com.pointbase.me.PreparedStatement.executeUpdate([DashoPro-V2.1-110100])
at com.pointbase.me.jdbc.jdbcPreparedStatement.executeUpdate([DashoPro-V2.1-110100])
at shared.mls.data.DatabaseLoadUnload.executeCmd(Unknown Source)
at shared.mls.data.DatabaseLoadUnload.load(Unknown Source)
at shared.mls.data.DatabaseLoadUnload.loadDatabase(Unknown Source)
at shared.mls.data.DBObject$1.process(Unknown Source)
at shared.mls.util.BFRestore.processBackup(Unknown Source)
at shared.mls.data.DBObject.load(Unknown Source)
at mls.util.DatabaseBackupRestore.restoreDatabase(Unknown Source)
at mls.shell.MLSActions.doDBUpdate(Unknown Source)
at mls.shell.actions.CmdRestore.doCmd(Unknown Source)
at mls.shell.CMDAction.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
[E] {Sun 2012-04-22 07:43:40} Exception getting value for 36.cfar_unit
[E] {Sun 2012-04-22 07:43:40} Exception getting value for sys.finance.cubs_setup_received
[E] {Sun 2012-04-22 07:43:40} Exception getting value for sys.tes
[E] {Sun 2012-04-22 07:43:42} Exception getting value for 36.cfar_unit
[E] {Sun 2012-04-22 07:43:42} Exception getting value for 36.cfar_unit
Locked

Return to “MLS Support, Help, and Feedback”