Open Forum

Expand all | Collapse all

GP Web Services Error

  • 1.  GP Web Services Error

    TOP CONTRIBUTOR
    Posted Oct 14, 2019 12:39 PM
    GP 2018 Web Services
    Over the last few weeks I started seeing this error in my DEV, QA, & Staging environments. Restoring a SQL backup of the DynamicsGPSecurity Database solves it, but I would like to understand the root cause.

    If the database were truly Invalid, why does GP Web Services continue to work? Any Ideas?

    Tests
    • While opening the GP Web Services Configuration Wizard (to add a new company), I have started seeing this error below.
    • Repairing the Web Services for Microsoft Dynamics GP 2018 fails with an error
    • Accessing the Dynamics Security or Exception Consoles both work ok
    • Stopping & Restarting the Microsoft Dynamics GP Service Host stops and starts ok. Does not fix the error

    Repairing


    ------------------------------
    David Morinello
    Senior Dynamics GP Systems Architect
    Ascend Learning, LLC
    Leawood KS
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: GP Web Services Error

    TOP CONTRIBUTOR
    Posted Oct 14, 2019 01:18 PM
    Got it!
    It looks like my DB Team added some SQL users to the DynamicsGPSecurity database. I removed those users and I could use the GP Web Services Configuration Wizard without error.

    Reference
    https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/90975/gp-2010-web-services-install-error----the-security-id-structure-is-invalid-exception-from-hresult-0x80070539


    ------------------------------
    David Morinello
    Senior Dynamics GP Systems Architect
    Ascend Learning, LLC
    Leawood KS
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role