Try our conversational search powered by Generative AI!

AI OnAI Off

Open default quicksilver campaign in commerce manager shows error

Found in

EPiServer.Commerce 8.13.4

Created

Jul 03, 2015

Updated

Jul 24, 2015

Area

Falcon/Commerce/Commerce Manager

State

Closed, Fixed and Tested

Steps to reproduce

Steps to reproduce

  1. Go to commerce manager -> Marketing-> Campaign
  2. Open "QuickSilver" campaign



Expected: Detailed campaign is displayed

Actual: It shows error as below:


Server Error in '/' Application.

Unable to cast object of type 'System.DBNull' to type 'System.String'.


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.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace: 

[InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.]
   Mediachase.Commerce.Marketing.Dto.CampaignRow.get_Comments() +59

[StrongTypingException: The value for column 'Comments' in table 'Campaign' is DBNull.]
   Mediachase.Commerce.Marketing.Dto.CampaignRow.get_Comments() +113
   Mediachase.Commerce.Manager.Marketing.Tabs.CampaignEditTab.BindForm() +456
   Mediachase.Commerce.Manager.Marketing.Tabs.CampaignEditTab.Page_Load(Object sender, EventArgs e) +36
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
   System.Web.UI.Control.OnLoad(EventArgs e) +92
   System.Web.UI.Control.LoadRecursive() +54
   System.Web.UI.Control.LoadRecursive() +145
   System.Web.UI.Control.LoadRecursive() +145
   System.Web.UI.Control.LoadRecursive() +145
   System.Web.UI.Control.LoadRecursive() +145
   System.Web.UI.Control.LoadRecursive() +145
   System.Web.UI.Control.LoadRecursive() +145
   System.Web.UI.Control.LoadRecursive() +145
   System.Web.UI.Control.LoadRecursive() +145
   System.Web.UI.Control.LoadRecursive() +145
   System.Web.UI.Control.LoadRecursive() +145
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772


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