I can no longer access my GP application

This question is answered

Hi everyone,

This morning I installed GP 2010 on a workstation from the DVD. After running Data sources, hotfixes and utilities I realized I cannot log on GP (whilst at one point during my installation progress i saw something says "A company is being updated by another client" but I ignored it though). I received the following error message: "A product installed on your computer is on a different version than the database version. You will not be able to use the application until this issue is resolved. Use the GP_LoginErrors.log file in your temp directory to assist in resolving this issue." I tried running GP from other workstations including the GP server itself and noticed that I cannot access GP from any of my local PCs or server. I followed the GP_LoginErrors.log file in all PCs and server and find that it's empty (no data). I installed GP on a different PC, receive the same error, but the GP_LoginErrors.log file has something for me in store which I do not know how to correct or match the current versions: Product Name: Microsoft Dynamics GP     Database Version: 1101307     Client Version: 1101524

Product Name: Project Accounting     Database Version: 1101251     Client Version: 1101525

Product Name: Fixed Assets     Database Version: 1101247     Client Version: 1101485

Product Name: Field Service     Database Version: 1101252     Client Version: 1101517

Product Name: Cashbook     Database Version: 1101247     Client Version: 1101521

Product Name: Collections Management     Database Version: 11022     Client Version: 11023

Product Name: SmartList     Database Version: 1101247     Client Version: 1101495

Product Name: Purchase Order Enhancements     Database Version: 1101247     Client Version: 1101492

Product Name: Analytical Accounting     Database Version: 1101247     Client Version: 1101519

Product Name: Report Scheduler     Database Version: 1101247     Client Version: 1101391

Product Name: Grant Management     Database Version: 1101247     Client Version: 1101396

Product Name: HITB Report     Database Version: 1101247     Client Version: 1101435

Your assistance will highly be appreciated.

Verified Answer
  • Hi Alabama,

    I second Frank in this too... according to your numbers above, your server version is currently at the base level with the mid-year tax updates applied, but no service pack (11.00.1307). Your client version is currently at the SP1 Level... thus explaining the impossibility to launch any GP client.

    You have to first run the GP utilities (ideally on the server) to upgrade your GP system in every company. The SP1 documentation usually comes with a detailed instruction on how to conduct the upgrade.

    I don't know how you installed the GP client from the DVD, but it is usually a good practice to create an 'installation package' from your DVD that will be used for a semi-automated deployment. This package will contain all your configuration settings and ODBC definition, so you don't have to repeat all the steps on each and every workstation where you're going to install GP.. Using the same package for the server and PC installation guarantees you a consistent configuration across all your clients.

    Go for a minimum common configuration for your package and add manually after the setup all 3rd party or non-common modules that only a few users may use in your system. Of course those modules need to be setup and configured on the server side as well.

    MVP Victoria Yudin maintains a blog post with the detailed dictionary versions for the various GP major versions.

    --
    Enjoy the Life
    +-+-+-+-+-+-+-+
    Beat BUCHER
    Dynamics GP 2010R2 Business Analyst
    www.fti-ibis.com
    +-+-+-+-+-+-+-+

  • Alabama,

    Did you had a look into your GP_LoginErrors.log file ?  to find it, press the WINKey+R to open the run command and type %Temp% + Enter.  A Windows Explorer will open in your user temp folder. Type in the search box (upper right corner) the file name and you should find it.

    The error you get comes probably from a product that is not installed on the server but is part of your DYNAMICS.SET launch file on your local PC... this product may not have been updated yet.  Try to compare the two launch files from the server and your local GP client. Find out what's different... Does your GP client start on the server side ? if not than you should look to get a minimal launch file for the GP client (typically around 20 dictionary entries).

    You can compare your launch file with the table DYNAMICS..DB_Upgrade that's on your GP server. Each PRODID entry should match with one of your Dictionary entry from your launch file. You may have more entries in the launch file then in the table, because 3rd party products are not necessarily in the DB_Upgrade table, but at least your base GP products should be there.

    --
    Enjoy the Life
    +-+-+-+-+-+-+-+
    Beat BUCHER
    Dynamics GP 2010R2 Business Analyst
    www.fti-ibis.com
    +-+-+-+-+-+-+-+

  • Hi Beat/Frank

    I discovered my client version is currently at the SP1 Level which is not on the server. However, somewhere during installation process it made some changes to the server's database which has become impossible for other end users to launch GP. I found the version of the client PC and server which caused conflicts at 11.00.1524, while other workstations are running on 11.00.1307  version. So what I did, I restored the current DYNAMICS back-up file on the SQL server with Tuesday's back-up and all users with 11.00.1307 version were able to run GP except the client with1524 version. So I re-installed the GP application for the client PC and it was up and running Microsoft Dynamics as well on 1307 version. Thanks to you guys!

    All the best

    Alabama

