Installation and deployment
Version 7.x > Installation and deployment > Upgrade problems... View modes: 
User avatar
Member
Member
merete-midtskog - 1/4/2013 3:58:22 PM
   
Upgrade problems...
Good evening.

Trying to upgrade from v. 6 to v. 7, but keeps getting error messege each time I try:

SQL script applied.

DECLARE @currentSiteId INT;
DECLARE @siteCursor CURSOR;
SET @siteCursor = CURSOR FOR SELECT [SiteID] FROM [CMS_Site] ORDER BY [SiteID];

/* Loop through the table */
OPEN @siteCursor
FETCH NEXT FROM @siteCursor INTO @currentSiteId;

WHILE (@@FETCH_STATUS = 0)
BEGIN

exec Proc_CMS_UIElement_UpdateAfterImport
@siteId = @currentSiteId,
@packageVersion = '6.0',
@topLevelElements = 0;

FETCH NEXT FROM @siteCursor INTO @currentSiteId;
END

Failed to run SQLscript: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
90% of SQL script applied.
80% of SQL script applied.
70% of SQL script applied.
60% of SQL script applied.
50% of SQL script applied.
40% of SQL script applied.
30% of SQL script applied.
20% of SQL script applied.
10% of SQL script applied.
Running SQL script (upgrade_6_0.sql)

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 1/5/2013 3:27:33 AM
   
RE:Upgrade problems...
Hi,

It seems you are using the automatic upgrade. In this case the connection timeout setting from web.config file is used. However, applying of the SQL script can take much longer than this setting and as in your case, it timed out.

So, please roll back the v6 backup of the DB and the best way would be to run the SQL script using the SQL server Management Studio directly over the DB to avoid any timeouts. Or, another option would be to run the upgrade tool, select to run only the SQL script over the v6 DB and before that set the time out settings in the web.config file to a higher value.

Best regards,
Juraj Ondrus

User avatar
Member
Member
merete-midtskog - 1/5/2013 12:27:18 PM
   
RE:Upgrade problems...
It all worked perfect!
Thx a lot :)

Best regards,
Merete