You’re offline. This is a read only version of the page.
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?
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)
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...
>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.
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.
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.
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:
***You must SlipStream this patch, it will not work with manually applying the patch over the top of an existing Web Services install***
***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)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (