Try our conversational search powered by Generative AI!

CSV Import: Server Error when view item after import Inventory with invalid Inventory Status

Found in

Release 7.5

Created

Feb 27, 2014

Updated

Mar 14, 2014

Area

Falcon/Commerce/Commerce Manager/Catalog management

State

Closed, Fixed and Tested


Steps to reproduce

Precondition: Data of Inventory status of VariationInventoryPricing is not in "0,1,2" (for example 3,100)

1. Go to commerce manager -> catalog management -> Catalog -> CSV import catalog

2. upload the CSVs and mapping files in the attachment

3. Import step by step as order: Categories -> Variation -> Variation Inventory Pricing

4. View Variant 9,10,11

 

Observed: Display server error bellow:

Expected: Should validate for Inventory status field when run import CSV or convert to valid data.

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.Manager.Apps.Catalog.WarehouseInventoryRow.get_InventoryStatus() +101

[StrongTypingException: The value for column 'InventoryStatus' in table 'WarehouseInventory' is DBNull.]
   Mediachase.Commerce.Manager.Apps.Catalog.WarehouseInventoryRow.get_InventoryStatus() +199
   Mediachase.Commerce.Manager.Apps.Catalog.Tabs.WarehouseInventoryEditTab.BindForm(CatalogEntryModel model) +904
   Mediachase.Commerce.Manager.Core.Controls.EditViewControl.LoadContext(IDictionary context) +280
   Mediachase.Commerce.Manager.Catalog.CatalogEntryEdit.Page_Load(Object sender, EventArgs e) +384
   System.Web.UI.Control.LoadRecursive() +71
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Control.LoadRecursive() +190
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178


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