All Replies
  • it appears that the version you installed on the client is at a higher service pack level than the server.  Did you perhaps apply a service pack on the server that you haven't yet applied on the clients or vice versa?  Some action has caused a version mis-match between the server and clients.  

    Frank E. Hamelly, MCP, MCITP, MCT, MVP

    http://gp2themax.blogspot.com/

  • Hi Alabama,

    I second Frank in this too... according to your numbers above, your server version is currently at the base level with the mid-year tax updates applied, but no service pack (11.00.1307). Your client version is currently at the SP1 Level... thus explaining the impossibility to launch any GP client.

    You have to first run the GP utilities (ideally on the server) to upgrade your GP system in every company. The SP1 documentation usually comes with a detailed instruction on how to conduct the upgrade.

    I don't know how you installed the GP client from the DVD, but it is usually a good practice to create an 'installation package' from your DVD that will be used for a semi-automated deployment. This package will contain all your configuration settings and ODBC definition, so you don't have to repeat all the steps on each and every workstation where you're going to install GP.. Using the same package for the server and PC installation guarantees you a consistent configuration across all your clients.

    Go for a minimum common configuration for your package and add manually after the setup all 3rd party or non-common modules that only a few users may use in your system. Of course those modules need to be setup and configured on the server side as well.

    MVP Victoria Yudin maintains a blog post with the detailed dictionary versions for the various GP major versions.

    --
    Enjoy the Life
    +-+-+-+-+-+-+-+
    Beat BUCHER
    Dynamics GP 2010R2 Business Analyst
    www.fti-ibis.com
    +-+-+-+-+-+-+-+

  • Hi Frank/Beat

    Thanks for responding to my issue and I hope I got your advices right hey. Well I did follow your instructions and upgrade the service-pack on the server. After this when I attempt to launch GP, I got a message which says I should run the utilities to upgrade the FORMS and REPORTS. I ran the utilities, successfully upgrade the forms and reports, and when I launched Microsoft Dynamics GP I got the following previous error message again: "A product installed on your computer is on a different version than the database version. You will not be able to use the application until this issue is resolved. Use the GP_LoginErrors.log file in your temp directory to assist in resolving this issue." Well is there any step perhaps that I might have gone wrong?

  • Alabama,

    Did you had a look into your GP_LoginErrors.log file ?  to find it, press the WINKey+R to open the run command and type %Temp% + Enter.  A Windows Explorer will open in your user temp folder. Type in the search box (upper right corner) the file name and you should find it.

    The error you get comes probably from a product that is not installed on the server but is part of your DYNAMICS.SET launch file on your local PC... this product may not have been updated yet.  Try to compare the two launch files from the server and your local GP client. Find out what's different... Does your GP client start on the server side ? if not than you should look to get a minimal launch file for the GP client (typically around 20 dictionary entries).

    You can compare your launch file with the table DYNAMICS..DB_Upgrade that's on your GP server. Each PRODID entry should match with one of your Dictionary entry from your launch file. You may have more entries in the launch file then in the table, because 3rd party products are not necessarily in the DB_Upgrade table, but at least your base GP products should be there.

    --
    Enjoy the Life
    +-+-+-+-+-+-+-+
    Beat BUCHER
    Dynamics GP 2010R2 Business Analyst
    www.fti-ibis.com
    +-+-+-+-+-+-+-+

  • Hi Beat/Frank

    I discovered my client version is currently at the SP1 Level which is not on the server. However, somewhere during installation process it made some changes to the server's database which has become impossible for other end users to launch GP. I found the version of the client PC and server which caused conflicts at 11.00.1524, while other workstations are running on 11.00.1307  version. So what I did, I restored the current DYNAMICS back-up file on the SQL server with Tuesday's back-up and all users with 11.00.1307 version were able to run GP except the client with1524 version. So I re-installed the GP application for the client PC and it was up and running Microsoft Dynamics as well on 1307 version. Thanks to you guys!

    All the best

    Alabama

  • Hi Alabama,

    Glad you find a solution to fix the problem... that was of course one of the options that we didn't mentioned, because not knowing if your upgrade was part of a regular process or not...

    You sais that your restored your DYNAMCIS backup file on the server... you don't mention the Company DB's... I hope you did that as well ? Not knowing where your GP system was actually staying in terms of upgrade, it is wise to restore all the related SQL DB's for your GP system (DYNAMICS, TWO (if installed) and every other Company DB). The field INTERID from the DYNAMICS..SY01500 table carries the identity name for you SQL DB's...if you're not sure about which Databases might be involved.

    --
    Enjoy the Life
    +-+-+-+-+-+-+-+
    Beat BUCHER
    Dynamics GP 2010R2 Business Analyst
    www.fti-ibis.com
    +-+-+-+-+-+-+-+