Share
Report
214Hey
I hope someone can help? we have a client on Dynamics GP 2016 R2 they have upgraded from 2010 and now when they go into Admin > Setup > Analytical accounting > User Access and choose the Trn Dimension and Trn Dimension Code then add a user and when they save the get the following error:
A get/change next operation on table "aaUserAccessToCodesSetup" failed. A record was already locked.
I have ran a SQL trace and nothing seems to be coming up that will point to what the issue is.
I have also got the dexsql log and there are a couple of errors showing 'Cannot insert duplicate key' and 'Cannot drop the procedure because it does not exist or you do not have permissions'
if you close the window and click ok on the message it does save the changes you have made but it comes up every time.
I have ran a check links on the GL and analytical accounting but there isn't anything for AA setup just transactional data.
I also cleared the dex_session, dex_lock, activity, SY00800 and SY00801 tables and still get the same error
Can anyone help?
*This post is locked for comments
All responses (
Answers (
