Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Completely removing mo...
Finance | Project Operations, Human Resources, ...
Suggested answer

Completely removing modules and tables

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,730

I did an upgrade this weekend for a client. Whoever did the original installation installed just about every module known to man. My question is there a way a remove all traces of modules including all tables, views and stored procedures? Of particular concern is analytical accounting and advanced HR/PR now that that has been handed over to Integrity Data. They turned over payroll to an outside provider years ago. I know you can remove these modules from the DYNAMICS.SET file but that will leave all the components in the DYNAMICS and company databases.I know there is the SQL Maintenance routine but I am hoping perhaps there exists a series of scripts to ease the removal process.

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,054 Super User 2024 Season 1 on at
    RE: Completely removing modules and tables

    Richard,

    Next to what Lisa & Steve replied, there are indeed a few KB articles from Microsoft out there to completely remove some module tables. In particular those who could come back and bite during an upgrade, like FA & AA.

    In most cases if you take out the modules from the .SET file, the DU000020 & DB_Upgrade tables, then GP Utilities won't try to upgrade those anymore.

    GP PowerTools Database validation does offer that option to check on missing modules from the .SET file and remove all references from the system, and even remove tables that are no longer needed, but you need a registered license to do it. Mostly recommended to customers way before they start an upgrade project, so the situation can be assessed long before the upgrade starts.

    Like Lisa, I've built over the years a long list of GP module numbers and add-ons from various third party, so I know what it refers to during an upgrade, would it start to fail.

    It's a PITA, but most ISV's don't even bother to provide a proper removal script for their SQL objects when un-installing the product.. Sometimes you can get it from their technical setup guides or from the support.

    A good idea is to setup a Vanilla GP instance and then trace down with SQL what objects get created during the install process of a new module.. I did that once or twice in the past as I couldn't clearly identify all the created SQL objects and needed to get rid of them.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Completely removing modules and tables

    Thanks Lisa, I will add this list to my GP tool bag.

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 572 on at
    RE: Completely removing modules and tables

    Several of those look like products that have rolled into the core GP install and shouldn't be in the new Dynamics.set.  Hopefully someone from GP Support will chime in on an official list.

    Others (like Technical Support tools) shouldn't have any interim installs that give you a problem - just install and launch PSTL (in each company) to rebuild the tables.

    ALL OF MY NOTES BELOW ASSUME THE MODULE HAS ****NO**** DATA TO RESTORE.  All data is removed.


    309 Fixed Assets - 

    Remove FA from DynUtils.set
    After upgrade is complete, add back FA to DynUtils and update the FA product line and then launch GP Utils again to upgrade FA tables
      update db_upgrade set db_vermajor=14, db_verbuild=698, db_veroldmajor=14, db_veroldbuild=698 where prodid=309
    1. UPDATE DYNAMICS..DB_Upgrade SET db_verOldMajor=0, db_verOldMinor=0, db_verOldBuild=0, db_status=0 WHERE PRODID=309 and db_name = 'xxx'
    2. Delete DYNAMICS..DU000020 WHERE PRODID=309 and companyid = 'x'
    3. Run the following scripts against the company database:
    A. Drop table FA41000
    B. Drop table FA00200
    C. Drop table FAINST01
    http://community.dynamics.com/gp/f/32/t/59532

    My notes on 414 Human Resources are based on Event Viewer error on DLL:
    Uninstall GP / re-install GP (including service pack).
    2020-07-24 Error on HRDocAttach ran across issue with removing HR information below:
    select * from DYNAMICS..DB_Upgrade where PRODID = 414 and db_name = 'xxxx'
    select * from DYNAMICS..DU000020 where PRODID = 414 and db_name = 'xxxx'
    select * from DYNAMICS..DU000030 where PRODID = 414 and db_name = 'xxxx'
    Delete DYNAMICS..DB_Upgrade where PRODID = 414 and companyID = xx
    Delete DYNAMICS..DU000020 where PRODID = 414 and companyID = xx
    Delete DYNAMICS..DU000030 where PRODID = 414 and companyID = xx
    select * from dynamics..suspref
    select * from dynamics..HR2APP06
    select * from dynamics..AAX10130
    --If you are reinstalling this module for the Dynamics database run the following scripts against Dynamics:
    Drop Table SUSPREF
    Drop Table HR2APP06
    Drop Table AAX10130
    --You can find the Companyid by running the following script:
    select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500
    --Last you need to run the following drop scripts against each company you need to reinstall the module for:
    select * from TEST..HR2NJ01
    select * from TEST..EX010130
    Drop Table HR2NJ01
    Drop Table EX010130
    Product 1235 does not support upgrading from version xx.xx.xxxx (Safepay)
    community.dynamics.com/.../82896
    Delete DYNAMICS..DB_Upgrade where PRODID = 1235 and db_name = 'xxxx'
    Delete DYNAMICS..DU000020 where PRODID = 1235 and companyID = xx
    Delete DYNAMICS..DU000030 where PRODID = 1235 and companyID = xx
    You can find the Companyid by running the following script:
    select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500
    Last you need to run the following drop scripts against each company you need to reinstall the module for:
    Drop Table ME123515
    Drop Table ME234602
    Product 1428 does not support upgrading from version xx.xx.xxxx
    community.dynamics.com/.../product-1428-does-not-support-upgrading
    Delete DYNAMICS..DB_UPGRADE where PRODID = 1428
    Delete DYNAMICS..DU000020 where PRODID = 1428
    Delete DYNAMICS..DU000030 where PRODID = 1428
    --> Delete following tables from each company
    drop table ME142801
    drop table ME142802
    drop table ME142803
    drop table ME142804
    drop table ME142805
    drop table ME142806
    drop table ME142807
    drop table ME142808
    drop table ME142809
    drop table ME142811
    drop table ME142812
    drop table ME142813
    drop table ME142814
    drop table ME142815
    drop table ME142818
    drop table ME142820

    Product 3180 does not support upgrading from version xx.xx.xxxx
    https://support.microsoft.com/en-us/help/915903/steps-to-remove-analytical-accounting-from-a-computer-that-has-microso
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Completely removing modules and tables

    Lisa, you can use this list. Thanks.

    309
    Fixed Assets
    414
    Human Resources
    949
    FieldService
    1042
    Interfund Management
    1235
    Safe Pay
    1428
    Electronic Reconcile
    1493
    SmartList
    1632
    Cash Flow Management
    1838
    Technical Service Tools
    1878
    Excel-Based Budgeting
    1911
    HRM Solution Series
    2277
    Purchase Order Enhancements
    2416
    Control Account Management
    2547
    Enhanced Commitment Management
    2992
    CopierSeries
    3104
    Advanced Security
    3180
    Analytical Accounting
    3258
    Encumbrance Management
    3278
    Report Scheduler
    4421
    Grant Management
    4522
    Payroll Integration to Payable
    4933
    Certification Manager
    4955
    Employee Health and Wellness
    5597


    :C:Program Files (x86)/Microsoft Dynamics/GP2015/Data/DO6499R.DIC

  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 572 on at
    RE: Completely removing modules and tables

    I don't have an all-inclusive list, but I do have many of core GP noted.  (My list is built over years of searching for "Product XXXX does not support upgrading from version ...) errors during upgrades.)  Do you have any product numbers that I can search for you?  [I hesitate to post my list as it may include obsolete/broken links.]

  • Steve Rodionoff Profile Picture
    Steve Rodionoff 261 on at
    RE: Completely removing modules and tables

    good question, would love to know the answer myself. as i have come across a number of deployments in the same situation.

    Below are a few i have come across previously, however it would be nice for a formal process where you can specify any GP addon module and remove the objects in SQL.

    AA - support.microsoft.com/.../kb-steps-to-remove-analytical-accounting-from-a-computer-that-has-microsoft-dynamics-gp-installed-02905531-ce33-5f68-8715-bd55e43fd247

    Webservices -    

    Fixed Assets - https://www.azurecurve.co.uk/2016/11/sql-script-to-remove-fixed-asset-management-tables/

    Business Portal - KB923665  (doesn't seem to exist anywhere anymore)

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans