Error deploying Microsoft Dynamics GP sample company

Microsoft Dynamics GPI was creating a new Microsoft Dynamics GP test environment the day when I encountered a problem at the point of deploying the Fabrikam sample company.

I did a quick search and found a blog I wrote over six years ago where I got this message and tracked it down to a corrupt installation of the GP 9 server components. Well, server components no longer exist as a separate thing, but it was possible something had happened to the install.

However, after uninstalling and reinstalling the problem still occurred:

Error message

Microsoft Dynamics GP Utilities

Install of database SMTWO failed! Microsoft Dynamics GP Utilities will now shut down.

This environment is using a shared SQL Server, so I’m using SMTWO as the database name for Fabrikam rather than the standard TWO, but I have used alternative names many times without issue.

I am aware that you can’t use reserved words for database names; this is not a Dynamics GP restriction, but rather a SQL one itself. I also tried SOTWO and got the same error and neither of these appear to be reserved names.

When I tried TWOSM, the install went through and worked without any problem, so there is obviously some sort of problem related to the two names I tried.

Hands On with Microsoft Dynamics GP October 2019 Release: Create new company

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. In this post, I am going to take a look at creating a new company in Microsoft Dynamics GP.

To create a new company, launch GP Utilities and log in as sa:

Welcome to Microsoft Dynamics GP Utilities - login

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Create new company”

Hands On with Microsoft Dynamics GP October 2019 Release: Add sample company

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. Over the series so far, I have downloaded and installed the prerequisites and client and then deployed the system database. In this post, I am going to add the sample company.

To do this, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities - login

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Add sample company”

Hands On with Microsoft Dynamics GP October 2019 Release: Deploy system database

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. As mentioned in the last post, the client installation these days includes the server installation. With one client now installed, the next step is to deploy the system database.

Do this by launching GP Utilities from the Windows Start menu and log in using the SQL Server sa account:

Welcome to Microsoft Dynamics GP Utilities - login

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Deploy system database”

Workflow in progress have been found in GP. These need to be processed before upgrading.

Microsoft Dynamics GPA colleague was recently performing an upgrade for a client to Microsoft Dynamics GP 2018 R2; this client had previously been a user of the old Dynamics Workflow module (now replaced with Workflow 2.0). They hadn’t used it for a while, but it had never been switched off resulted in the following message being displayed:

Upgrade error

Microsoft Dynamics GP Utilities

Workflows in progress have been found in GP. These need to be processed before upgrading. Please process these workflows before updating. A list of these workflows can be found in GPWorkflows.log

Workflows can be switched off from the front end, but with SQL Server Management studio already open, it was simple to run a SQL update statement against Company Master (SY01500):

/*
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 SY01500 SET WORKFLOWENABLED = 0 WHERE WORKFLOWENABLED = 1 GO

Hands On with Microsoft Dynamics GP 2018 R2: Create A Company

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

As I work with many clients with more than one company in Microsoft Dynamics GP, I always create at least one additiona company, in addition to ,a href=’https://www.azurecurve.co.uk/2018/10/hands-on-with-microsoft-dynamics-gp-2018-r2-add-sample-company/’>deploying the sample company.

To do this, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Create A Company”

Hands On with Microsoft Dynamics GP 2018 R2: Add Sample Company

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

In the last post, I deployed the system database; I’m continuing this post from the Additional Tasks step.

Ensure the drop-down list shows Add sample company data and click Process:

Additional Tasks

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Add Sample Company”

Hands On with Microsoft Dynamics GP 2018 R2: Deploy System Database

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

With the first first client now installed we need to deploy the server objects.

Back in the day, there was seaprate server and client compenents, but this changed with Microsoft Dynamics GP 10; now the server objects are deployed from a client install. To deploy the server components, start GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Deploy System Database”

Hands On With MDGP 2018 RTM: Create A Company

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.

As well as deploying the sample company, I always deploy a second company into which I will restore a copy of Fabrikam; this allows Intercompany to be configured and demonstrated when necessary.

To create a new company, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP

Continue reading “Hands On With MDGP 2018 RTM: Create A Company”

Hands On With MDGP 2018 RTM: Deploy System Database

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.

With the client now installed, I am able to progress to using GP Utilities to deploy the system database, the name of which was defined on the SQL Server step of the client install.

To deploy the system database launch GP Utilities and log in using the SQL Server system administrator (sa) account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On With MDGP 2018 RTM: Deploy System Database”