Server Error in '/' Application.

Violation of PRIMARY KEY constraint 'PK__#ABC03A7__1E3536267F236AEA'. Cannot insert duplicate key in object 'dbo.@relatedData'. The duplicate key value is (527, 7, 1).
Violation of PRIMARY KEY constraint 'PK__#ABC03A7__1E3536267F236AEA'. Cannot insert duplicate key in object 'dbo.@relatedData'. The duplicate key value is (722, 6, 3).
The statement has been terminated.
The statement has been terminated.
Warning: Null value is eliminated by an aggregate or other SET operation.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ServiceModel.FaultException`1[[System.ServiceModel.ExceptionDetail, System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]: Violation of PRIMARY KEY constraint 'PK__#ABC03A7__1E3536267F236AEA'. Cannot insert duplicate key in object 'dbo.@relatedData'. The duplicate key value is (527, 7, 1).
Violation of PRIMARY KEY constraint 'PK__#ABC03A7__1E3536267F236AEA'. Cannot insert duplicate key in object 'dbo.@relatedData'. The duplicate key value is (722, 6, 3).
The statement has been terminated.
The statement has been terminated.
Warning: Null value is eliminated by an aggregate or other SET operation.

Source Error:


Line 27:     var heroContent = Html.RenderCmsComponent(new CenterContent { ID = "heroContent", Zone = "Hero", ParseStripes = true, DefaultStripe = "StripeSlider", StripePrefix = "Stripe", WrapperClass = "noSiteBounds" });
Line 28:     var centerContent = Html.RenderCmsComponent(new CenterContent { ID = "centerContent", Zone = "MainCol", ParseStripes = false });
Line 29:     var topContent = Html.RenderCmsComponent(new CenterContent { ID = "topContent", Zone = "Center", ParseStripes = true, DefaultStripe = "StripeDefault", StripePrefix = "Stripe", WrapperClass = "siteBounds" });
Line 30:     var sideContent = Html.RenderCmsComponent(new CenterContent { ID = "sideContent", Zone = "SideCol", ParseStripes = false });
Line 31:     var bottomContent = Html.RenderCmsComponent(new CenterContent { ID = "bottomContent", Zone = "Bottom", ParseStripes = true, DefaultStripe = "StripeDefault", StripePrefix = "Stripe", WrapperClass = "siteBounds" });

Source File: g:\Sites\Novus\Titan\Public\Display\Views\Display\PageLayouts\Novus\Themes.ReFlex.NHM\sidecontentafter.cshtml    Line: 29

Stack Trace:


[FaultException`1: Violation of PRIMARY KEY constraint 'PK__#ABC03A7__1E3536267F236AEA'. Cannot insert duplicate key in object 'dbo.@relatedData'. The duplicate key value is (527, 7, 1).
Violation of PRIMARY KEY constraint 'PK__#ABC03A7__1E3536267F236AEA'. Cannot insert duplicate key in object 'dbo.@relatedData'. The duplicate key value is (722, 6, 3).
The statement has been terminated.
The statement has been terminated.
Warning: Null value is eliminated by an aggregate or other SET operation.]
   System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +14764695
   System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +403
   NorthwoodsSoftwareDevelopment.Cms.WcfServices.ISiteBlockService.ReadDataContentForDisplayWithRelated(Int16 appID, Int32 docID, String blockData, String userCN, String password) +0
   NorthwoodsSoftwareDevelopment.Cms.WcfServices.SiteBlockServiceProxy.ReadDataContentForDisplayWithRelated(Int16 appID, Int32 docID, String blockData, String userCN, String password) +93
   NorthwoodsSoftwareDevelopment.Cms.Utilities.SiteBlockSupport.ReadDataContentForDisplay(Int32 docID, String blockData) +107
   NorthwoodsSoftwareDevelopment.Cms.Utilities.DataBlockSupport.ExtractOneDataItem(Int32 docID, XElement blockData) +160
   NorthwoodsSoftwareDevelopment.Cms.Display.DataDetail.InitializeCmsComponent(Int16 appID, String reserved, String userName, String userPassword, Int32 docID, XElement blockData, Int32 blockNumber) +794
   NorthwoodsSoftwareDevelopment.Cms.Display.CenterContent.InitOneBlock(XElement oneBlock, Int32 index, List`1 controls) +608
   NorthwoodsSoftwareDevelopment.Cms.Display.CenterContent.InitStripes(IEnumerable`1 xmlList) +1450
   NorthwoodsSoftwareDevelopment.Cms.Display.CenterContent.InitBlockComponents() +207
   NorthwoodsSoftwareDevelopment.Cms.Display.CenterContent.CmsRenderContents(HtmlTextWriter writer) +41
   NorthwoodsSoftwareDevelopment.Cms.Display.CmsComponentExtensions.RenderCmsComponent(HtmlHelper helper, CmsComponentBase component) +1772
   ASP._Page_Views_Display_PageLayouts_novus_themes_reflex_nhm_sidecontentafter_cshtml.Execute() in g:\Sites\Novus\Titan\Public\Display\Views\Display\PageLayouts\Novus\Themes.ReFlex.NHM\sidecontentafter.cshtml:29
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +252
   System.Web.Mvc.WebViewPage.ExecutePageHierarchy() +148
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +107
   System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context) +378
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult) +91
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult) +795
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList`1 filters, ActionResult actionResult) +81
   System.Web.Mvc.Async.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult) +188
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +38
   System.Web.Mvc.<>c.<BeginExecuteCore>b__152_1(IAsyncResult asyncResult, ExecuteCoreState innerState) +29
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +52
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +39
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +38
   System.Web.Mvc.<>c.<BeginProcessRequest>b__20_1(IAsyncResult asyncResult, ProcessRequestState innerState) +43
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +38
   System.Web.Mvc.<>c__DisplayClass5_0.<Wrap>b__0() +18
   System.Web.Mvc.ServerExecuteHttpHandlerWrapper.Wrap(Func`1 func) +29
   System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride) +1898

[HttpException (0x80004005): Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil+ServerExecuteHttpHandlerAsyncWrapper'.]
   System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride) +2596
   System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage) +131
   System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm) +29
   System.Web.Mvc.Html.ChildActionExtensions.ActionHelper(HtmlHelper htmlHelper, String actionName, String controllerName, RouteValueDictionary routeValues, TextWriter textWriter) +593
   System.Web.Mvc.Html.ChildActionExtensions.Action(HtmlHelper htmlHelper, String actionName, String controllerName, RouteValueDictionary routeValues) +113
   ASP._Page_Views_Display_Router_cshtml.Execute() +23642
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +252
   System.Web.Mvc.WebViewPage.ExecutePageHierarchy() +148
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +107
   System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context) +378
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult) +91
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult) +795
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList`1 filters, ActionResult actionResult) +81
   System.Web.Mvc.Async.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult) +188
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +38
   System.Web.Mvc.<>c.<BeginExecuteCore>b__152_1(IAsyncResult asyncResult, ExecuteCoreState innerState) +29
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +52
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +39
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +38
   System.Web.Mvc.<>c.<BeginProcessRequest>b__20_1(IAsyncResult asyncResult, ProcessRequestState innerState) +43
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +38
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +651
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +220
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +134


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0