November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
Migration error when migration to EPiserver Commerce 7.10.3
Hi
Sounds like a bug to me. Would you mind to send us your catalog for further investigation?
Regards.
/Q
Aug 25, 2014 13:05
One of the first things are done by migration module is selecting from CMS db:
Select PageKey, PageGuid from dbo.[tblPageProviderMappings]and in result is returned something like this:
PageKey PageGuid
-----------------
...........
1_010_Nettbutikk2_-11_27_Catalog10_Nettbutikk10_Nettbutikk BAFD0026-B428-499C-B84C-947FE8CAF848
1_011_Testkatalog2_-11_37_Catalog11_Testkatalog11_Testkatalog F517EA79-2BCA-4303-A5EA-401EDCB25AE1
1_012_Mycatalog2_-11_27_Catalog12_Mycatalog12_Mycatalog B73B6DF0-E756-4109-8F96-37A1DE049BEE
1_014_Produktkatalog2_-11_87_Catalog14_Produktkatalog14_Produktkatalog 88A2BC81-AA26-47E6-A57E-5D904DBD5B1F
1_03_PIM2_-11_47_Catalog3_PIM3_PIM E8668DD6-02DF-4F2C-9233-01D92E436360
1_04_Wine2_-11_17_Catalog4_Wine4_Wine D36DDF00-B676-4284-9182-0BEA8E2610B2
1_06_Master2_-11_77_Catalog6_Master6_Master 3174DAD3-62C8-4046-B06D-946B18C396E1
1_10_1_01_111_CatalogNode11_Accessories4_Wine 58E97BF5-9D45-44F3-9601-DE9055B44BFE
1_111_Accessories1_01_111_CatalogNode11_Accessories4_Wine 300EF460-A25D-46E1-900B-0D640DB0FC9B
1_111_Accessories1_11_111_CatalogNode11_Accessories4_Wine BFB58FC6-8F83-4219-99E9-4F9C700B2788
1_120_Chateau d'Yquem-19901_81_112_CatalogEntry6_62012B6_France 6C57D501-8BFF-48F2-98E6-C85C5A7BD878
1_211_Mixed Cases1_01_111_CatalogNode10_MixedCases4_Wine C6760D91-2C7C-473C-B80C-26261A855075
1_211_Mixed Cases1_11_111_CatalogNode10_MixedCases4_Wine 28C1E747-4C44-42F4-AED5-68E5D05BCB3E
1_220_Chateau d'Yquem-19901_81_112_CatalogEntry6_61608B6_France 27612029-598F-4D97-881D-4E56706139CA
1_311_Wine Region1_01_111_CatalogNode6_Region4_Wine 8AC9F115-E174-481B-B9FE-765A9D1598CE
1_311_Wine Region1_11_111_CatalogNode6_Region4_Wine 8303BA25-FAFA-44D2-9EE3-3F1620BAB5DA
1_320_Chateau d'Yquem-19901_81_112_CatalogEntry6_33228B6_France D7E1EFB7-721A-47F7-8FD0-77D337854538
1_420_Chateau d'Yquem-19901_81_112_CatalogEntry6_33470B6_France 2F6B270A-F921-447C-8995-94F4240FC7EB
1_49_Argentina1_31_111_CatalogNode9_Argentina6_Region 0DBD8FD7-0ACD-43D0-B6DC-266DF091965D
...........I can see stright away it looks like I have there Alloytech data and then when that alloyTech CatalogNode is beaing feched(what is deleted already)
following happens:
exec sp_executesql N'SELECT CatalogNodeId FROM CatalogNode WHERE Code = @Code',N'@Code nvarchar(100)',@Code=N'Accessories'and in result gets:
CatalogNodeId
-------------
(0 row(s) affected)results in exception mentioned before
So is it my data that is bad or migrations process fails?
If my data is bad - some pointers would be welcome how to clean up?
Aug 25, 2014 14:45
As custom friendly Url provider for products is being used, does this table have any value, it looks like its just old data(from some old experiments) that is no longer being used, correct me someone if im wrong, please.
So I deleted contents and gotten successful migration.
Did fast smoke test and site appears to be working as before
Aug 25, 2014 15:35
tblPageProviderMappings is something back to Commerce R3 - and we're trying to make the old links to products continue working. Otherwise you might see broken links here and there.
For you issue, one or more catalog node codes might have been changed, causing the problem.
If you have no links to products/nodes from R3 which you wish to keep, then it's OK to delete the contents and move forward.
Regards.
/Q
Aug 25, 2014 17:29
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
Migration error when migration to EPiserver Commerce 7.10.3
As I have already set episerver migration to atomatic mode:
following happens:
And migration fails any subsequent retries leads to this very same error, any ideas what might be wrong(migration starting point was EPiServer commerce 7.9)?