Can't modify or delete Calculated Fields

User 8a7878ec6d

30-01-2015 09:47:30

Hi,


IJC 14.12.15.0, local Derby database: I have Calculated Fields (decimal numbers) that use fields from a master table through a relationship (here Parent Weight from a Structure table). I was forced to remove the relationship in order to fix something else. After recreating the relationship, I cannot modify or even delete the Calculated Fields, all options are just greyed out. Neither can I revalidate the Calculated Field. If I remove the variable and expression rows from the Field Definition, and then hit Apply, it says:


Error occurred while setting the changes: Object is read-only as it is used by other user.


Help!


Evert


com.im.df.api.support.ObjectOwnedByOtherUserException: Object is read-only as it is owned by other user
    at com.im.df.impl.db.AlwaysLockedLockable.obtainLock(AlwaysLockedLockable.java:45)
    at com.im.ijc.core.api.util.IJCCoreUtils.lock(IJCCoreUtils.java:243)
    at com.im.ijc.core.api.util.IJCCoreUtils.applyChangesWithProgress(IJCCoreUtils.java:189)
    at com.im.ijc.core.api.util.IJCCoreUtils.applyChangesWithProgress(IJCCoreUtils.java:183)
    at com.im.ijc.core.api.ui.DFCustomizerEditor.applyButtonActionPerformed(DFCustomizerEditor.java:166)
    at com.im.ijc.core.api.ui.DFCustomizerEditor.access$100(DFCustomizerEditor.java:39)
    at com.im.ijc.core.api.ui.DFCustomizerEditor$2.actionPerformed(DFCustomizerEditor.java:108)
    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.plaf.basic.BasicButtonListener.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.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$200(Unknown Source)
    at java.awt.EventQueue$3.run(Unknown Source)
    at java.awt.EventQueue$3.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue$4.run(Unknown Source)
    at java.awt.EventQueue$4.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:162)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.WaitDispatchSupport$2.run(Unknown Source)
    at java.awt.WaitDispatchSupport$4.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.awt.WaitDispatchSupport.enter(Unknown Source)
    at java.awt.Dialog.show(Unknown Source)
    at org.netbeans.core.windows.services.NbPresenter.superShow(NbPresenter.java:1052)
    at org.netbeans.core.windows.services.NbPresenter.doShow(NbPresenter.java:1086)
    at org.netbeans.core.windows.services.NbPresenter.run(NbPresenter.java:1074)
    at org.netbeans.core.windows.services.NbPresenter.run(NbPresenter.java:126)
    at org.openide.util.Mutex.doEventAccess(Mutex.java:1361)
    at org.openide.util.Mutex.readAccess(Mutex.java:271)
    at org.netbeans.core.windows.services.NbPresenter.show(NbPresenter.java:1059)
    at java.awt.Component.show(Unknown Source)
    at java.awt.Component.setVisible(Unknown Source)
    at java.awt.Window.setVisible(Unknown Source)
    at java.awt.Dialog.setVisible(Unknown Source)
    at com.im.ijc.widgets.table.settings.TableEditorPanel.display(TableEditorPanel.java:179)
    at com.im.ijc.widgets.table.WBTableWidget.customizeUISettings(WBTableWidget.java:691)
    at com.im.ijc.core.api.actions.IJCWidgetPropertiesAction.actionPerformed(IJCWidgetPropertiesAction.java:147)
    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.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.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$200(Unknown Source)
    at java.awt.EventQueue$3.run(Unknown Source)
    at java.awt.EventQueue$3.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue$4.run(Unknown Source)
    at java.awt.EventQueue$4.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:162)
    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)
Caused by: java.lang.RuntimeException
    ... 99 more

ChemAxon 26d92e5dcd

30-01-2015 10:05:20

Dear Evert,


sorry for the inconvenience. Another user already reported the same error in this forum topic https://www.chemaxon.com/forum/ftopic13621.html


We are looking into the problem.


Bests


David

User 8a7878ec6d

30-01-2015 10:56:58

Sorry for spamming...


This used to work before, and it just makes me wonder, in light of the weekly updates you roll out: do you really have enough time to check if all functionality still works every week?


Thanks,


Evert

ChemAxon 26d92e5dcd

02-02-2015 09:42:51

Dear Evert,


this is a relevant question - it might seem so, but what we are doing and constantly improving is that we are covering more and more functionality by automated tests and in addition to that, we still perform manual testing (which is performed every 2 weeks). 


The problem is that some use-cases are hard to catch, as is this case. Once something like this is reported by a customer, we deal with the issue and make sure that we test for the use-case later on in the following testing rounds.


I am once again sorry for the inconvenience


All the best


David

User 8a7878ec6d

02-02-2015 09:46:14

OK, thanks for explaining your working process, David.


I will continue to report issues and suggestions for improvements.


Best regards,


Evert