I am trying to upgrade a test server to GP8.0 SP3 from GP7.5 SP6. I have run into several issues, and although I have resolved some of them (i.e. can't have IDENTITY column in any tables that's not named DEX_ROW_ID), there's a few I am still having trouble with. I am installing GP8.0 into a separate directory on the server.
1) When I run the Perform Special Upgrade in GP Utilities after installing SP3, I get a "Invalid column name DAYTOEXP" error. Looking at a SQL profiler trace of this, I can see that it is failing when recreating the IVR10015 table. I checked our live server and there is no DAYTOEXP column in the IVR10015 table so I'm guessing it must get added when updating to GP8.0 (without SP3), but somehow it is missing.
2) When I login to GP8.0 after installing it and running GP Utilities, I get an error message saying that the Manufacturing files were not installed. I have already installed the Manufacturing additional product before running GP Utilities.
3) When I login to GP8.0 after installing it and running GP Utilities, I get an error message saying that I need to run a WIP Reconcile and that running an Inventory Reconcile will damage the data.
4) On a more general note, what is the exact order (or does it matter) that I should be installing GP8.0, installing additional products (i.e. Manufacturing, Fixed Assets, Canadian Payroll, etc), installing the latest GP service pack, running Perform Special Upgrade in GP Utilities, and running the Canadian Payroll Upgrade Utility. The documentation isn't really clear to me on this, especially since we already have the additional products installed in the database.
Any and all assistance and ideas would be greatly appreciated. Let me know if there is any additional information you would like.
Thanks,
Peter
1) When I run the Perform Special Upgrade in GP Utilities after installing SP3, I get a "Invalid column name DAYTOEXP" error. Looking at a SQL profiler trace of this, I can see that it is failing when recreating the IVR10015 table. I checked our live server and there is no DAYTOEXP column in the IVR10015 table so I'm guessing it must get added when updating to GP8.0 (without SP3), but somehow it is missing.
2) When I login to GP8.0 after installing it and running GP Utilities, I get an error message saying that the Manufacturing files were not installed. I have already installed the Manufacturing additional product before running GP Utilities.
3) When I login to GP8.0 after installing it and running GP Utilities, I get an error message saying that I need to run a WIP Reconcile and that running an Inventory Reconcile will damage the data.
4) On a more general note, what is the exact order (or does it matter) that I should be installing GP8.0, installing additional products (i.e. Manufacturing, Fixed Assets, Canadian Payroll, etc), installing the latest GP service pack, running Perform Special Upgrade in GP Utilities, and running the Canadian Payroll Upgrade Utility. The documentation isn't really clear to me on this, especially since we already have the additional products installed in the database.
Any and all assistance and ideas would be greatly appreciated. Let me know if there is any additional information you would like.
Thanks,
Peter