Skip to main content
Post a question

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Getting the famous a get change operation.. a record was already locked.

Posted on 25 Mar 2022 19:58:44 by 18

Hello ive seen in some cases by deleting DYNAMICS..SY00800, DYNAMICS..SY00801, dex lock dex sessions, resolves the issue

I did make sure no one was in GP and completed the steps but the error still there when trying to post a batch and doing de GL substitution.

does anyone know  if there is something else to delete 

pastedimage1648238198110v1.png

thanks

Categories:
  • Virgilio Profile Picture
    Virgilio 18 on 29 Mar 2022 at 17:52:23
    RE: Getting the famous a get change operation.. a record was already locked.

    Hello I finally found the issue, someone enabled the Separate payment Distribution, in Administration>Setup>Company>Company, Options button, Unmarked 'Separate Payment Distribution'

    so that did not go well with the custom function to add the proper GL.

    once the function was disabled, i just had to use a macro to delete and replace the proper distribution transaction by transaction to be able to post the batch.

    do not have more technical info about the customization, but I'm glad it got resolved as I had the whole accounting team after me.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,926 Most Valuable Professional on 29 Mar 2022 at 04:03:25
    RE: Getting the famous a get change operation.. a record was already locked.

    Has the developer of the code worked out how they are managing to execute a change first table command while an existing record is already locked?

  • Virgilio Profile Picture
    Virgilio 18 on 28 Mar 2022 at 13:42:35
    RE: Getting the famous a get change operation.. a record was already locked.

    Good morning, I just found out that the function GL substitution is a custom created for us, and the problem comes from there.

    thanks for everyone's help

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,926 Most Valuable Professional on 26 Mar 2022 at 04:06:42
    RE: Getting the famous a get change operation.. a record was already locked.

    A get/change error because a a record was already locked is a Dexterity error. Nothing at the SQL level will help.

    The SOP_Distribution_WORK_HIST_Temp table does not exist in the core Dynamics.dic product dictionary.

    I cannot find any reference to it in my installs, so I think it must belong to a 3rd party addon product.

    You can use GP Power Tools Resource Information window in Table mode to quickly identify the product.

    The error occurs when attempting to place a "passive" lock on a record when there is already a record locked on that table.

    Once you have identified the product, it will be up to the developer of that product to fix the issue in their code.

    Regards

    David

  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,134 on 25 Mar 2022 at 21:08:17
    RE: Getting the famous a get change operation.. a record was already locked.

    I don't recognize (Abort POS posting due to POS Company Error -5) as a core GP error message.  Could there be an add-in product that is involved?

    [Has anything changed in the environment - Updates? Processing change? New add-in?  Does error happen in TEST or TWO company? - that may be related?  Have you checked the DBO ownership and run grant.sql to confirm the DBO owns all the objects?]

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on 25 Mar 2022 at 20:59:02
    RE: Getting the famous a get change operation.. a record was already locked.

    Check your SY00500 table for any batches with someone's GP login name. With everyone out of GP do the usual check again:

    SELECT * FROM DYNAMICS..ACTIVITY

    SELECT * FROM DYNAMICS..SY00800

    SELECT * FROM DYNAMICS..SY00801

    SELECT * FROM TEMPDB..DEX_SESSION

    SELECT * FROM TEMPDB..DEX_LOCK

    Make sure no records are returned. If any are returned delete them. This sure sounds like some SQL locking issue.

  • Virgilio Profile Picture
    Virgilio 18 on 25 Mar 2022 at 20:14:20
    RE: Getting the famous a get change operation.. a record was already locked.

    Hi, thanks i did try all that last night, what i find funny is that last night after doing all that I went to an invoice selected distributions, clicked ok save and I get the exact same error

    I will try again deleting and restarting the SQL server, hopefully is works

    also if I try to post a single transaction I get the error (Abort POS posting due to POS Company Error -5) and the transaction disappears

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on 25 Mar 2022 at 20:03:58
    RE: Getting the famous a get change operation.. a record was already locked.

    Have everyone exit GP and try again. If that does not work try restarting SQL or rebooting the GP/SQL server.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans