Microsoft Dynamics GP Database Installation and Upgrade Statuses

I have to admit that to deliver this post I had to dig deep into the bowels of the Microsoft Dynamics GP Utilities. Installation and upgrade statuses don't seem to be anywhere (that I could find anyways) handy and can be very important when looking at a DEXSQL.LOG file for reasons of a failure during any of these processes.

Status ConstantStorage Value
DU_STATUS_DONE
0
DU_STATUS_START
1
DU_STATUS_INSTALL
2
DU_STATUS_UPGRADE
3
DU_STATUS_BIND_DEFAULTS  
7
DU_STATUS_RECOMPILE
8
DU_STATUS_CONVERT
23
DU_STATUS_POST_CONVERT
30

During the installation or upgrade of a database, status codes are recorded in the DYNAMICS..DB_Upgrade table for each Microsoft Dynamics GP dictionary being updated.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Comments

DavidMO said…
I noticed other values while trying to track the progress of our 25 company update using this script I built, below. I was thinking of building in a case statement with the various status.
48, 53, 54, plus some others that flash by pretty fast. Any ideas what the complete list includes?


SELECT db_name, PRODID, db_verMajor, db_verBuild, db_status,
Left(Convert(varchar(11) ,start_time, 0),11)+' ' + right(Convert(varchar ,start_time, 8), 8) as StartTime,
Left(Convert(varchar(11) ,stop_time, 0),11)+' ' + right(Convert(varchar ,stop_time, 8), 8) as StopTime,
Convert(varchar, stop_time - start_time, 8) AS Duration,
Case
When db_status = 0 then '1 - Upgraded'
When db_status <> 0 Then '2 - IN PROCESS'
End as Status
FROM DB_Upgrade WHERE PRODID = 0 and db_verBuild = 1860
Union All
SELECT db_name, PRODID, db_verMajor, db_verBuild, db_status,
'' as StartTime, '' as StopTime,
'' AS Duration,
'3 - Not Upgraded' as status
FROM DB_Upgrade WHERE PRODID = 0 and db_verBuild < 1860
ORDER BY status, StartTime asc
January 1, 2012 at 12:32 PM
DavidMO said…
Here are the Values I pulled from a Trace ran while performing the 12/21/2011 GP2010 End-of-year upgrade
set [db_status]=0
set [db_status]=1
set [db_status]=6
set [db_status]=7
set [db_status]=8
set [db_status]=9
set [db_status]=10
set [db_status]=11
set [db_status]=12
set [db_status]=13
set [db_status]=14
set [db_status]=15
set [db_status]=16
set [db_status]=17
set [db_status]=23
set [db_status]=30
set [db_status]=47
set [db_status]=48
set [db_status]=49
set [db_status]=50
set [db_status]=51
set [db_status]=52
set [db_status]=53
set [db_status]=54
set [db_status]=55
set [db_status]=56
set [db_status]=59
January 3, 2012 at 1:06 PM
Mariano Gomez said…
Dave,
Thanks for the additional input! This is a great compilation.

MG.-
January 5, 2012 at 9:20 AM
jpkd said…
Here's a link to a script I wrote a while back to see the progress of an upgrade. It's only really useful when there is more than one company database. It doesn't really take into account the db_status column as a description of what is currently happening as much as using it for noting which DB is currently being upgraded. The script gives a fairly good idea of how long the process will take after the first database has been completed. So far it's been pretty accurate.

Upgrade progress script
July 28, 2012 at 3:46 PM
Dbruni5 said…
Thanks for posting, this enabled me to restart the upgrade of my old company after a reinstall of the database to a new machine.
August 7, 2015 at 4:41 PM
Post a Comment

Popular posts from this blog

DBMS: 12 Microsoft Dynamics GP: 0 error when updating to Microsoft Dynamics GP 2013 R2

Image
Hello all! It's been quite a while since I've actually written anything of remote interest to anyone who follows my blog, but at the same time, you will be pleased to know that I've been quite busy in the consulting front, with upgrades, server migrations, complex multi-instance postings involving 10's of thousands of transactions, wrapping up some Field Service Automation projects, and the list goes on and on. This time around I want to bring to the forefront, an issue I encountered updating  from Microsoft Dynamics GP 2013 SP2 to Microsoft Dynamics GP 2013 R2 plus the latest service pack. Background My client requested a server migration to a new environment where they wanted to deploy Dynamics GP 2013 R2 web client (plus the latest service pack) and upgrade their relational database management system to Microsoft SQL Server 2014. This is something I'm absolutely comfortable with (for the most part) given also that my client was sitting at Microsoft Dynamics
Read more

Cannot insert the value NULL into column 'CONTACT' error when clicking on Items List in Navigation Pane

Image
Moving on from my previous article on a similar subject - see Cannot insert the value NULL into column 'BASEUOFM' error when clicking on Items List in Navigation Pane , I recently came across this error,  Cannot insert the value NULL into column 'CONTACT' when clicking on the All Purchasing Transactions list under the Purchasing Navigation Pane option, after performing an upgrade from Microsoft Dynamics GP 9.0 to Microsoft Dynamics GP 2010 R2. All Purchasing Transactions list error - Purchasing Navigation List The name of the global temp table - in this case, tempdb.dbo.##2093338- varies in almost all cases, but the end result of the error is the same. The issue has been identified running Microsoft Dynamics GP 2010 RTM, SP1 or SP2. Upon further review, the issue is due to bad data in the Vendor ID (VENDORID) column in the Purchasing Receipt History table (POP30300). In summary, if you have a purchasing receipt with a blank vendor ID or a vendor ID that doe
Read more

How to uninstall Microsoft Dynamics GP 10.0 if you cannot uninstall it by using the "Add or Remove Programs" feature

INTRODUCTION This article describes how to uninstall an existing Microsoft Dynamics GP v10 system if you cannot uninstall it by using the Add or Remove Programs feature (or Programs and Features in Windows Vista) in Control Panel. It is recommended that you verify that you cannot uninstall by using Add or Remove Programs first. MORE INFORMATION First, verify that you cannot uninstall Microsoft Dynamics GP by using Add or Remove Programs (or Programs and Features) To verify that you cannot uninstall Microsoft Dynamics GP by using Add or Remove Programs (or Programs and Features in Windows Vista), follow these steps. For Windows XP or Windows Server 2003: 1. Click Start, click Run, type control appwiz.cpl in the Open box, and then press ENTER. 2. Click to select Microsoft Dynamics GP 10.0 product from the application list, and then click Remove. For Windows Vista: 1. Click Start, type Programs and Features in the Search box, and then press ENTER. 2. Click to select the product to be un
Read more