Page 1 of 1

Cannot delete Standard Checking Account

PostPosted: Fri Jan 01, 2016 8:17 am
by DaveM
I have managed to delete all but the Standard Checking Account from my list of accounts. When I try to permanently delete this account, I get:
Error has occurred
Error message is printed below. Click the "Details" button to view the detailed error description.
Unable to save data

I have submitted a bug but not sure if there is anything else I should do.

Re: Cannot delete Standard Checking Account

PostPosted: Fri Jan 01, 2016 2:15 pm
by mthadm
We will take look. Can you rename the account?

Thanks

Re: Cannot delete Standard Checking Account

PostPosted: Sat Jan 02, 2016 3:20 pm
by DaveM
I have been able to rename it but still unable to delete it and received the same error. Here are the details:
java.sql.SQLException: DELETE on table 'MMY_ACCOUNT' caused a violation of foreign key constraint 'F_MMY_FOLIO_ACCNT' for key (1). The statement has been rolled back.
DELETE FROM MMY_ACCOUNT WHERE MMY_ACCOUNT.ID=1
at MoneyRuntimeException.DELETE on table 'MMY_ACCOUNT' caused a violation of foreign key constraint 'F_MMY_FOLIO_ACCNT' for key (1). The statement has been rolled back.
DELETE FROM MMY_ACCOUNT WHERE MMY_ACCOUNT.ID=1(Original Exception::0)
at com.mth.mymoney.db.LoggableStatement.executeUpdate(LoggableStatement.java:441)
at com.mth.mymoney.shared.datatypes.dao.IdentifiableDAO.deleteRecord(IdentifiableDAO.java:669)
at com.mth.mymoney.shared.datatypes.dao.IdentifiableDAO.deleteRecord(IdentifiableDAO.java:609)
at com.mth.mymoney.shared.datatypes.dao.AccountDAO.delete(AccountDAO.java:1044)
at com.mth.mymoney.ui.actions.AccountsTableActions$actionDeleteEntry.actionPerformed(AccountsTableActions.java:461)
at com.mth.mymoney.core.SystemActionHub.routeCommand(SystemActionHub.java:228)
at com.mth.mymoney.core.SystemActionHub.actionPerformed(SystemActionHub.java:181)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at com.jidesoft.plaf.basic.BasicJideButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
at java.awt.Component.processMouseEvent(Component.java:6516)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
at java.awt.Component.processEvent(Component.java:6281)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4872)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:694)
at java.awt.EventQueue$3.run(EventQueue.java:692)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:708)
at java.awt.EventQueue$4.run(EventQueue.java:706)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
at com.mth.mymoney.thread.SmartEventQueue.dispatchEvent(SmartEventQueue.java:95)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

Re: Cannot delete Standard Checking Account

PostPosted: Sun Jan 03, 2016 8:23 pm
by mthadm
Thanks - we did locate a bugzilla report with your submission few days ago

Re: Cannot delete Standard Checking Account

PostPosted: Mon Jan 04, 2016 6:06 am
by DaveM
Thanks in advance for any help you can provide.

Re: Cannot delete Standard Checking Account

PostPosted: Sat Jan 09, 2016 3:05 pm
by DaveM
Any news on this yet?

Thanks again.

Dave

Re: Cannot delete Standard Checking Account

PostPosted: Sun Jan 10, 2016 11:47 am
by mthadm
We are working on a fix, if you shoot us an email to info@mthbuilt.com we will give you test version to try on your box before releasing it

Does the workaround of simply renaming the account not work for you?

Thanks

Re: Cannot delete Standard Checking Account

PostPosted: Sun Jan 17, 2016 7:40 am
by DaveM
Not really, I have all my accounts set up. This one is a US account. ITs not critical but pretty untidy as I do not need any more accounts

Re: Cannot delete Standard Checking Account

PostPosted: Tue Jun 07, 2016 10:17 am
by fleahead
I am having the same problem. I can rename the account, but it will not allow me to delete it. Has a fix been found?