Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I forgot to update the stored procedures before I installed the new HMS code and the upgrade is failing. Can I just recreate them now?

April 26, 2017code failing Forgot HMS installed procedures stored upgrade

0

Posted

I forgot to update the stored procedures before I installed the new HMS code and the upgrade is failing. Can I just recreate them now?

1 Answer

0

Posted

• A: No, you cannot recreate them with the new code installed. You must install the old HMS code and then recreate them. Note that if your old version is 7.5-72 or earlier, there will be no HMS option in the GP cascading menus in 8.0 or 9.0–you will need to add the ‘HMS Installation and Updates’ window to the Shortcuts bar to complete the required steps: • To install the ‘old’ code in the newly upgraded (to 8.0 or 9.0 GP) install, rename (or remove) the BOM.dic that has the new code and put in the chunk file for the old version. • If you do not have the old chunk file, then you can copy the old BOM.dic into the folder. Launch Great Plains and open the ‘HMS Installation and Updates’ window and click on the ‘File Maintenance’ button (HMS | Utilities | Install and Update’). Follow the instructions under File Maintenance earlier in Pre-update Procedures in the Online help file or the upgrade manual. Once those procedures are complete (including removing Smartlist for HMS), you may install