Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP Utilities Upgrade -...
Microsoft Dynamics GP (Archived)

GP Utilities Upgrade -Not Responding- message

(0) ShareShare
ReportReport
Posted on by DavidMO 1,030

For those pained by the blank white screen while your upgrade continues ok, I have a way forr you to monitor the upgrade progress.

You may need to tweak the  db_verBuild number or sorts, but I wrote this to help me chart the progress of my 25 company upgrade..

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

 Anyone have the full chart of DB_Upgrade..db_status values?

 

*This post is locked for comments

  • DavidMO Profile Picture
    DavidMO 1,030 on at
    Re: GP Utilities Upgrade -Not Responding- message

    Thanks for the DB_Upgrade list. I will put it to good use during future updates.

  • Scottie L. Taylor Profile Picture
    Scottie L. Taylor 20 on at
    Re: GP Utilities Upgrade -Not Responding- message

    Thanks for this. I have 12 companies and have been waiting for a while now on the upgrade process. I appreciate you posting this helpful info.

  • Verified answer
    Aaron Donat Profile Picture
    Aaron Donat on at
    Re: GP Utilities Upgrade -Not Responding- message

    David,

    here is the DB_Upgrade listing.  

    Step Description

    1 Start of Process

    2 If an install, load Defaults (directory\DEFAULTS.extension)

    3 If an install, create Tables (directory\TABLES.extension)

    4 If an install, create Indexes (directory\INDEXES.extension)

    5 If an install, create Views (directory\VIEWS.extension)

    6 If an install, create DexProcs (directory\DEXPROCS.extension)

    7 If an upgrade, drop changed DexProcs (directory\DEXPROCS.DRP)

    8 If an upgrade, drop changed App Procs (directory\APPPROCS.DRP)

    9 If an upgrade, drop changed Indexes (directory\INDX.DRP)

    10 If an upgrade, drop changed Views (directory\VIEWS.DRP)

    11 If an upgrade, drop changed Triggers (directory\TRIGGERS.DRP)

    12 If an upgrade, drop changed Rules (directory\RULES.DRP)

    13 If an upgrade, drop deleted Tables (directory\TABLES.DRP)

    14 If an upgrade, run any SQL code updates (directory\SQL.NEW)

    15 If an upgrade, add new Tables (directory\TABLES.NEW)

    16 If an upgrade, add new Indexes (directory\INDX.NEW)

    17 If an upgrade, add new DexProcs (directory\DEXPROCS.NEW)

    18 If Lesson DB and an install, create Stubs (directory\STUBS.extension)

    19 If Lesson DB and an install, create Procs (directory\PROCS.extension)

    20 If Lesson DB and an install, create Tables (SQL\LESSON\TWO.CMP)

    21 If Lesson DB and an install, BCP in data (SQL\LESSON\DATA\BCPTEMP.BAT)

    21 If (not System DB) and an upgrade, start conversion/synchronization process

    21 If System DB, BCP in data (SQL\SYSTEM\DATA\BCPTEMP.BAT)

    30 End of conversion/synchronization process

    41 If an upgrade, add new Views (directory\VIEWS.extension)

    42 Create Triggers (directory\TRIGGERS.extension)

    43 Create Rules (directory\RULES.extension)

    44 If not Lesson DB, create Stubs (directory\STUBS.extension)

    45 If not Lesson DB, create Procs (directory\PROCS.extension)

    46 If (not System DB) and an install, create FRx data (directory\FRXDATA.SQL)

    47 If (not System DB), grant access (EXEC DBName..smGrantAccessOnAccountMSTR)

    48 Bind table defaults (EXEC DBName..smBindTableDefaults)

    49 Recompile procs (SQL\UTIL\RECOMP.SQL)

    50 If Company DB and an install, run Dynamics front-end logic to create the company

    51 If not System DB, create Business Alerts (SQL\COMPANY\ALERTS.SQL)

    0 Process completed

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans