Re: Help with updateValuesInRowDescribedByQualifier
Re: Help with updateValuesInRowDescribedByQualifier
- Subject: Re: Help with updateValuesInRowDescribedByQualifier
- From: Timothy Worman <email@hidden>
- Date: Wed, 09 Oct 2013 11:43:11 -0700
+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 GSE&IS
On Oct 9, 2013, at 9:30 AM, John Huss <email@hidden> 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 <email@hidden> 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 <email@hidden> 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)
> > 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 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.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._private.WOComponentContent.invokeAction(WOComponentContent.java:38)
> > 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 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.WOSession.invokeAction(WOSession.java:1357)
> > at com.webobjects.appserver.WOApplication.invokeAction(WOApplication.java:1745)
> > at er.extensions.appserver.ajax.ERXAjaxApplication.invokeAction(ERXAjaxApplication.java:119)
> > at er.extensions.appserver.ERXApplication.invokeAction(ERXApplication.java:1988)
> > at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedPage(WOComponentRequestHandler.java:206)
> > at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedSession(WOComponentRequestHandler.java:298)
> > at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedApplication(WOComponentRequestHandler.java:332)
> > at com.webobjects.appserver._private.WOComponentRequestHandler._handleRequest(WOComponentRequestHandler.java:369)
> > at com.webobjects.appserver._private.WOComponentRequestHandler.handleRequest(WOComponentRequestHandler.java:445)
> > at er.ajax.AjaxRequestHandler.handleRequest(AjaxRequestHandler.java:20)
> > at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1687)
> > at er.extensions.appserver.ERXApplication.dispatchRequestImmediately(ERXApplication.java:2109)
> > at er.extensions.appserver.ERXApplication.dispatchRequest(ERXApplication.java:2074)
> > at boise.appserver.BoiseApplication.dispatchRequest(Unknown Source)
> > at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144)
> > at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:226)
> > at java.lang.Thread.run(Thread.java:662)
> > _______________________________________________
> > Do not post admin requests to the list. They will be ignored.
> > Webobjects-dev mailing list (email@hidden)
> > Help/Unsubscribe/Update your Subscription:
> >
> > This email sent to email@hidden
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden