Share
Report
1,540I am upgrading from GP10 to GP2010 in a Test Environment. The Test server is not as beefed up as the Live server but I have successfully upgraded 49 out of 50 databases and each one took approx 30 minutes. They range in size from 400 to 5000 MB.
I saved the largest database for last as it is over 50 GB. It has been running for 4.5 hours. The duinstall.log file is no longer growing (stopped when the data conversion started 4.5 hours ago). The server shows it is not responding. The DEXSQL.LOG has not grown since 4 hours ago based on the time/date modified. SQL Profiler timed out when I tried to view it but in the Expensive Queries section it said SUSPENDED for this database, not sure if that means something, then it timed out.
I made a copy of it and opened in wordpad. There are a few errors. The last table is GL30000 and this is a very large table. The last line in the log file is as follows:
/* Date: 04/27/2012 Time: 9:35:28
stmt(87493936):*/
BEGIN update GL30000 set GL30000.PERIODID = b.PERIODID from GL30000 a,(select YEAR1, PERIODID, PERIODDT, PERDENDT from SY40100 where SERIES = 2 and PERDENDT <> '01/01/1900' group by YEAR1, PERIODID, PERIODDT, PERDENDT) b where a.HSTYEAR = b.YEAR1 and a.TRXDATE >= b.PERIODDT and a.TRXDATE <= b.PERDENDT END
/* Date: 04/27/2012 Time: 9:34:48
SQLSTATE:(S0002) Native Err:(3701) stmt(87504440):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure 'dbo.zDP_M00200CSD', because it does not exist or you do not have permission.*/
I increased the data and log file sizes, and disk space is not an issue.
Is there any way to check if I should abandon this? I can wait it out all weekend if needed, but normally upgrade/servicepacks take about 4 hours in the live environment.
*This post is locked for comments
All responses (
Answers (
