?
Solved

Server unresponsive upgrading company database

Posted on 2008-11-06
15
Medium Priority
?
595 Views
Last Modified: 2008-11-18
I have Windows Server 2008 and Sql 2005 SP2 installed on a new HP Proliant server with 2 logical driver.  The first drive is raid 1+0 and the second is raid 5 with one online spare.  I have MS Dynamics GP 10 SP 3 installed.  When attempting to ugrade my GP 9 databases to 10, it lockes up the server and forces me to reboot without finishing the upgrade.  The dynamics and system tables upgrade without error.  It looks up when trying to upgrade the company tables.  I have deleted and recreated the array and reinstalled the OS and Dynamics GP.  I do notice that the private working set for sqlservr.exe continues to go up during the process.  I have seen it reach 800,000K+ before it locks up.  Not sure if that is normal or not.  Any help would be great.
0
Comment
Question by:XTADMIN
  • 8
  • 7
15 Comments
 
LVL 7

Expert Comment

by:James Glaubiger
ID: 22899621
Check that the DBOWNER of each database is 'DYNSA'
0
 

Author Comment

by:XTADMIN
ID: 22899650
it is.
0
 
LVL 7

Expert Comment

by:James Glaubiger
ID: 22899683
How many company databases are you trying to upgrade and how big are they on disk?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:XTADMIN
ID: 22904042
one company.  4GB.  
0
 
LVL 7

Expert Comment

by:James Glaubiger
ID: 22907749
Have you applied GP SP3 to GP prior to running GP Utilities?

If yes:  Uninstall GP, delete the code folder, then reinstall GP 10.0 from CD and attempt the upgrade without the SP3 installed.   Apply the SP after the upgrade if it completes.

Also tell me what SP the GP 9 install was on?   Have you followed the instructions for applying the correct 9.0 SP to GP prior to upgrading to 10.0?
0
 

Author Comment

by:XTADMIN
ID: 22907795
GP9 is on SP3.   I'm pretty sure that's good for GP 10.  Yes, SP3 for GP 10 was installed prior to running GP Utilities.  I can reinstall and try without the SP.  
0
 
LVL 7

Expert Comment

by:James Glaubiger
ID: 22907838
Please Review the below table for the upgrade path requirements
Update Path Notes 
8.00g73 >> 10.0 or any patch install
(Service Pack 5) 8.0 Service Pack 5 required 
    
9.00.0281 >> 10.0 or any patch install
(Service Pack 2 - KB 923671 - English)
(Service Pack 2 - KB 927368 - Spanish Latin-American)
(Service Pack 2 - KB 929293 - French-Canadian)
(Canadian Payroll Year End - KB 928597) Service Pack 2 is the minimum version required 
    
9.00.0287 >> 10.0 with or without any patch install
(US Payroll Round 2 Tax Update - KB 930635)   
    
9.00.0291 >> 10.0 with or without any patch install
(Hotfix 929445 - English)
(Hotfix 929446 - Spanish)
(Hotfix 929447 - French-Canadian)   
    
9.00.0293 >> 10.0 with or without any patch install
(Hotfix 930941 - English) 
(Hotfix 930942 - Spanish Latin-American) 
(Hotfix 930943 - French-Canadian)    
    
9.00.0294 >> 10.0 Service Pack 1 or later
(Hotfix 934049 - English) 
(Hotfix 934050 - Spanish Latin-American) 
(Hotfix 934051 - French-Canadian)  Click HERE to download the latest 10.0 patch release 
    
9.00.0301 >> 10.0 Service Pack 1 or later
(Hotfix 936946 - English)
(Hotfix 936947 - Spanish Latin-American)
(Hotfix 938622 - French-Canadian) Click HERE to download the latest 10.0 patch release
 
This 9.0 build also includes the 2007 Canadian and French-Canadian Payroll Tax Update 
    
9.00.0310 >> 10.0 Service Pack 1 or later
(Service Pack 3 - KB 937795 - English)
(Service Pack 3 - KB 937796 - Spanish Latin American)
(Service Pack 3 - KB 937797 - French-Canadian) Click HERE to download the latest 10.0 patch release
 
    
9.00.0314 >> 10.0 Service Pack 1 or later
(2007 US Payroll Year End Update - KB 941935)
(Hotfix 943807 - Spanish Latin-American)
(Hotfix 937798 - French-Canadian) Click HERE to download the latest 10.0 patch release 
    
9.00.0314 >> 10.0 2007 Canadian Payroll Year End Update or later KB 943980
(2007 Canadian Payroll Year End Update - KB 943978)
(Hotfix 943979 - French-Canadian) Canadian Payroll Version = 9.00.0305
  
    
9.00.0327 >> 10.0 January Hotfix KB 947356 or later
(2008 US Payroll Round 2 Tax Update - KB 946605)
(Hotfix 946606 - Spanish Latin-American)
(Hotfix 946607 - French-Canadian) Click HERE to download the latest 10.0 patch release 
    
9.00.0337 >> 10.0 Service Pack 2 or later 
(Hotfix KB 947362 - English)
(Hotfix KB 947364 - Spanish Latin-American)
(Hotfix KB 947363 - French-Canadian)  Click HERE to download the latest 10.0 patch release
 
NOTE: 10.0 Service Pack 2 for Spanish-Latin American and French-Canadian available soon! 
    
9.00.0337 >> 10.0 2008 Canadian Payroll July Update KB 951101 or later
(2008 Canadian Payroll July Tax Update KB 951099 - English) Click HERE to download the latest 10.0 patch release
 
Canadian Payroll Version = 9.00.0312 
    
9.00.0352 >> 10.0 Service Pack 3 or later
(Service Pack 4 - KB 955672 - English)
(Service Pack 4 - KB 955673 - Spanish Latin-American)
(Service Pack 4 - KB 955674 - French-Canadian) Click HERE to download the latest 10.0 patch release 

Open in new window

0
 

Author Comment

by:XTADMIN
ID: 22907882
We're good.  GP 9 is at 9.00.0314.  GP SP3 should be fine since it says 9.00.0314 >> 10.0 Service Pack 1 or later.
0
 
LVL 7

Expert Comment

by:James Glaubiger
ID: 22908093
I would still try upgrading to SP1 then and see if you get the same issue.
0
 

Author Comment

by:XTADMIN
ID: 22932090
isn't GP sp2 required for server 2008?
0
 
LVL 7

Expert Comment

by:James Glaubiger
ID: 22932757
Yes, that is correct.   Try with sp2.
0
 

Author Comment

by:XTADMIN
ID: 22933927
When I originally tried this upgrade it was using GP sp2.  Now that SP 3 is out I thought that might help...it sure couldn't hurt at this point.
0
 
LVL 7

Expert Comment

by:James Glaubiger
ID: 22934022
Please follow the below instructions to create a DEXSQL log file of the upgrade so that we can review what is actually happening.  Let me know if you have any more questions about this before you start.
1. Open the Dex.ini file. By default, this file is in the following location, depending on the version that you are running:" Microsoft Dynamics GP 10.0: 
C:\Program Files\Microsoft Dynamics\GP\Data 
" Microsoft Dynamics GP 9.0: 
C:\Program Files\Microsoft Dynamics\GP 
" Microsoft Business Solutions - Great Plains 8.0: 
C:\Program Files\Microsoft Business Solutions\Great Plains 
 
2. Locate the following statements in the Dex.ini file: 
SQLLogSQLStmt=FALSE
SQLLogODBCMessages=FALSE 
SQLLogAllODBCMessages=FALSE 
 
 
3. If the statements are currently set to FALSE, change the statements to TRUE, as follows: 
SQLLogSQLStmt=TRUE 
SQLLogODBCMessages=TRUE 
SQLLogAllODBCMessages=TRUE
 
4. Start Microsoft Dynamics GP. If Microsoft Dynamics GP is already started, exit Microsoft Dynamics GP, and then restart it.  
5. Re-create the scenario in which you received the error message. Stop before you receive the error message.  
6. In Windows Explorer, open the Microsoft Dynamics GP application folder that you opened in step 1. Locate the Dexsql.log file. Delete or rename this file. 
 
If you do not see the Dexsql.log file, click View, and then click Refresh so that you can see the new file.  
7. In Microsoft Dynamics GP, complete the final steps to re-create the error message. You now have a new Dexsql.log file in the Microsoft Dynamics GP application folder.  
8. Open the Dex.ini file, and then reset the statements to FALSE or to the original settings. 

Open in new window

0
 

Author Comment

by:XTADMIN
ID: 22954615
I believe this problem is related to the server hardware configuration.  I will be getting a new server.  Thanks for your help.  Hopefully the upgrade will be successful on a new server since I have been able to duplicte it twice on other servers.
0
 

Accepted Solution

by:
XTADMIN earned 0 total points
ID: 22954646
problem seems to be hardware specific
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question