Timeout issue when migrating Commerce Connect on update

  • Updated

If you get the following error on the migration page:

Migrates published Catalog Content has failed with exception 'System.Data.SqlException (9x80131904): Execution Timeout Expired. The timeout period elapsed prioer to completion of the operation or the server is not responding.

or if you get:

Failed to clean up meta keys: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated

Then you can try to change the batch size to something lower like 1000 (default 5000):

<add key="ecf:DraftMigrationBatchSize" value="1000" />

http://world.episerver.com/documentation/upgrading/episerver-commerce/9/

and changing the batch size for removing Orphaned Meta Keys to something lower like 1000 (default is 10,000):

<add key="ecf:RemoveOrphanedMetaKeysBatchSize" value="1000" />

Or:

You can upgrade to Commerce Connect 11.4. 

Or:

If you don't want to upgrade you can work around by using these steps (Backup database first):

1. Add this index in the Commerce Connect database:
IF EXISTS(SELECT * FROM sys.indexes WHERE object_id = object_id('dbo.CatalogContentProperty') AND NAME ='IX_CatalogContentProperty_Temp_Number')
DROP INDEX IX_CatalogContentProperty_Temp_Number ON dbo.CatalogContentProperty;
GO
CREATE NONCLUSTERED INDEX [IX_CatalogContentProperty_Temp_Number]
ON [dbo].[CatalogContentProperty] ([Number])
INCLUDE ([MetaFieldId])
WHERE Number IS NOT NULL
GO

2. Finish the migration step
3. Drop the index.