Hello,
I have moving the GP9 to GP 2013R everything was OK, until I have logged in and I am getting the listed error
Store procedure sm_CleanUpFilesBeforeLoging.
I took a backup from our SQL 2005 and placed into a share file, and I use the SQL 2012 studio management to restore the backup.
I have the backup restored perfect because I run the query but when I opened the system it shows the DBMS 8144 error
However, the ACTIVITY in DYNAMCIS is empty
Please help
*This post is locked for comments
From the error logs you posted, it is clear that you already installed the GP2013 client ... so my question is : Did you applied first the service pack to get your GP 9.0 to the proper version before trying to upgrade ? you cannot take shortcuts when it comes to upgrades. You first need to have a fully working GP 9.0 that is on the proper version required to go to an upper level (be it 2010 or 2013).
Hello
I still working on it the the version of GP 9.00.0114 I have installed the patch for 9.0000371 but it has problem toopen the GP utilities. I was trying to start over, but really the problem I have is when I run GP 2013 there is a message sayin "problem ascertaining product version information" Microsoft Dynamcis GP utilities Please check the duinstall log... and I have
Component Start : 8/18/2015 at 9:27:12 AM -- Starting Company : DYNAMICS
Component Start : 8/18/2015 at 9:27:13 AM -- C:\Program Files (x86)\Microsoft Dynamics\GP2013\DATA\Temp\dex_req.sql
Component End : 8/18/2015 at 9:27:13 AM -- C:\Program Files (x86)\Microsoft Dynamics\GP2013\DATA\Temp\dex_req.sql
Message encountered ON 8/18/2015 at 9:27:13 AM. Message: C:\Program Files (x86)\Microsoft Dynamics\GP2013\SQL\3278\Upgrade.dll,UPGRADE_11_0_1734_SYSTEM\DEXPROCS_DRP
Component Start : 8/18/2015 at 9:27:13 AM -- C:\Program Files (x86)\Microsoft Dynamics\GP2013\DATA\Temp\DexProcs.drp
Component End : 8/18/2015 at 9:27:13 AM -- C:\Program Files (x86)\Microsoft Dynamics\GP2013\DATA\Temp\DexProcs.drp
Message encountered ON 8/18/2015 at 9:27:13 AM. Message: C:\Program Files (x86)\Microsoft Dynamics\GP2013\SQL\3830\Upgrade.dll,UPGRADE_11_0_50_SYSTEM\DEXPROCS_DRP
Component Start : 8/18/2015 at 9:27:13 AM -- C:\Program Files (x86)\Microsoft Dynamics\GP2013\DATA\Temp\DexProcs.drp
Component End : 8/18/2015 at 9:27:15 AM -- C:\Program Files (x86)\Microsoft Dynamics\GP2013\DATA\Temp\DexProcs.drp
Component Start : 8/18/2015 at 9:27:15 AM -- C:\Program Files (x86)\Microsoft Dynamics\GP2013\DATA\Temp\PJjobR.sql
Component End : 8/18/2015 at 9:27:15 AM -- C:\Program Files (x86)\Microsoft Dynamics\GP2013\DATA\Temp\PJjobR.sql
Component Start : 8/18/2015 at 9:27:15 AM -- C:\Program Files (x86)\Microsoft Dynamics\GP2013\DATA\Temp\WFJobsR.sql
Component End : 8/18/2015 at 9:27:15 AM -- C:\Program Files (x86)\Microsoft Dynamics\GP2013\DATA\Temp\WFJobsR.sql
hello,
The version of GP 9.00.0114, also now I was be able to run the GP utilities and I am getting and error "a problem with product version GP utilities will exist" so I dont know if the 878449 work, I know the data is there ... :( this is my first time doing this
OK,
But that doesn't tell us what version of GP 9.x.xxxx you were on before starting the upgrade.. This is important, because it defines how you can actually go to2013.. There is no direct path from 9.x to 2013.
Dynamics GP 9.0/SQL 2000/Windows 2003 to Dynamics GP 2013/SQL 2012/Windows 2012
1. The first step depends on the version of GP 9 you are on. If you are on 9.00.0371 or later you can upgrade directly to GP 2010, however if you are not then you need to upgrade to 9.00.0371. Click HERE to go to the GP 9.0 Download Page to grab the required patch. If you are on a build later than 9.00.371 your upgrade paths may vary. Please visit the Upgrade Hot Topic page.
2. Once you are on 9.00.0371 or later you will want to move your databases to SQL 2012 on Windows 2012. Refer to KB 878449 for move steps.
3. Next you can upgrade directly to any build of GP 2010, I would recommend GP 2010 SP 3 (11.00.2044) as this will allow you to upgrade to any build of GP 2013. Click HERE to go to the GP 2010 Download Page to grab the required patch.
4. Finally you will be able to upgrade to any specific build of GP 2013.
Yes I set up a new server 2012, but first I used 2008 and then finished in 2012., so what I did is just restore a backup to the 2012 server,
Thanks
Hi Pat,
You don't says much about how you moved your GP9 DB to 2013... Have you setup a new SQL server ? if so what's the version on the new server ?
There is a KB article from Microsoft on the whole process. You should follow exactly the steps :
https://support.microsoft.com/en-us/kb/878449
You don't say much about your exact GP 9.0 version.. but here's another link to the upgrade paths available to GP2013: https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/04/23/microsoft-dynamics-gp-2013-upgrade-paths-_2d00_-gp_2c00_-windows_2c00_-sql-server
Hope this helps
No I didnt work I have changed both to DYNSA a nothing happened
Did the resolutions work for you?
Mwalimu Phiri
Financial Systems Analyst
Hi
I found that article and I have change from sa to DYNSA ....
Have you already set configured the new server appropriately for DB owners?
Please review the kb below for your versions GP.
Hopefully you're able to resolve this issue with the kb below.
support.microsoft.com/.../849708
Mwalimu Phiri
Financial Systems Analyst
Share
Report
All responses (
Answers (
28,058
