Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / User Access Setup Erro...
Microsoft Dynamics GP (Archived)

User Access Setup Error: GPS Error RevokeUserAudit: 58

(0) ShareShare
ReportReport
Posted on by Chris Baltas 80

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: User Access Setup Error: GPS Error RevokeUserAudit: 58

    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.

  • Angie Randazzo Profile Picture
    Angie Randazzo 355 on at
    Re: User Access Setup Error: GPS Error RevokeUserAudit: 58

    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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: User Access Setup Error: GPS Error RevokeUserAudit: 58

    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

  • Chris Baltas Profile Picture
    Chris Baltas 80 on at
    Re: User Access Setup Error: GPS Error RevokeUserAudit: 58

    Kimberly,

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

    Thanks,

    Chris

  • Kimberley Stevens Profile Picture
    Kimberley Stevens 720 on at
    Re: User Access Setup Error: GPS Error RevokeUserAudit: 58

    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

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: User Access Setup Error: GPS Error RevokeUserAudit: 58

    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.

  • Chris Baltas Profile Picture
    Chris Baltas 80 on at
    Re: User Access Setup Error: GPS Error RevokeUserAudit: 58

    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

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: User Access Setup Error: GPS Error RevokeUserAudit: 58

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

  • Chris Baltas Profile Picture
    Chris Baltas 80 on at
    Re: User Access Setup Error: GPS Error RevokeUserAudit: 58

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

    Thanks,

    Chris

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans