Re: Help with updateValuesInRowDescribedByQualifier

2013-10-11 Thread Fabian Peters
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: 


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  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 GSE&IS
>> 
>> On Oct 9, 2013, at 9:30 AM, John Huss  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  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  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.c

Re: Help with updateValuesInRowDescribedByQualifier

2013-10-11 Thread 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  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 GSE&IS
> 
> On Oct 9, 2013, at 9:30 AM, John Huss  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  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  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

Re: Help with updateValuesInRowDescribedByQualifier

2013-10-09 Thread Timothy Worman
+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  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  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  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.

Re: Help with updateValuesInRowDescribedByQualifier

2013-10-09 Thread John Huss
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  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  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(Aj

Re: Help with updateValuesInRowDescribedByQualifier

2013-10-09 Thread Jesse Tayler

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  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 
> e

Help with updateValuesInRowDescribedByQualifier

2013-10-09 Thread Paul Yu
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.invokeAct