Re: Help with updateValuesInRowDescribedByQualifier
A similar issue I had recently and there was another post one or two days ago pointing to the same thing: trailing spaces! My case: an attribute in the DB was set to be of type char. In the EOModel I had specified varchar2 for the external datatype (this is Oracle). With char you get a right space padded value back. This value was then used in a ERD2WEditToOneRelationship popup. The value got used in the generated HTML as the identifier for the selection. HTML strips all trailing spaces thus upon submitting the data the selection never matched anything and so the to-one relationship never got set. As this was an optional relationship no validate for save error or anything similar showed up. It took quite some time to first discover that there was an issue and again some/a lot more time to find out what caused it. At the end the problem came from the customer forgetting one essential step in a manual upgrade of his database. Morale of this story: - Always check your SQL where clauses (and the values!) - Always think of possible trailing spaces, not only in SQL clauses! ---markus-- On 09.10.2013, at 20:43, Timothy Worman li...@thetimmy.com wrote: +1 Turn on SQL logging and look at the exact sql that is being executed to update the row in the database. Test the “WHERE” clause in the update statement and see if it is as it should be for the row in the database. Tim UCLA GSEIS On Oct 9, 2013, at 9:30 AM, John Huss johnth...@gmail.com wrote: This is an optimistic locking error - the record was changed by another user concurrently or you have precision differences (like in NSTimestamps) that are causing the DB and memory to not match. On Wed, Oct 9, 2013 at 8:59 AM, Jesse Tayler jtay...@oeinc.com wrote: what’s this? unknown source? caught my eye... at boise.app.components.PersonnelDetail.inviteUser(Unknown Source) yes, it does seem like maybe your model is out of sync, at least you’re not getting much information back about it in the trace. did you turn on SQL debugging and generally check out that method inviteUser? On Oct 9, 2013, at 9:52 AM, Paul Yu p...@mac.com wrote: Greetings I'm getting errors like this in my production system. What should I be looking for to fix these type of issues? I saw a previous post that the EOModel may be out of synch with the DB? Thanks in advance... Paul *** UNCAUGHT EXCEPTION *** com.webobjects.eoaccess.EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier er.extensions.jdbc.ERXJDBCAdaptor$Channel method failed to update row in database at com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) at com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6216) at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1176) at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1099) at boise.app.components.PersonnelDetail.inviteUser(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:636) at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1134) at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1324) at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1736) at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:447) at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212) at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1804) at boise.components.BoiseComponent.valueForKeyPath(Unknown Source) at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:50) at er.extensions.components.ERXComponentUtilities.valueForBinding(ERXComponentUtilities.java:539) at er.extensions.components.ERXDynamicElement.valueForBinding(ERXDynamicElement.java:161) at er.ajax.AjaxSubmitButton.handleRequest(AjaxSubmitButton.java:330) at er.ajax.AjaxSubmitButton.invokeAction(AjaxSubmitButton.java:320) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at
Re: Help with updateValuesInRowDescribedByQualifier
I ran into this as well. To prevent trailing spaces from getting added, you can set er.extensions.ERXGenericRecord.shouldTrimSpaces=true. I just re-created my pull-request that excludes read-only attributes from being touched: https://github.com/wocommunity/wonder/pull/495 You'll obviously still have to get rid of existing trailing spaces in some other way. Fabian Am 11.10.2013 um 11:37 schrieb Markus Ruggiero: A similar issue I had recently and there was another post one or two days ago pointing to the same thing: trailing spaces! My case: an attribute in the DB was set to be of type char. In the EOModel I had specified varchar2 for the external datatype (this is Oracle). With char you get a right space padded value back. This value was then used in a ERD2WEditToOneRelationship popup. The value got used in the generated HTML as the identifier for the selection. HTML strips all trailing spaces thus upon submitting the data the selection never matched anything and so the to-one relationship never got set. As this was an optional relationship no validate for save error or anything similar showed up. It took quite some time to first discover that there was an issue and again some/a lot more time to find out what caused it. At the end the problem came from the customer forgetting one essential step in a manual upgrade of his database. Morale of this story: - Always check your SQL where clauses (and the values!) - Always think of possible trailing spaces, not only in SQL clauses! ---markus-- On 09.10.2013, at 20:43, Timothy Worman li...@thetimmy.com wrote: +1 Turn on SQL logging and look at the exact sql that is being executed to update the row in the database. Test the “WHERE” clause in the update statement and see if it is as it should be for the row in the database. Tim UCLA GSEIS On Oct 9, 2013, at 9:30 AM, John Huss johnth...@gmail.com wrote: This is an optimistic locking error - the record was changed by another user concurrently or you have precision differences (like in NSTimestamps) that are causing the DB and memory to not match. On Wed, Oct 9, 2013 at 8:59 AM, Jesse Tayler jtay...@oeinc.com wrote: what’s this? unknown source? caught my eye... at boise.app.components.PersonnelDetail.inviteUser(Unknown Source) yes, it does seem like maybe your model is out of sync, at least you’re not getting much information back about it in the trace. did you turn on SQL debugging and generally check out that method inviteUser? On Oct 9, 2013, at 9:52 AM, Paul Yu p...@mac.com wrote: Greetings I'm getting errors like this in my production system. What should I be looking for to fix these type of issues? I saw a previous post that the EOModel may be out of synch with the DB? Thanks in advance... Paul *** UNCAUGHT EXCEPTION *** com.webobjects.eoaccess.EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier er.extensions.jdbc.ERXJDBCAdaptor$Channel method failed to update row in database at com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) at com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6216) at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1176) at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1099) at boise.app.components.PersonnelDetail.inviteUser(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:636) at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1134) at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1324) at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1736) at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:447) at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212) at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1804) at boise.components.BoiseComponent.valueForKeyPath(Unknown Source) at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:50) at
Re: Help with updateValuesInRowDescribedByQualifier
what’s this? unknown source? caught my eye... at boise.app.components.PersonnelDetail.inviteUser(Unknown Source) yes, it does seem like maybe your model is out of sync, at least you’re not getting much information back about it in the trace. did you turn on SQL debugging and generally check out that method inviteUser? On Oct 9, 2013, at 9:52 AM, Paul Yu p...@mac.com wrote: Greetings I'm getting errors like this in my production system. What should I be looking for to fix these type of issues? I saw a previous post that the EOModel may be out of synch with the DB? Thanks in advance... Paul *** UNCAUGHT EXCEPTION *** com.webobjects.eoaccess.EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier er.extensions.jdbc.ERXJDBCAdaptor$Channel method failed to update row in database at com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) at com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6216) at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1176) at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1099) at boise.app.components.PersonnelDetail.inviteUser(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:636) at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1134) at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1324) at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1736) at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:447) at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212) at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1804) at boise.components.BoiseComponent.valueForKeyPath(Unknown Source) at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:50) at er.extensions.components.ERXComponentUtilities.valueForBinding(ERXComponentUtilities.java:539) at er.extensions.components.ERXDynamicElement.valueForBinding(ERXDynamicElement.java:161) at er.ajax.AjaxSubmitButton.handleRequest(AjaxSubmitButton.java:330) at er.ajax.AjaxSubmitButton.invokeAction(AjaxSubmitButton.java:320) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:116) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components.conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:108) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:116) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components.conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:108) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components._private.ERXWOForm.invokeAction(ERXWOForm.java:218) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.ajax.AjaxDynamicElement.invokeAction(AjaxDynamicElement.java:50) at er.ajax.AjaxUpdateContainer.invokeAction(AjaxUpdateContainer.java:83) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:1079) at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:168)
Help with updateValuesInRowDescribedByQualifier
Greetings I'm getting errors like this in my production system. What should I be looking for to fix these type of issues? I saw a previous post that the EOModel may be out of synch with the DB? Thanks in advance... Paul *** UNCAUGHT EXCEPTION *** com.webobjects.eoaccess.EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier er.extensions.jdbc.ERXJDBCAdaptor$Channel method failed to update row in database at com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) at com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6216) at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1176) at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1099) at boise.app.components.PersonnelDetail.inviteUser(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:636) at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1134) at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1324) at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1736) at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:447) at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212) at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1804) at boise.components.BoiseComponent.valueForKeyPath(Unknown Source) at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:50) at er.extensions.components.ERXComponentUtilities.valueForBinding(ERXComponentUtilities.java:539) at er.extensions.components.ERXDynamicElement.valueForBinding(ERXDynamicElement.java:161) at er.ajax.AjaxSubmitButton.handleRequest(AjaxSubmitButton.java:330) at er.ajax.AjaxSubmitButton.invokeAction(AjaxSubmitButton.java:320) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:116) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components.conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:108) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:116) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components.conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:108) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components._private.ERXWOForm.invokeAction(ERXWOForm.java:218) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.ajax.AjaxDynamicElement.invokeAction(AjaxDynamicElement.java:50) at er.ajax.AjaxUpdateContainer.invokeAction(AjaxUpdateContainer.java:83) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:1079) at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:168) at com.webobjects.appserver._private.WOComponentReference.invokeAction(WOComponentReference.java:127) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:116) at
Re: Help with updateValuesInRowDescribedByQualifier
This is an optimistic locking error - the record was changed by another user concurrently or you have precision differences (like in NSTimestamps) that are causing the DB and memory to not match. On Wed, Oct 9, 2013 at 8:59 AM, Jesse Tayler jtay...@oeinc.com wrote: what’s this? unknown source? caught my eye... at boise.app.components.PersonnelDetail.inviteUser(Unknown Source) yes, it does seem like maybe your model is out of sync, at least you’re not getting much information back about it in the trace. did you turn on SQL debugging and generally check out that method inviteUser? On Oct 9, 2013, at 9:52 AM, Paul Yu p...@mac.com wrote: Greetings I'm getting errors like this in my production system. What should I be looking for to fix these type of issues? I saw a previous post that the EOModel may be out of synch with the DB? Thanks in advance... Paul *** UNCAUGHT EXCEPTION *** com.webobjects.eoaccess.EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier er.extensions.jdbc.ERXJDBCAdaptor$Channel method failed to update row in database at com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) at com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6216) at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1176) at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1099) at boise.app.components.PersonnelDetail.inviteUser(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:636) at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1134) at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1324) at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1736) at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:447) at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212) at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1804) at boise.components.BoiseComponent.valueForKeyPath(Unknown Source) at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:50) at er.extensions.components.ERXComponentUtilities.valueForBinding(ERXComponentUtilities.java:539) at er.extensions.components.ERXDynamicElement.valueForBinding(ERXDynamicElement.java:161) at er.ajax.AjaxSubmitButton.handleRequest(AjaxSubmitButton.java:330) at er.ajax.AjaxSubmitButton.invokeAction(AjaxSubmitButton.java:320) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:116) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components.conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:108) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:116) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components.conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:108) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components._private.ERXWOForm.invokeAction(ERXWOForm.java:218) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.ajax.AjaxDynamicElement.invokeAction(AjaxDynamicElement.java:50) at er.ajax.AjaxUpdateContainer.invokeAction(AjaxUpdateContainer.java:83) at
Re: Help with updateValuesInRowDescribedByQualifier
+1 Turn on SQL logging and look at the exact sql that is being executed to update the row in the database. Test the “WHERE” clause in the update statement and see if it is as it should be for the row in the database. Tim UCLA GSEIS On Oct 9, 2013, at 9:30 AM, John Huss johnth...@gmail.com wrote: This is an optimistic locking error - the record was changed by another user concurrently or you have precision differences (like in NSTimestamps) that are causing the DB and memory to not match. On Wed, Oct 9, 2013 at 8:59 AM, Jesse Tayler jtay...@oeinc.com wrote: what’s this? unknown source? caught my eye... at boise.app.components.PersonnelDetail.inviteUser(Unknown Source) yes, it does seem like maybe your model is out of sync, at least you’re not getting much information back about it in the trace. did you turn on SQL debugging and generally check out that method inviteUser? On Oct 9, 2013, at 9:52 AM, Paul Yu p...@mac.com wrote: Greetings I'm getting errors like this in my production system. What should I be looking for to fix these type of issues? I saw a previous post that the EOModel may be out of synch with the DB? Thanks in advance... Paul *** UNCAUGHT EXCEPTION *** com.webobjects.eoaccess.EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier er.extensions.jdbc.ERXJDBCAdaptor$Channel method failed to update row in database at com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) at com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6216) at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1176) at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1099) at boise.app.components.PersonnelDetail.inviteUser(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:636) at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1134) at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1324) at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1736) at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:447) at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212) at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1804) at boise.components.BoiseComponent.valueForKeyPath(Unknown Source) at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:50) at er.extensions.components.ERXComponentUtilities.valueForBinding(ERXComponentUtilities.java:539) at er.extensions.components.ERXDynamicElement.valueForBinding(ERXDynamicElement.java:161) at er.ajax.AjaxSubmitButton.handleRequest(AjaxSubmitButton.java:330) at er.ajax.AjaxSubmitButton.invokeAction(AjaxSubmitButton.java:320) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:116) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components.conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:108) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:116) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components.conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:108) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components._private.ERXWOForm.invokeAction(ERXWOForm.java:218) at
