Announcements
30
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
thanks
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.
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?
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
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?]
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.
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
Have everyone exit GP and try again. If that does not work try restarting SQL or rebooting the GP/SQL server.
#1
Martin Dráb
601
Most Valuable Professional
#2
Abhilash Warrier
416
#3
Adis
384
Super User 2025 Season 1
Share
Report
All responses (
Answers (
