Error Configuring Web Services for Microsoft Dynamics GP 2018

Microsoft Dynamics GPI’ve seen this error at two different clients now when configuring Web Services for Microsoft Dynamics GP 2018:

A loader exception has occurred.
Loader Errors:
- System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'taRequesterWSDynamicsOnlineConfiguration1' in the database.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Dynamics.InstallData.SqlObjectLoader.DoSqlFromResource(String resourceName)
   at Microsoft.Dynamics.GP.GPSystemWebServiceObjectLoader.PerformActionOnEConnectStoredProcedures(Action action)
   at Microsoft.Dynamics.InstallData.Loader.Process(String[] args)
ClientConnectionId:04c704d2-d12c-40f3-9ccc-1444c4b529d9
Error Number:2714,State:3,Class:16

Both clients have previously had the Web Services implemented so that they could use Email Actions for Workflow approval. The first client got the error while we were doing the initial installation and confguration of the Web Services for Microsoft Dynamics GP 2018 and the second got them when we did a redeploy of the Web Services on the test system after refreshing the databases, but hadn;t received the error during the initial installation and configuration.

Continue reading “Error Configuring Web Services for Microsoft Dynamics GP 2018”

Hands On With MDGP 2018 RTM: Verify Web Services

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

The final step with the Web Services, now that they have been configured, is to verify that they are working correctly.

There are three checks which I recommend when verifying the web services:

  1. Is the service running?
  2. Have the security objects been deployed?
  3. Are the endpoints working?

Continue reading “Hands On With MDGP 2018 RTM: Verify Web Services”

Hands On With MDGP 2018 RTM: Configure Web Services

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

After installing the Web Services for Microsoft Dynamics GP, the next step is to run the Web Services for Microsoft Dynamics GP Configuration Wizard.

This is available via the Windows start menu; once running, click Next on the Welcome step:

Microsoft Dynamics GP: Welcome to the Web Services for Microsoft Dynamics GP Configuration Wizard

Continue reading “Hands On With MDGP 2018 RTM: Configure Web Services”

Microsoft Dynamics GP 2018 RTM Web Client Prerequisites: Bind SSL Certificate to IIS Web Site

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In a series of posts, I am be stepping through the installation of Microsoft Dynamics GP and additional products ; the series index for this series of posts is here and will automatically update as posts go live.

I am taking a small break (sort of) from that post, to cover the installation/configuration of the prerequisites for the installation of the Microsoft Dynamics GP 2018 RTM web client (the installation of which is part of the Hands On series.

This is the first of the posts on installing and configuring the web client prerequisites; in this post I am going to cover the binding of the self-signed security certificate (created in the last post).

To bind the certificate, launch Internet Information Services (IIS) Manager, expand the server node, the Sites node and click on Default Web Site (I am just using the default website in IIS for the web client) and then click Bindings in the Action pane:

Internet Information Services (IIS) Manager

Continue reading “Microsoft Dynamics GP 2018 RTM Web Client Prerequisites: Bind SSL Certificate to IIS Web Site”

Microsoft Dynamics GP 2018 RTM Web Client Prerequisites: Create Self Signed SSL Certificate

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In a series of posts, I am be stepping through the installation of Microsoft Dynamics GP and additional products ; the series index for this series of posts is here and will automatically update as posts go live.

I am taking a small break (sort of) from that post, to cover the installation/configuration of the prerequisites for the installation of the Microsoft Dynamics GP 2018 RTM web client (the installation of which is part of the Hands On series).

This is the first of the posts on installing and configuring the web client prerequisites; in this post I am going to cover the creation of a self-signed security certificate.

The web client is a web based service, which requires a security certificate to be created and bound to the web site. Once IIS has been installed, it is a simple process to create a self-signed security.

To do so, launch Internet Information Services (IIS) Manager and click on the server name in the navigation pane. in the detail pane, double click on Server Certificates:

Internet Information Services (IIS) Manager

Continue reading “Microsoft Dynamics GP 2018 RTM Web Client Prerequisites: Create Self Signed SSL Certificate”

Microsoft Dynamics GP 2018 RTM Web Client Prerequisites: Install Internet Information Services

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In a series of posts, I am be stepping through the installation of Microsoft Dynamics GP and additional products ; the series index for this series of posts is here and will automatically update as posts go live.

I am taking a small break (sort of) from that post, to cover the installation/configuration of the prerequisites for the installation of the Microsoft Dynamics GP 2018 RTM web client (the installation of which is part of the Hands On series).

This is the first of the posts on installing and configuring the web client prerequisites; in this post I am going to cover the installation of Internet Information Services (IIS).

To install IIS, log onto the server and launch Server Manager. Click on Add roles and features:

Server Manager

Continue reading “Microsoft Dynamics GP 2018 RTM Web Client Prerequisites: Install Internet Information Services”

Microsoft Dynamics GP 2018 RTM Web Client Prerequisites: Series Index

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In a series of posts, I am stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

Before installing the Microsoft Dynamics GP 2018 RTM Web Client, I will be installing the prerequisites. As with the eConnect 18 Prerequisites, I am breaking out the Microsoft Dynamics GP 2018 RTM Web Client prerequisites into their own mini series. This is the series index and will automatically update as posts go live.

Microsoft Dynamics GP 2018 RTM Web Client Prerequisites
Install Internet Information Services
Create Self Signed SSL Certificate
Bind SSL Certificate to IIS Web Site

SQL Script to Update Web Services Server in Workflow Setup When Copying Live To Test

Microsoft Dynamics GPAll clients will at some point copy their live company into a test one, whether or not the test system is on the same server or a different one. If on the same machine, they will usually use an automated process to perform the backup and restore.

There is usually other tasks which will need to be undertaken such as changing the output location of the EFT Payment Register Report or prefixing email message subjects with “TEST” or setting all email addresses to internal ones.

I’ve recently encountered a couple more fields which need to be reset to avoid problems when copying live to test. The one prompting this script, was when the live company was copied to the standalone test system, the Web Services server needed to be changed to a different value:

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
UPDATE WF00100
	SET
		Web_Service_Server = '{servername}'
WHERE
	SETUPKEY = 0
GO

The highlighted section, above, needs to be changed to your Web Services server.

In addition, a repair needed to be run using the Web Services Configuration Wizard, but at least the script removes one manual step.

As always with scripts, please make sure you have a good backup before using the script.

Hands On With Microsoft Dynamics GP 2016 R2: Web Services Runtime SQL Server Prerequisite

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

I’ve encountered this particular issue around the prerequisites so rarely, that I usually forget to mention it.

When installing the Web Services for Microsoft Dynamics GP there is a step where the SQL Server Connection Information is entered. This is the server where the Dynamics Security data will be stored.

You will receive the following message when clicking Next if the Windows user account you’re logged in as, is not a SQL Server sysadmin:

Invalid SQL Information - The current user must be a member of the sysadmin SQL role.

Invalid SQL Information

The current user must be a member of the sysadmin SQL role.

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Web Services Runtime SQL Server Prerequisite”

Hands On With Microsoft Dynamics GP 2016 R2: Verify Web Services

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Over the last couple of posts, I have installed and configured the Web Services for Microsoft Dynamics GP, it is now time to verify that they are working correctly; there are four items I’d recommend checking.

Firstly, open the Services applet from Computer Management and make sure the Microsoft Dynamics GP Service Host is set to a Startup Type of Automatic and that the service is Running:

Services

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Verify Web Services”