Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Error message when you try to log on to Microsoft Dynamics GP

(0) ShareShare
ReportReport
Posted on by Microsoft Employee
I have created a user class for Payable Management. All users in the class when they login receive the above message, although they click OK and are able to login the facility are not supposed to recieve this message. I have review basic security, and third party security and it all appears to be find. I created a sql log file during the incident and got this results. In the knowledge based article it says to look for SY10000 table and i dont see anything related to it. Can anyone tell me what seems to be the problem? /* Date: 07/13/2009 Time: 14:13:55 stmt(19604808):*/ EXEC DYNAMICS.dbo.zDP_ACTIVITYSS_1 'HIMA San Pablo', 'saotero' /* Date: 07/13/2009 Time: 14:13:55 stmt(19610496):*/ EXEC DYNAMICS.dbo.zDP_SY01402SS_1 'saotero', 15

*This post is locked for comments

  • winthropdc Profile Picture
    winthropdc on at
    Re: Re: Re: Re: Re: Re: Re: Re: Error message when you try to log on to Microsoft Dynamics GP

    For Security Issues in general see

    http://blogs.msdn.com/developingfordynamicsgp/archive/2008/11/10/microsoft-dynamics-gp-application-level-security-series.aspx

    For Security Issues on login see

    http://blogs.msdn.com/developingfordynamicsgp/archive/2008/11/17/how-to-resolve-security-errors-on-login.aspx

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David.Musgrave@online.microsoft.com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Error message when you try to log on to Microsoft Dynamics GP

    Go Fast is bang on with that suggestion. Your solution works also! Glad you got it sorted.

  • GoFast Profile Picture
    GoFast 200 on at
    Re: Re: Re: Re: Re: Re: Error message when you try to log on to Microsoft Dynamics GP
    Or you can turn on activity tracking for this user and failed attempts to open windows. This will show the window that is tripping the error.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Error message when you try to log on to Microsoft Dynamics GP
    Thanks for all your help, I went another route. I had all AP users in a class, therefore I created another class for them with new security in case it was corrupted, and it worked!! I no longer have the situation.:)
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Error message when you try to log on to Microsoft Dynamics GP

    Or, you could click OK to launch GP and then click around on the shortcuts etc. untill you get the error message again.

    (I'm pretty sure the shortcut causing the issue would be displayed even tough it is security denied).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Error message when you try to log on to Microsoft Dynamics GP

    Hi,

    This is definately a security issue, but finding it won't be that easy. It could be a shortcut in the users home page that they do not have access to.  First test, can you log in as 'sa' on that machine...without getting the error?

    You are probably best to set a dexsql log to run while you log in, so that you can see exactly what is causing the problem. (If you aren't sure how to do this, let me know). With the log running, try and log in again as the user. When you get to the error message, do not click anything else (ie don't click OK to make the error message go away and continue), just go and locate the sql log which will be co-located with your dex.ini file. Open it and go to the last entry. This will tell you what product the error message relates to, along with whether it is a window or a report, and the window/report ID.

    You can then run a query against the SY09400 using the values above to determine what rsource is cauing the issue. You can then eithre grant security access to this user, or remove the shortcut from their home page. 

    The query would be something like: select * where product ID = ? and windowid = ? and resourceid = ? ... I can't remember the exact field names but a select * against the table will tell you what they are.

    Hope this helps. 

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Error message when you try to log on to Microsoft Dynamics GP
    Sorry! that would help "You don't have security privileges to open this window. Contact your system administrator for assistance". it occurs a right at login after you select the company. Even though it appears if you click OK it lets you get trough it. thanks I'll wait for your response!
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Error message when you try to log on to Microsoft Dynamics GP

    Hi,

    What is the error message. Could you post a screen shot?

    Best regards,

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans