| Status Constant | Storage 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/
3 comments:
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
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
Dave,
Thanks for the additional input! This is a great compilation.
MG.-
Post a Comment