SBX - Search With Button

SBX - Forum Post Title

User Access Setup Error: GPS Error RevokeUserAudit: 58

Microsoft Dynamics GP Forum

Chris Baltas asked a question on 21 Dec 2010 5:44 PM

Question Status

Unanswered

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

Reply
Chris Baltas responded on 5 Jan 2011 1:10 PM

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

Thanks,

Chris

Reply
Victoria Yudin responded on 5 Jan 2011 2:08 PM
My Badges

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

Reply
Chris Baltas responded on 5 Jan 2011 3:17 PM

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

Reply
Victoria Yudin responded on 6 Jan 2011 3:27 AM
My Badges

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.

Reply
Kimberley Stevens responded on 3 May 2011 9:22 PM
My Badges

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

Reply
Chris Baltas responded on 6 May 2011 7:10 AM

Kimberly,

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

Thanks,

Chris

Reply
Vaidhyanathan Mohan responded on 10 Oct 2011 10:42 AM
My Badges

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

Reply
Angie Randazzo responded on 2 Apr 2012 12:33 PM
My Badges

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?

Reply
Vaidhyanathan Mohan responded on 2 Apr 2012 1:02 PM
My Badges

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.

Reply

SBX - Two Col Forum

SBX - Migrated JS