Error on Commerce Connect Migration Update Permanent Link Step

  • Updated

If you get the error message: 

ERROR EPiServer.Commerce.Internal.Migration.MigrationProgressMessenger: Update permanent links failed with exception 'System.FormatException: Unrecognized Guid format.
at System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result)
at System.Guid..ctor(String g)
at EPiServer.Commerce.Internal.Migration.Steps.UpdatePermanentLinkStep.GetCatalogContentReferences(IProgressMessenger progressMessenger)
at EPiServer.Commerce.Internal.Migration.Steps.UpdatePermanentLinkStep.Execute(IProgressMessenger progressMessenger)'

Please run the below SQL script, the migration will convert the LinkGuid to String column from the result. (BACKUP YOUR DATABASE FIRST)

Select String, LinkGuid from dbo.[tblContentProperty] where String Like '%__CatalogContent'
 UNION Select ContentLink, fkReferencedContentGUID from dbo.[tblContentSoftlink] where ContentLink Like '%__CatalogContent'
 UNION  Select String, LinkGuid from dbo.[tblWorkContentProperty] where String Like '%__CatalogContent'

Please check if any wrong Guid format data. If the LinkGuids are null, just change it to the default Guid value(all zeroes).