SQL process hangs during Upgrade 7 to 8

[Ben80]

We are running Great Plains v7 on a Windows Server 2003 box. Our SQL server (SQL2000 SP4) is on another box, also Windows Server 2003.

During the upgrade the DYNAMICS database upgrades perfectly, but when trying to upgrade the company database, during the "Updating tables" section, at random intermittant places, the following SQL process seems to freeze the Application and the process ID locks up. We have tried leaving it overnight but it is frozen. The only way to kill it is manually, which causes the upgrade to fail.

declare @cStatement varchar(255) declare T_cursor CURSOR for select 'drop index RM00201.' + name from sysindexes where name like 'AK%RM00201' set nocount on OPEN T_cursor FETCH NEXT FROM T_cursor INTO @cStatement WHILE (@@FETCH_STATUS <> -1) begin EXEC (@cStatement) FETCH NEXT FROM T_cursor INTO @cStatement end DEALLOCATE T_cursor

Does anyone have any ideas or has anyone experienced the same?

 

[Alcar]

I believe you need to upgrade to 7.5 first and then to 8.0... is this what you are doing?

Daren J. Lahey
Programmer Analyst
FAQ183-874 contains Suggestions for Getting Quick and Appropriate Answers to your questions.

 

[Ben80]

Thanks - we have solved our problem, we were running the upgrade over a Remote Desktop session. Doing this directly on the box solved the problem.