Open Forum

Expand all | Collapse all

Web Services for Microsoft Dynamics GP 2015

  • 1.  Web Services for Microsoft Dynamics GP 2015

    Posted 13 days ago
    Good day,

    Web Services for Microsoft Dynamics GP 2015 was configured and working at our Disaster Recovery site, until Dynamics and Company Databases where restored from our Production environment.
    The challenge now is we cannot get the email sent out from GP.

    Kindly advise if there is any script that must be executed after Database restore.

    WorkFlow Setup

    Below is the message when trying to manually test email flow; however nothing is receive in the e-mail account.
    We have tried Excahnage and Mimecast SMTP server name without any luck
    Assistance or guidance in this regard will be appreciated.

    Emails Message

    ------------------------------
    Patrick Masete
    Public Investment Corporation
    Johannesburg
    ------------------------------


  • 2.  RE: Web Services for Microsoft Dynamics GP 2015

    GPUG ALL STAR
    Posted 12 days ago
    Hi @Patrick Masete

    Have you simply tried to re-install the GP Web Services for the DR environment ?  I know that some of the challenges when you restore databases from your production environment is that you have also to redo all the security on the SQL server side.. since most of the accounts are disconnected after the restore. SQL doesn't know how to link the user security back to the DB's after the restore, thus this is something you need to take care of by yourself.
    The user security setup might be slightly different between the 2 environments, especially if they are not using the same domain.. ​
    See this KB article from Microsoft :

    https://support.microsoft.com/en-us/help/927321/how-to-change-the-current-sql-server-name-that-is-set-up-with-web-serv

    check also this Dynamics community thread about Web Services security :

    https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/160795/web-services-installation-error


    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------



  • 3.  RE: Web Services for Microsoft Dynamics GP 2015

    Posted 11 days ago
    Hi Beat Bucher,

    Thanks for your kind reply.

    Yes, GP Web Services has been reinstalled for the DR environment without any luck. This was done by our GP support consultant; however he is struggling to get emails flow. I'm not sure if there is post installation configuration(s) I can check as the consultant is struggling to assist any further.

    Below is to consider regarding our current Web Services setup:
    1. GPWebServices is using Windows Services (using port 48620), nothing is configured through IIS - this is the same config as in our Live environment.
    2. The GPWebServices Windows account used has sysadmin role in SQL, and the same account is running the Windows Services on GP Application Server.
    3. The GPWebServices "service" is running on a different server; not on the GP SQL server.
    4. User Mapping in both Live and DR environment is exactly the same.
    5. GP uses MS ODBC conection between client and SQL server.
    6. We are not using SQL mail; so Iogically the emails must be from the GP Application then relayed through Exchage - guidance required.

    My biggest challenge is understanding how GP "send out" emails from GP Application - hopefully this can guide in finding any form logs to guide me in troubleshooting this as the consultant has is struggling as stated.
    I need to understand how GP generate email, then pushes it OUT of GP.

    Any help will be highly appreciated.


    ------------------------------
    Patrick Masete
    Public Investment Corporation
    Johannesburg
    ------------------------------



  • 4.  RE: Web Services for Microsoft Dynamics GP 2015

    GPUG ALL STAR
    Posted 11 days ago
    Hi PAtrick,
    The GP e-mail setup does not make use of the SQL mail configuration, it's not a requirement at all.
    Your e-mailing out of GP entirely depends on how you setup the communication portion to your SMTP server, either Exchange or Office365..
    See this other thread from the GPUG forums that might help you narrow down the issue :
    https://www.gpug.com/communities/community-home/digestviewer/viewthread?GroupId=247&MessageKey=33eaba97-9f9b-46c4-ab25-6f13e14a3b61&CommunityKey=4754a624-39c5-4458-8105-02b65a7e929e&tab=digestviewer#bm33eaba97-9f9b-46c4-ab25-6f13e14a3b61

    One of the provided links is a detailed PDF on how to setup the Web Services, the Workflow & e-mailing in GP (from CAL Solutions). Did you create a dedicated SSL certificate for your new DR server ?
    Also the other link that points to Ian Grieve's blog post about setting up the Web Services for GP.. you may want to revisit that just to make sure you haven't missed a step somewhere.. Sometimes it's the most obvious things that keeps us from seeing the problem..

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------



  • 5.  RE: Web Services for Microsoft Dynamics GP 2015

    Posted 3 days ago
    Beat Bucher,

    We managed to resolve the relaying issue.
    With our current ODBC connection pointing to SQL, the email relaying from GP uses that SQL server (but NOT SQL MAIL) to relay the emails out - so we had to allow/accept email relayed from our SQL server IP (NOT GP application server IP) address via our Exchange.

    This is because our Exchange accept relaying from specific IP addresses, not just any IP.

    Thanks again for all the guidance and support.

    Regards

    ------------------------------
    Patrick Masete
    Public Investment Corporation
    Johannesburg
    ------------------------------



  • 6.  RE: Web Services for Microsoft Dynamics GP 2015

    GPUG ALL STAR
    Posted 3 days ago
    Hi Patrick,
    Thanks for letting us know what the root problem was.. Since you didn't specifically indicated if you were using O365 as e-mail system or a local Exchange server, it wasn't obvious to point to security settings on the network side.
    Not many companies using local Exchange servers are restricting SMTP relay internally from their network, thus this is rarely an issue when setting up TEST GP servers. Even if SQL mail is not involved in the process, the GP server will still originate the 'send' action from within the SQL server itself, thus using the IP address.
    A network trace would probably have been the only way to find out by catching the request sent to the Exchange server (or checking closely the Windows Event Logs).
    Glad you resolved it.​

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------



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