Issue saving, submitting or updating record (Invalid Update; Match not found, reset to original)

[jmichael]

Hi All,

Having an urgent issue, not able to update record because of an invalid error. I've checked my business rules, and nothing is running on a related table that would be conflicting. Not sure where to go or what a solution could be. I've also checked through my referenced tables and those sources, there is data present, don't think it could be formatting or lack of a value. I have a Client Script pulling data from one table based on a core value and its populating a description (without error) but not the measurement piece. My info icon is showing no preview available but so once cleared if I manually set the same value as my client script fills in manually I can save the record just fine. This is not making sense, I can clarify if I haven't explained it well.

TL;DR Issue:

Updating record via a reference.

When saving it clears reference and says Match not found, reset to original causing an Invalid update.

Can update the record manually with same value and save.

Similar threads with no solutions ::

Invalid update

Invalid reference on close, submit, or update issue causes an invalid update.

New table entry fails when referenced table has a display field

kalai pradeepksharma

[prashantdharne]

Hi Mike,

Were you able to find the root cause?

[madhavm]

This happens when you update the reference field with value rather than sys_id of the record.

[lsheets]

Had the same problem.  Changed the script include to return <table>.column_name  which returns the sys_id instead of <table>.getDisplayValue('column_name') which returned the name.  Fixed the problem.  Thanks for the solution madhavm.

[Maxwell3]

Hello,

I am having the same issue. I implemented your solution but now the fields are not being populated, but the error message went away. Any thoughts on this?