Microsoft Dynamics GP (Archived)

User Access Setup Error: GPS Error RevokeUserAudit: 58

(0) Share

Report

Posted on by Chris Baltas

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.

Thanks,

Chris

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Chris Baltas 80 on at

Like (0)

Report

Still looking for an answer to this. Anybody got any ideas?

Thanks,

Chris

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (0)

Report

Chris,

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'.

Was this reply helpful? Yes No
Chris Baltas 80 on at

Like (0)

Report

Victoria,

We have the following 3rd party non-microsoft add-ons:

Changer by Renaissance Group

KTL PR Security

Mekorma MICR

Greenshades Center

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.

Chris

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (0)

Report

Chris,

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.

Was this reply helpful? Yes No
Kimberley Stevens 720 on at

Like (0)

Report

Chris,

Did you ever come up with a solution to this? I'm having the same problem with no third party software loaded.

Thanks!

Kimberley

Was this reply helpful? Yes No
Chris Baltas 80 on at

Like (0)

Report

Kimberly,

I still haven't resolved this issue. If you come with anything, let me know.

Thanks,

Chris

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Vaidy

Was this reply helpful? Yes No
Angie Randazzo 355 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No