Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dynamics GP 2018 R2 - ...
Finance | Project Operations, Human Resources, ...
Answered

Dynamics GP 2018 R2 - web services installation issue

(0) ShareShare
ReportReport
Posted on by Sherry Whitten 325

We installed web services, but it doesn't really seem to be installing in GP.

When we run the GP Web Services configuration Wizard, we have a question mark on functional currency verification.  When we click next,  it says "there are no companies setup at this time.  In order to install Web Services, you must first setup a company."

The Stored Proc dbo.ws_getall_wsinstallstatus does exist in Dynamics DB.

We don't see tables in Dynamics DB - for example, wsinstallstatus.

We verified that all companies have a functional currency assigned and that the ISO code is setup, not duplicated, and a length of three.

We verified that all companies are in the master.dbo.sysdatabases table.

We've restarted the service.

We've verified all four URLs work as described in verify web services in the installation guide.

When we attempt to verify the Dynamics Security Service, it says "could not access the securityservice service....  The security object does not exist."

We've tried complete uninstall/reinstall.  Sames results. 

The account we are using for the installation is an admin.

We are installing web services actually on the SQL server.

Other ideas?

Categories:
Microsoft Dynamics GP
  • AwalshGA Profile Picture
    AwalshGA 377 on at
    Dynamics GP 2018 R2 - web services installation issue
    Four years later you guys saved the day. Thank you. For anyone who stumbles on this thread, you can download and install the latest published service pack for WS and run it after the normal WS install and the companies list will appear in the config tool. Good way to end my week. Thanks again.
  • SonnyPawchuk Profile Picture
    SonnyPawchuk 114 on at
    Dynamics GP 2018 R2 - web services installation issue
    Solutions still works. 
     
    Critical step after the functional currency setup is the KB4527536 update file swap.  Skipping that step will cause your install to fail.
  • Brian P Connell Profile Picture
    Brian P Connell 859 on at
    RE: Dynamics GP 2018 R2 - web services installation issue

    Confirmed this fixed my issue too. After year end update to 18.3.xxxx and applying the service pack the workflow email links broke. (link read " server encountered an  error " message when using email actions to approve) . Applying service pack didnt work. Removed gp web services, downloaded 18.3 dvd and used use the xxx7536 KB service pack that was included. Then ran exec wfDeployCLRAssemblies for good measure.

    I have been using this "slipstream" method with all gp installs and updates for years now. so much easier.  

    My only issue was that when I tried to add a new database and not use my old GPWebConfig DB ( i think default db name is DynGPSecurity)  that was in use I got an error.Somethin like Exception from HRESULT: 0x80131050... So i used the old one and it worked out.

    Also - To avoid the blue and white question mark...I had to add a functional & reporting currency in ALL companies even if I didn't want to use workflow in those companies. ( including test companies)

  • Kaylasch Profile Picture
    Kaylasch 245 on at
    RE: Dynamics GP 2018 R2 - web services installation issue

    Confirmed if going from 18.2 -->18.3 2020 Year-end update, you will need to download the 18.3 installation media, and use that to install Web Services.

  • MC Weave Profile Picture
    MC Weave 20 on at
    RE: Dynamics GP 2018 R2 - web services installation issue

    Having just gone through a support case to assist getting Web Services installed and functioning after uninstalling it and attempting to reinstall, so I wanted to pass on a few tips that might help someone else.

    We were running GP 18.2 which had been upgraded via the 18.2 service pack, meaning the DVD we were working from was still the GP2018 RTM DVD with the 18.2 SP in the Updates folder. We could install Web Services successfully but during Web Services configuration, were stopped at the Functional Currency Check with a big blue and white question mark. Upon hitting the next button, we received a message telling us no companies were detected and we could not get past that.

    After trying the install again with the slipstreamed KB4527536 patch per the postings above, the configuration failed in the same way. We then upgraded to 18.3 thinking maybe that would help. We tried the entire process again and it failed again. At this point we opened a support case where they sent us the SQL Scripts referenced above to clear out any remnants of web services in the Dynamics and Company databases. We did this, then tried again and failed again. The eventual fix was to download the 18.3 DVD and run the Web Services install from Ad Products.

    So I am not sure if the SQL scripts were necessary, nor do I know how to get them without starting a support case with Microsoft. I think the take away for me is that if you uninstall and reinstall Web Services, you must install from the actual DVD download of the version of Dynamics GP you are running (i.e. 18.0, 18.2 or 18.3) We errantly assumed that the 18.0 DVD with either 18.2 or 18.3 SP in the updates folder was essentially the equivalent of the 18.2 or 18.3 DVD, but it is not in this particular case. Also note that we slipstreamed the same SP for Web Services for all three versions but it only worked with an 18.3 DVD installing on an 18.3 version of GP. Sounds obvious now, but it didn't at the time...

  • Verified answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Dynamics GP 2018 R2 - web services installation issue

    >In the 'Upgrading to Microsoft Dynamics GP' hot topic, it's listed in the notes:

    3. If Web Services does not start on 18.2, there is a patch you need to install (Slip Stream) from DVD image.

    >Also, on the Web Services for Dynamics GP (18.2) service pack/hotfix page, it mentions the patch needs to be slipstreamed.

    >We also mentioned it on the 'slipstream' blog we published not too long ago.

    The hot topics are where you more want to look at, when doing an upgrade, because most of the new notes will be listed there.

  • Suggested answer
    Sherry Whitten Profile Picture
    Sherry Whitten 325 on at
    RE: Dynamics GP 2018 R2 - web services installation issue

    Looks like this resolved our issues.   User will test a workflow in the morning.  Where/how could we have searched to find this issue and resolution sooner?  We googled and looked everywhere we knew to look.  Thanks for your help.

  • Sherry Whitten Profile Picture
    Sherry Whitten 325 on at
    RE: Dynamics GP 2018 R2 - web services installation issue

    Thanks for your help.  I don't see the scripts; I want to be sure we have the correct ones.

    ***You may need to run the scripts to remove prior Web Services objects from the DYNAMICS/system and all company databases for GP. I’m attaching those scripts if you need them.

  • Verified answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Dynamics GP 2018 R2 - web services installation issue

    If you’re on an 18.2.xxxx version of Dynamics GP, you may be running into an issue we have with that version of Web Services, specifically the Configuration Wizard, which is the blue question-mark showing for the functional currency and it won’t let you past that, or if it does, won't show any company databases for GP to select to install onto.

     

    To resolve this issue, you must follow these steps:

     

      1. Completely uninstall your current Web Services instance you have via Control Panel > Programs > Programs and Features.

     

      1. Download the KB4527536 patch for Web Services 18.2.xxxx from the CustomerSource or PartnerSource page.

     

      1. In the MDGP_DVD_ENUS file for Microsoft Dynamics GP /18.2.xxxx, go into the 'AdProd' directory, then 'WebServices', choose either x64 or x86, then in the 'Updates' folder for Web Services, remove the existing MSP file and replace it with this KB4527536 patch.  

     

    ***You must SlipStream this patch, it will not work with manually applying the patch over the top of an existing Web Services install***

     

      1. Use the Setup.exe under MDGP_DVD_ENUS > GreatPlains > AdProd > WebServices > x64 to launch the Web Services install/upgrade to 18.2.xxxx version.

     

      1. This will install Web Services like normal, then when you launch the Web Services Configuration Wizard, it should get past the ISO currency and Functional Currency checks if valid in the company databases, and allow you to choose which company databases you want to install Web Services onto.

     

                            ***You may need to run the scripts to remove prior Web Services objects from the DYNAMICS/system and all company databases for GP. I’m attaching those scripts if you need them. Usually if we do, the Configuration Wizard will fail on a error (security object does not exist.  Key = 25cc1a21-2cc4-4b13-a1c8-eea186fb688a)

     

      1. Once the Wizard completes successfully, it will prompt to restart the service for Web Services, then close the Wizard.

     

      1. At that point, go into the Dynamics Security Console, logged on as the account that installed Web Services, and verify that you can browse the list of policies, role assignments, roles and don’t get any error messages at all. You can also access the Web Services Exceptions Console and make sure there are no errors there either. If both render correctly, you should be all set with the 18.2 version of Web Services.

     

     

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 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