Open Forum

Expand all | Collapse all

GP 2018 HR & HRP install error: Unable to get extended version information

  • 1.  GP 2018 HR & HRP install error: Unable to get extended version information

    TOP CONTRIBUTOR
    Posted Jan 21, 2019 04:22 PM
    I have a dev server with GP 2018 RTM (18.00.0400) installed.  It is a vanilla install of core modules only and TWO only.

    I needed to install the "Human Resources" and "Human Resources and Payroll Suite" modules for some customer testing.  Using Control Panel -> Add/Remove, I launched the GP setup and selected the two modules.  The installation completed successfully.

    When I try to launch GP Utilities, this error message is displayed.  The only option is to click Exit and close Utilities.  The GP client will not launch, as it displays a SQL error and says to run Utilities.

    GP Utilities Error

    I've searched for this specific error, but can't find any exact hits.

    Any ideas on how to troubleshoot this?  I could install a new SQL instance and new GP instance, but would rather salvage this instance to save time, if possible.

    ------------------------------
    Steve Endow, Microsoft MVP
    Precipio Services
    Los Angeles, CA
    steveendow (at) gmail (dot) com
    ------------------------------


  • 2.  RE: GP 2018 HR & HRP install error: Unable to get extended version information

    TOP CONTRIBUTOR
    Posted Jan 21, 2019 04:43 PM
    I have traced the SQL activity from GP Utilities and this appears to be the statement that is causing the issue.

    select db_verOldMajor, db_verOldMinor, db_verOldBuild from DYNAMICS..DB_Upgrade where db_name = 'TWO' and PRODID= 4955

    Apparently Utilities is expecting modules 1911 and 4955 to have records in the DB_Upgrade table, but they do not.

    ------------------------------
    Steve Endow, Microsoft MVP
    Precipio Services
    Los Angeles, CA
    steveendow (at) gmail (dot) com
    ------------------------------



  • 3.  RE: GP 2018 HR & HRP install error: Unable to get extended version information

    TOP CONTRIBUTOR
    Posted Jan 21, 2019 11:41 PM
    After I encountered the GP Utilities error, I was unable to recover the GP 2018 RTM install.  I tried uninstalling the HR and HRP modules, but the GP client would not launch after they were uninstalled.

    I restored my entire GP 2018 VM and then upgraded to GP 2018 R2 (18.00.0672).  After the update, I tried installing the HR and HRP modules from the GP 2018 R2 DVD.  Unfortunately, the same error occurs when I run GP Utilities.



    ------------------------------
    Steve Endow, Microsoft MVP
    Precipio Services
    Los Angeles, CA
    steveendow (at) gmail (dot) com
    ------------------------------



  • 4.  RE: GP 2018 HR & HRP install error: Unable to get extended version information

    TOP CONTRIBUTOR
    Posted Jan 22, 2019 12:13 AM
    After the GP Utilities failed again following the GP 2018 R2 upgrade, I ran out of ideas for conventional solutions.

    With nothing to lose, I decided to insert records into the DB_Upgrade table to see if that would allow GP Utilities to get past the version validation step and actually install the HR and HRP tables.

    I initially performed the inserts using the same db_verBuild value that many other modules used (18, 0, 628), but GP Utilities logged an error.

    Failure encountered ON 1/21/2019 at 8:50:08 PM. Error: You are attempting to configure an older version of product 1911. Database 18.0.628 Code 18.0.7.
    Failure encountered ON 1/21/2019 at 8:50:08 PM. Error: You are attempting to configure an older version of product 4955. Database 18.0.628 Code 18.0.5.


    Based on this information, I modified my insert statements to use a db_verBuild value of 7 for module 1911, and 5 for module 4955.

    Here are the final insert statements I used.  After inserting these four records, GP Utilities launched and made it past the validation step, and performed the installation / upgrade process for the newly installed modules.

    Unfortunately, the new modules are not fully installed.  There are missing tables and several odd errors.

    So unless I'm doing something wrong (quite possible), it seems that GP 2018 is unable to add the HR and HRP modules to an existing GP installation.

    I'm open to any suggestions.

    INSERT INTO dbo.DB_Upgrade
    (
        db_name, PRODID, db_verMajor, db_verMinor,db_verBuild, db_verOldMajor, db_verOldMinor,db_verOldBuild,
        db_status, start_time, stop_time
    )
    VALUES
    (   'DYNAMICS',        -- db_name - char(30)
        1911,         -- PRODID - int
        18,         -- db_verMajor - int
        0,         -- db_verMinor - int
        7,         -- db_verBuild - int
        18,         -- db_verOldMajor - int
        0,         -- db_verOldMinor - int
        7,         -- db_verOldBuild - int
        0,         -- db_status - int
        '2019-01-21 20:30:00', -- start_time - datetime
        '2019-01-21 20:31:00'  -- stop_time - datetime
        )
    
    
    
    INSERT INTO dbo.DB_Upgrade
    (
        db_name, PRODID, db_verMajor, db_verMinor,db_verBuild, db_verOldMajor, db_verOldMinor,db_verOldBuild,
        db_status, start_time, stop_time
    )
    VALUES
    (   'TWO',        -- db_name - char(30)
        1911,         -- PRODID - int
        18,         -- db_verMajor - int
        0,         -- db_verMinor - int
        7,         -- db_verBuild - int
        18,         -- db_verOldMajor - int
        0,         -- db_verOldMinor - int
        7,         -- db_verOldBuild - int
        0,         -- db_status - int
        '2019-01-21 20:30:00', -- start_time - datetime
        '2019-01-21 20:31:00'  -- stop_time - datetime
        )
    
    
    
    INSERT INTO dbo.DB_Upgrade
    (
        db_name, PRODID, db_verMajor, db_verMinor,db_verBuild, db_verOldMajor, db_verOldMinor,db_verOldBuild,
        db_status, start_time, stop_time
    )
    VALUES
    (   'DYNAMICS',        -- db_name - char(30)
        4955,         -- PRODID - int
        18,         -- db_verMajor - int
        0,         -- db_verMinor - int
        5,         -- db_verBuild - int
        18,         -- db_verOldMajor - int
        0,         -- db_verOldMinor - int
        5,         -- db_verOldBuild - int
        0,         -- db_status - int
        '2019-01-21 20:30:00', -- start_time - datetime
        '2019-01-21 20:31:00'  -- stop_time - datetime
        )
    
    
    
    INSERT INTO dbo.DB_Upgrade
    (
        db_name, PRODID, db_verMajor, db_verMinor,db_verBuild, db_verOldMajor, db_verOldMinor,db_verOldBuild,
        db_status, start_time, stop_time
    )
    VALUES
    (   'TWO',        -- db_name - char(30)
        4955,         -- PRODID - int
        18,         -- db_verMajor - int
        0,         -- db_verMinor - int
        5,         -- db_verBuild - int
        18,         -- db_verOldMajor - int
        0,         -- db_verOldMinor - int
        5,         -- db_verOldBuild - int
        0,         -- db_status - int
        '2019-01-21 20:30:00', -- start_time - datetime
        '2019-01-21 20:31:00'  -- stop_time - datetime
        )​





    ​​

    ------------------------------
    Steve Endow, Microsoft MVP
    Precipio Services
    Los Angeles, CA
    steveendow (at) gmail (dot) com
    ------------------------------



  • 5.  RE: GP 2018 HR & HRP install error: Unable to get extended version information

    GPUG ALL STAR
    Posted Jan 22, 2019 03:05 PM
    Hi @Steve Endow,
    You ran into an issue that plagues system admins sometime when performing an upgrade and getting rid or adding new modules between 2 versions..
    No easy way to fix, but GPPT can help here..
    However, in your case, it's a vanilla install of GP and presumably it should be working just fine.. I suspect that the add/remove program step to get the 2 new modules added didn't perform all the tasks that it would normally perform when doing it from scratch.. ​
    GP Utilities should have generated a log from the update process.. look in the GP Program Folder for some file starting with RepXXXX.txt, where the XXXX represent the module number that was upgraded.
    Many times I was able to 'cheat' the Utilities process by entering a dummy section in those RepXXXX.txt files for a missing intermediate version that wasn't there, just to make the process work.
    You should also find sub-folders starting with 'Upgrade18xxxx.Backup' which would hold the old copies of the DYNAMICS.SET & Dynamics.dic files.

    For the missing tables that seemed not having been created, the sub-folder 'Data' shoudl also have a useful log file called 'duinstall.log' which might point you to the right direction.
    All in all, when it comes to the Demo Fabrikam company, you're possibly wasting more time by trying to fix it than simply scrap it and restart from scratch with the proper module selection.

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------



  • 6.  RE: GP 2018 HR & HRP install error: Unable to get extended version information

    TOP CONTRIBUTOR
    Posted Jan 22, 2019 03:11 PM
    Thanks @Beat Bucher

    Unfortunately, I don't have any REPxxxx.txt files​, only the duinstall.txt file in the Data subdirectory.  Duinstall just had the same errors that the Utilities window showed, so that didn't help much.

    It seems like the HR and HRP modules are not designed to auto create all of their database objects when installed separately. I don't know if that's considered a bug, or they just didn't bother including that functionality.

    After wasting hours on this yesterday, I've given up on trying to add the modules to an existing install.  I restored my databases and a backup of the GP client files to fix my core modules install.

    This morning I installed a new SQL instance and a new GP instance with the HR and HRP modules.  Just finished with GP Utilities and creating the new TWO company, so hopefully this works.

    Not encouraging though.  Any GP customer looking to add HR / HRP to their existing install is in for some headaches.

    ------------------------------
    Steve Endow, Microsoft MVP
    Precipio Services
    Los Angeles, CA
    steveendow (at) gmail (dot) com
    ------------------------------



  • 7.  RE: GP 2018 HR & HRP install error: Unable to get extended version information

    GPUG ALL STAR
    Posted Jan 22, 2019 03:16 PM
    I agree,
    it is a PITA when you have new modules added between 2 version changes or have to remove old product references that were installed several versions back and can come back to bite you during an upgrade.. Most of the time it screws up GP Utilities and then you don't have a way to run GP other than restoring everything and try fix it before starting the upgrade.
    I've been trying to fix a TWO database that is 15 years old and contains tons of data that a fellow consultant wanted to keep, but was failing to upgrade from 2016 to 2018.. nothing fancy, just basic modules, but 4 tables were causing GP Utilities to fail, no matter how hard he tried.. :-)
    In the process of fixing all the issues with GPPT and try to re-upgrade to 2018 again.

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------



  • 8.  RE: GP 2018 HR & HRP install error: Unable to get extended version information

    GPUG ALL STAR
    Posted Jan 23, 2019 07:05 PM
    Edited by Beat Bucher Jan 23, 2019 07:07 PM
    @Steve Endow,
    This blog post from @Ian Grieve might help.. ​​ I ran into an issue where an upgrade would error out due to the presence of FA tables from an older release, and the client just didn't needed the FA module..
    https://community.dynamics.com/gp/b/azurecurve/archive/2016/11/28/sql-script-to-remove-fixed-asset-management-tables

    Ian had written a script to somehow semi-automate the removal of unused tables by looping thru them in each company DB.
    Could help to remove HR tables too..

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------



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