Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Upgraded to Latest Version - ERROR BVNetwork.NotFound.Core.Data.SqlRedirectRepository: An error occured while creating a redirect. #142

Closed
Ram-K-Kumar opened this issue Feb 12, 2019 · 8 comments
Closed

Upgraded to Latest Version - ERROR BVNetwork.NotFound.Core.Data.SqlRedirectRepository: An error occured while creating a redirect. #142

Ram-K-Kumar opened this issue Feb 12, 2019 · 8 comments

Comments

@Ram-K-Kumar
Copy link

Migrated Redirects from DDS to SQL
Clicking on "Ignore" icon in the "Suggestions" section generates the following error

2019-02-12 08:09:18,018 [71] ERROR EPiServer.Global: Unhandled exception in ASP.NET
System.Data.SqlClient.SqlException (0x80131904): The parameterized query '(@id uniqueidentifier,@oldurl nvarchar(2000),@newurl nvarchar(20' expects the parameter '@newurl', which was not supplied.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at BVNetwork.NotFound.Core.Data.SqlRedirectRepository.<>c__DisplayClass19_0.<ExecuteNonQuery>b__0() at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass34_0.<Execute>b__0() at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass31_01.b__0()
at EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute[TResult](Func1 method) at BVNetwork.NotFound.Core.Data.SqlRedirectRepository.Create(CustomRedirect entity) at BVNetwork.NotFound.Controllers.NotFoundRedirectController.IgnoreRedirect(String oldUrl, Int32 pageNumber, String searchWord, Int32 pageSize) at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary2 parameters)
at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass24_0.b__0()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
at System.Web.Mvc.Controller.ExecuteCore()
at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext)
at EPiServer.Shell.Web.Mvc.ModuleMvcHandler.ProcessController(IController controller)
at EPiServer.Shell.Web.Mvc.ModuleMvcHandler.BeginProcessRequest(HttpContextBase httpContext, AsyncCallback callback, Object state)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
ClientConnectionId:691772a4-4415-4110-8442-5b19691c4979
Error Number:8178,State:1,Class:16
System.Data.SqlClient.SqlException (0x80131904): The parameterized query '(@id uniqueidentifier,@oldurl nvarchar(2000),@newurl nvarchar(20' expects the parameter '@newurl', which was not supplied.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at BVNetwork.NotFound.Core.Data.SqlRedirectRepository.<>c__DisplayClass19_0.<ExecuteNonQuery>b__0() at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass34_0.<Execute>b__0() at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass31_01.b__0()
at EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute[TResult](Func1 method) at BVNetwork.NotFound.Core.Data.SqlRedirectRepository.Create(CustomRedirect entity) at BVNetwork.NotFound.Controllers.NotFoundRedirectController.IgnoreRedirect(String oldUrl, Int32 pageNumber, String searchWord, Int32 pageSize) at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary2 parameters)
at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass24_0.b__0()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
at System.Web.Mvc.Controller.ExecuteCore()
at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext)
at EPiServer.Shell.Web.Mvc.ModuleMvcHandler.ProcessController(IController controller)
at EPiServer.Shell.Web.Mvc.ModuleMvcHandler.BeginProcessRequest(HttpContextBase httpContext, AsyncCallback callback, Object state)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
ClientConnectionId:691772a4-4415-4110-8442-5b19691c4979
Error Number:8178,State:1,Class:16
@marisks
Copy link
Member

marisks commented Feb 19, 2019

Hi, @Ram-K-Kumar thanks for reporting the error. I will check it this week.

@ErikJJonsson
Copy link

ErikJJonsson commented Mar 8, 2019 •
edited
Loading

Hi,

Any progress on this?
I get the same error when trying to migrate.

Edit: Just upgraded to 11.2.2 but still same error.

/Erik

@breizh22
Copy link

Same error for me as well.

@marisks
Copy link
Member

marisks commented Mar 15, 2019

I have pushed the fix to the Episerver Nuget feed but still waiting for it to be approved.

@evest
Copy link
Contributor

evest commented Mar 15, 2019

Just pushed it through, available in the feed now.

@ErikJJonsson
Copy link

I tested with version 11.2.3 but still get the same error when trying to migrate.

@marisks
Copy link
Member

marisks commented Mar 18, 2019

@ErikJJonsson Can you give more details of your issue? This issue is about saving suggestions, not migration.

@marisks marisks closed this as completed Mar 18, 2019
@Ram-K-Kumar
Copy link
Author

Thank you @marisks . Issue is resolved.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@marisks @evest @Ram-K-Kumar @ErikJJonsson @breizh22