Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / user sa takes 3 users ...
Finance | Project Operations, Human Resources, ...
Suggested answer

user sa takes 3 users in dynamics

(0) ShareShare
ReportReport
Posted on by Gilberto J Ojeda R 10

Hello, 

I have an issue in Dynamics GP, when I enter the application with the sa user, it takes 3 users in dynamics, 
I look for it in the activity table and I can actually see the three users, then I proceed to eliminate the sa users 
and it is normalized and in Sometimes I need to restart the SQL Server instance to be able to work. 
This is not something normal and I need help, the version of Dynamics GP is 2018, SQL Server 2014, 
if someone can guide me in the solution of this case I will know how to thank you very much, greetings and thanks

pastedimage1641839143430v1.png

Categories:
Microsoft Dynamics GP
  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: user sa takes 3 users in dynamics

    thanks Gilberto for the DEX.ini file..

    there is nothing in there that looks out of the ordinary or suspicious..

    Could you take a screenshot of the GP Addins folder ? at the bare minimum without any 3rd-party add-ons for GP, you should only see a couple files in there (the sample below has GPPT & eOne SLB installed)

    pastedimage1642189012829v1.png

  • Gilberto J Ojeda R Profile Picture
    Gilberto J Ojeda R 10 on at
    RE: user sa takes 3 users in dynamics

    Hi steve,

    Today they reported to me that the incident is occurring with some users, that is, it does not only happen with the user sa

  • Gilberto J Ojeda R Profile Picture
    Gilberto J Ojeda R 10 on at
    RE: user sa takes 3 users in dynamics

    No, i do not have sandbox, i will contact with david, thank for your support. 

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: user sa takes 3 users in dynamics

    Do you have a GP sandbox? If you do install a fresh installation of GP and see if this version does the same thing. This is not GP standard behavior. There is something in either your Dexterity code or databases causing this.  The other option would be to install GP Power Tools and run some logging tools to trace what is happening. You could talk to David Musgrave about GPPT.

    winthropdc.wordpress.com/.../

  • Gilberto J Ojeda R Profile Picture
    Gilberto J Ojeda R 10 on at
    RE: user sa takes 3 users in dynamics

    Hi Everybody,

    Today they report to me that the incident is happening with users different than sa, only that they do not triple log on, but that the entry is duplicated (it takes two users), what else could we check?

  • Gilberto J Ojeda R Profile Picture
    Gilberto J Ojeda R 10 on at
    RE: user sa takes 3 users in dynamics

    Hi beat, 

    This is the dex.ini file, sorry for the lateness

    [General]
    SQLLogSQLStmt=FALSE
    SQLLogODBCMessages=FALSE
    SQLLogAllODBCMessages=FALSE
    SQLRprtsTimeout=0
    ReportViewMode=0
    Initial=FALSE
    Synchronize=FALSE
    AutoDisplayUpdate=TRUE
    DynHelpPath=C:\Microsoft Dynamics\GP2018\
    DexHelpPath=C:\Microsoft Dynamics\GP2018\
    Word Macro File=C:\Microsoft Dynamics\GP2018\Data\Letters\WordIntegration.dot
    Letters Directory=C:\Microsoft Dynamics\GP2018\Data\Letters\
    Workstation=WINDOWS
    Workstation2=Windows
    WindowMax=TRUE
    BTInterface=NoLoad
    Pathname=DYNAMICS/dbo/
    FileHandler=SQL
    SQLQueryTimeout=0
    SQLProcsTimeout=0
    DPSInstance=1
    BuildSQLMessages=FALSE
    OLEPath=C:\Microsoft Dynamics\GP2018\Data\Notes\
    ReportDictionaryPath=C:\Microsoft Dynamics\GP2018\Data\
    FormDictionaryPath=C:\Microsoft Dynamics\GP2018\Data\
    SQLLastDataSource=Dynamics GP 2018
    UpdateLogin=mbsupdates.microsoft.com/.../login.aspx
    NextEntryID=8380
    NextGroupID=3943
    LastYearEndUpdate=11/17/2017
    LastTaxCodeUpdate=01/20/2017
    Dictionary Version=18.00.0628
    SQLLastUser=sa
    ZoomFontUnderline=True
    ZoomFontColor=Azul
    GPLastUser=sa
    RememberUser=FALSE
    ICONtrolDisplay=OFF
    IMPath=C:\Microsoft Dynamics\Integration Manager 18\Microsoft.Dynamics.GP.IntegrationManager.exe
    IMExecPath=C:\Microsoft Dynamics\Integration Manager 18\Microsoft.Dynamics.GP.IntegrationManager.IMRun.exe
    MagnifyScreenOutput=75
    NoteWindow=37,37,450,299
    SQLLastCompany=, C.A.
    FAAssetImportPath=C:\Users\gi\Desktop\ACTIVOSFIJOS.txt
    FAMacroPath=C:\Users\gi\Desktop\AF
    WindowPosX=0
    WindowPosY=0
    WindowWidth=1130
    WindowHeight=494
    ReportLayout=110,47,1042,615
    LayoutToolbox=1,1,178,382
    RWLayoutPropertiesSheetTab=1
    RWLayoutPropertiesSheet=822,25,565,349
    RWLayoutPropertiesSheetVisible=FALSE
    WDC_WinFieldLevelSecurity=39,49,626,368,1

    Thanks

  • Steve Hoffort Profile Picture
    Steve Hoffort 91 on at
    RE: user sa takes 3 users in dynamics

    As a work around, you might want to use DYNSA until you can figure this out.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: user sa takes 3 users in dynamics

    Beat it onto the idea. It appears that something is making Dexterity think there are three GP sessions running. Try going to User Preferences and turn off all Reminders. Also remove whatever you have in the Startup group for 'sa'.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: user sa takes 3 users in dynamics

    Gilberto,

    Realizing now that this is a Spanish Setup of GP, which could have a bug, or not.

    It definitely is weird that after login the GP license count shows 3 used up, whereas the Activity Table only holds 1 records.

    To me this looks like there could be some custom code added to the system, which might not necessarily be in the DYNAMICS.SET file, as it could be a simple .DLL within the GP or Addins folder in GP.

    Can you take a screen shot of the Addins folder of GP ?

    PS: what GP media did you use for the setup (KB????, release version)

  • Gilberto J Ojeda R Profile Picture
    Gilberto J Ojeda R 10 on at
    RE: user sa takes 3 users in dynamics

    Hi Richard,

    I already downloaded a new media, install and the problem continues

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans