[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1293
  • Last Modified:

FRM-40654 error

when I try to update arecord from a form I am receiving the following error FRM_40654 Record has been updated by another user. Re-query no other users are int he system.
0
uTab
Asked:
uTab
  • 10
  • 6
  • 3
1 Solution
 
jaramillCommented:
Cause:      Another user has updated this record since you performed a query and has changed at least one field in the record.  Your actions have not changed the record in memory.

Action:      You can update or delete this record now only if another user has restored the field values back to the way they were when you performed the query.  Otherwise, you must re-query to fetch and display the new record into the form before you can update or delete it.

Level:      20

Type:      Error


My guess is to logout the system and log back in and see if you get the error again.  If you do then see if you have any Form triggers such (PRE-UPDATE, KEY-COMMIT, POST-UPDATE) and check the logic to see if you have any commit statements in there that you shouldn't have at all.

Gio
0
 
uTabAuthor Commented:
There are no other users in the system. I can log out and log back in and I still have the error.  I have also ensure the users has select/insert/update/delete on the updateable view
0
 
jaramillCommented:
Is the data block in your form based on a view?  Did you check for any of the triggers I mentioned?

Gio
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
uTabAuthor Commented:
Checked the triggers no problem and it is a view
0
 
uTabAuthor Commented:
I even tried recreating the user.
0
 
jaramillCommented:
What are the steps that lead to the error?  Do you do the following?

1. Query 1 or all records within the form.
2. Then make a change to a field within the form.
3. Then commit the record by hitting the Save button on the form?

Can you check the permissions granted on the view?  As well as the user doing the commit?

Gio
0
 
uTabAuthor Commented:
I have checked all the permissions, just got done doing that for the tenth time. All records are queried. As soon as I type the first letter in the field I get the error. This means I never get to the point of hitting commit or save.
0
 
jaramillCommented:
Oh wait.  Search in all your triggers for any code that changes the status of the form/block/record/item to "CHANGED".  That could be the problem.

Gio
0
 
uTabAuthor Commented:
Nope.
0
 
jaramillCommented:
Then try this.  Set your form to display debug messages by going to the menu Tools-->Preferences-->Runtime.  Then check off debug messages then run your form and see what triggers get executed and make sure to see what is the LAST trigger code that executes and look into the code.  Perhaps you can post the code.

Gio
0
 
uTabAuthor Commented:
I am running 10g and Tools-->Preferences-->Runtime is not an option.  When I say display error i Get nothing.
0
 
jaramillCommented:
Oh you're running Oracle Developer 10g??  Then in that case I have no experience with it.  I have up to Oracle 6i knowledge.  But the suggestions I gave you before should've been applicable to your situation.  Sorry, but I'm out of ideas.  Hopefully someone else will jump in here.  Try also to post it in the 3rd Party Application tools section.

Gio
0
 
uTabAuthor Commented:
Thanks for trying
0
 
sapnamCommented:
I am joining in here very late, but uTab, are you still having the problem?
0
 
uTabAuthor Commented:
Yes, I am still having the problem. I will update you ont he issue.  When I user opens the form records are queried. If a user changes a record they cannot make changes to that record again. I am unsure of why this is happening.  A commit; is being issued.
0
 
sapnamCommented:
Your form is based on a view. Is the view based on only one table or is a complex view formed by join of two or more tables.  Is the error encountered as soon as you attempt to update or when you attempt to save ?
0
 
uTabAuthor Commented:
It is not based on a view but a procedure.  I am able to update and commit once on a specific record, after than I am not able to requery the record and change it again.
0
 
sapnamCommented:
Can you briefly describe what the procedure does and where do you want records to be inserted / updated by this form
0
 
uTabAuthor Commented:
It a query/insert/update procedure that gathers records from two different tables. Contact and person.  If I had created a view it would not be updateable.  The wierd part is that you can update the record once but not twice.  This is true even if you logout and log back in.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 10
  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now