effort while data migration in umbraco 85 from umbraco 714plus - Using Umbraco and getting started

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

tgtrajeev 4 posts 24 karma points

Aug 28, 2021 @ 18:45

0

Error while data migration in Umbraco 8.5 from Umbraco 7.14+

We are getting error while migrating the content. Can you help us?

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Surrogate pairs are not supported. Please check log file for additional information (can be found in '/AppData/Logs/') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model) in d:\a\1\s\src\Umbraco.Web\Install\InstallSteps\DatabaseUpgradeStep.cs:line 47 --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Umbraco.Web.Install.Controllers.InstallApiController.14.MoveNext() in d:\a\1\s\src\Umbraco.Web\Install\Controllers\InstallApiController.cs:line 236 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task) at Umbraco.Web.Install.Controllers.InstallApiController.

Copy Link
Ben McKean 272 posts 549 karma points

Sep 03, 2021 @ 12:57

0

Hi tgtrajeev

Did you find a solution to this or find a solution to finding emojis as mentioned here https://our.umbraco.com/forum/umbraco-8/99194-umbraco-8-upgrade-taking-long-time

Thanks Ben

Copy Link
Ben McKean 272 posts 549 karma points

Sep 03, 2021 @ 13:54
0
This query worked for me:
```
SELECT id, text
FROM UmbracoNode
WHERE CAST(text AS VARCHAR(80)) <> CAST(text AS NVARCHAR(80));
```
Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?

Error while data migration in Umbraco 8.5 from Umbraco 7.14+