Migrating data failed: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery (String or binary data would be truncated. The statement has been terminated.) |
Stacktrace:
at InfoCaster.Umbraco.UrlTracker.UI.Installer.UrlTrackerInstallerService.HandleException(Exception ex) in c:\Users\kipusoep\Documents\GitHub\UrlTracker\UrlTracker\UI\Installer\UrlTrackerInstallerService.asmx.cs:line 167
at InfoCaster.Umbraco.UrlTracker.UI.Installer.UrlTrackerInstallerService.MigrateData() in c:\Users\kipusoep\Documents\GitHub\UrlTracker\UrlTracker\UI\Installer\UrlTrackerInstallerService.asmx.cs:line 154
at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Web.Script.Services.WebServiceMethodData.CallMethod(Object target, IDictionary`2 parameters)
at System.Web.Script.Services.WebServiceMethodData.CallMethodFromRawParams(Object target, IDictionary`2 parameters)
at System.Web.Script.Services.RestHandler.InvokeMethod(HttpContext context, WebServiceMethodData methodData, IDictionary`2 rawParams)
at System.Web.Script.Services.RestHandler.ExecuteWebServiceCall(HttpContext context, WebServiceMethodData methodData)
at System.Web.Script.Services.RestHandler.ProcessRequest(HttpContext context)
at System.Web.Script.Services.ScriptHandlerFactory.HandlerWrapper.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
Once this has past, the next error when trying to view the dashboard is:
1. Invalid URI: The hostname could not be parsed. (inner exception is null)
2. Property accessor 'CalculatedOldUrl' on object 'InfoCaster.Umbraco.UrlTracker.Models.UrlTrackerModel' threw the following exception:'Invalid URI: The hostname could not be parsed.'
Migrating Data from V1 into V2 - Error
Hello,
When importing data I get the following error:
Not really sure what it means.
Once this has past, the next error when trying to view the dashboard is:
1. Invalid URI: The hostname could not be parsed. (inner exception is null)
2. Property accessor 'CalculatedOldUrl' on object 'InfoCaster.Umbraco.UrlTracker.Models.UrlTrackerModel' threw the following exception:'Invalid URI: The hostname could not be parsed.'
Once a hostname is set, then the other errors disappear.
http://screencast.com/t/s5j4sBBYK
Well, it means one of the columns isn't 'big' enough to store the data you're trying to insert.
The columns are all nvarchar(400), could you try changing them to nvarchar(2000) for instance and tell me if that fixed the problem?
Ah, two problems, it seems not having a hostname on the root node when working on Localhost:xxxxx causes some problems.
Did changing the size of the DB columns help? If so, I'll change the DB script inside the package...
I'll look into the "localhost with port other than 80" issue soon.
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.