Whenever I try to remove Company Access for a user, I receive the following messages:
GPS Error RevokeUserAudit: 58
I click OK then I get the following message:
SQL Error RevokeUserAudit: 2812 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'CNC.mxCallRevokeUserAudit". (CNC is database name)
I click OK again and then I get the following message:
ODBC Error RevokeUserAudit: 37000
It happens with multiple users on multiple companies and I can't seem to find anything about it online anywhere.
Any help would be greatly appreciated.
Still looking for an answer to this. Anybody got any ideas?
Do you have any 3rd party add-ins or customizations for GP? I am not seeing any stored procedures in a default installation of GP that start with 'mx'.
We have the following 3rd party non-microsoft add-ons:
Changer by Renaissance Group
KTL PR Security
Is it trying to call a stored procedure that updates some type of audit when I delete a user? I can't figure it out. It happens on 3 different live and 3 different test companies and only when I remove a user from the company. It still removes the user though.
I am not familiar with the naming conventions of all these products, so I would check with them to see if this is one of their stored procedures. Most likely it's not Changer or Mekorma, so I would probably start with the other 2.
Did you ever come up with a solution to this? I'm having the same problem with no third party software loaded.
I still haven't resolved this issue. If you come with anything, let me know.
Chris & Kimberly,
The issue is due to "Audit Trails" module. If your license covers this module, then the respective stored procedures seem to be created on all Company Databases. If your license do not cover this module, then in my opinion, the respective SQL objects are not created properly.
Thus the above error. I received it today and had to debug it only to find that it's of "Audit Trails" module.
Better option is to remove this product from your environment, if you do not have it covered in your GP license.
Hope that helps.
I get the same issue and once we registered Audit Trails it went a way for existing users but when we setup a new user it comes back. We have tried installing Audit Trails again under Microsoft Dynamics GP menu >> Tools >> Setup >> Company >> Audit Trails >> Install Audit Trails but we still get the error. We tried the install before and after we registered audit trails. Any other ideas on what is causing it?
Angie, try disabling this product and perform the same operation. If you don't get the error anymore, rest assured that something is wrong with Audit Trails module. If the issue still persist after disabling, you have to take the SQL profile or Dex Script Log to learn more about this issue. No other option that comes to my mind at this moment.
Business Applications communities