Open Forum

Expand all | Collapse all

Adding HR module PRODID 414

  • 1.  Adding HR module PRODID 414

    Posted Aug 17, 2019 08:51 AM
    Customer is adding HR module to GP2018.  I added the module and when running utilities an error that displays "Error: Unable to upgrade the product 414 from version 6.  The product is not installed, does not show in any du... table, is not referenced in db_upgrade, and I ran a drop statement for all tables, views, stored procedures, in the Dynamics and company databases.
    I am totally confused as to where this reference is coming from.
    update error

    Any ideas are appreciated.


    David Callery
    Coe & Company, LLC
    Jefferson LA

  • 2.  RE: Adding HR module PRODID 414

    Posted Aug 19, 2019 09:03 AM
    Had similar errors when installing HR back in January.  The solution provided to me was to clear the DB_upgrade and DU000030 and DU000020 tables of all references to prodid 414.  After that I had to drop tables from Dynamics database (SUSPREF, HR2APP06 and AAX10130)  I also had to drop tables from the company databases (HR2NU01, EX010130 and AHRTS022)  Once this was done, I was able to install HR module without any other errors.

    David Ahalt
    GP Administrator
    Stark Aerospace
    Columbus MS


  • 3.  RE: Adding HR module PRODID 414

    Posted Aug 19, 2019 04:19 PM



    Thanks for the reply, not exactly the same tables but had a couple of other orphaned AHR... tables that were in the Dynamics database so it put me on the right track.



    We appreciate your business,

    David Callery
    David Callery  |  Consultant

    Coe & Company, LLC 3900 River Road, Suite 7 New Orleans, LA 70121
    ofc: 504.885.8686  cell 504.339.4260 web:


    Microsoft Gold Partner




If you've found this thread useful, dive deeper into User Group community content by role