Looking for the v10 manual? Visit our new user's guide!
 
Search Descriptions Version
 
 
This article applies to: ML v7, ML8, MultiStore

Running Sql Script During A New Install Produces Large Numbers Of Errors Regarding Missing Objects


Symptoms 
When attempting to run the initial installation script against a clean database during the initial instalation, the script produces a large number of errors regarding missing objects (see example below). 

Cause
This is caused by using a case-sensitive database collation setting. 

Solution 
Select a different collation setting for your database. AspDotNetStorefront recommends using SQL_Latin1_General_CP1_CI_AS (this is the default collation for most standard SQL installations).  Assistance with this is outside the bounds of the free Help Desk. Please consult a knowledgeable Database Administrator/Technician for assistance if necessary.

Example Msg 208, Level 16, State 1, Procedure ProductEntity, Line 3 Invalid object name 'dbo.productcategory'. Msg 207, Level 16, State 1, Procedure GetQtyDiscountPct, Line 24 Invalid column name 'name'. Msg 207, Level 16, State 1, Procedure GetQtyDiscountPct, Line 24 Invalid column name 'configvalue'. Msg 207, Level 16, State 1, Procedure GetQtyDiscountPct, Line 25 Invalid column name 'name'. Msg 207, Level 16, State 1, Procedure GetQtyDiscountPct, Line 31 Invalid column name 'quantitydiscountid'. Msg 137, Level 15, State 2, Procedure Split, Line 13 Must declare the scalar variable "@STRING". Msg 137, Level 15, State 2, Procedure Split, Line 16 Must declare the scalar variable "@STRING". Msg 137, Level 15, State 2, Procedure Split, Line 18 Must declare the scalar variable "@STRING". Msg 137, Level 15, State 2, Procedure Split, Line 22 Must declare the scalar variable "@STRING". Msg 137, Level 15, State 2, Procedure Split, Line 24 Must declare the scalar variable "@STRING". Msg 137, Level 15, State 2, Procedure GetIndexColumns, Line 30 Must declare the scalar variable "@colNames". Msg 207, Level 16, State 1, Procedure aspdnsf_MoveToShoppingCart, Line 19 Invalid column name 'ShoppingCartRecId'. Msg 1087, Level 15, State 2, Procedure aspdnsf_GetCartSubTotalAndTax, Line 116 Must declare the table variable "@tblsubtotal". Msg 1087, Level 15, State 2, Procedure aspdnsf_GetCartSubTotalAndTax, Line 137 Must declare the table variable "@tblsubtotal". Msg 1087, Level 15, State 2, Procedure aspdnsf_GetCartSubTotalAndTax, Line 142 Must declare the table variable "@tblsubtotal". Msg 1087, Level 15, State 2, Procedure aspdnsf_GetCartSubTotalAndTax, Line 155 Must declare the table variable "@tblsubtotal". Msg 1087, Level 15, State 2, Procedure aspdnsf_GetCartSubTotalAndTax, Line 160 Must declare the table variable "@tblsubtotal". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 9 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 16 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 23 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 30 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 37 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 44 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 51 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 58 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 65 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 72 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 79 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 86 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 93 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 100 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 107 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 114 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 121 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 128 Must declare the scalar variable "@productid". Msg 137, Level 15, State 2, Procedure aspdnsf_NukeProduct, Line 135 Must declare the scalar variable "@productid". Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 83 Invalid column name 'categoryID'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 85 Invalid column name 'sectionID'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 87 Invalid column name 'manufacturerID'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 89 Invalid column name 'distributorID'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 91 Invalid column name 'genreID'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 93 Invalid column name 'vectorID'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 103 Invalid column name 'categoryID'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 103 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 103 Invalid column name 'displayorder'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 106 Invalid column name 'sectionId'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 106 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 106 Invalid column name 'displayorder'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 109 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 109 Invalid column name 'displayorder'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 112 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 112 Invalid column name 'displayorder'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 115 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 115 Invalid column name 'displayorder'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 118 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 118 Invalid column name 'displayorder'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 121 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 374 Invalid column name 'ProductID'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 382 Invalid column name 'quan'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 325 Invalid column name 'ImageFileNameOverride'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 346 Invalid column name 'inventory'. Msg 207, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 371 Invalid column name 'productid'. Msg 4104, Level 16, State 1, Procedure aspdnsf_SearchCategories, Line 11 The multi-part identifier "category.name" could not be bound. Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 40 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 40 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 81 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 81 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 121 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_AdjustInventory, Line 121 Invalid column name 'productid'. Msg 137, Level 15, State 2, Procedure aspdnsf_ExportProductList, Line 61 Must declare the scalar variable "@DistributorID". Msg 137, Level 15, State 2, Procedure aspdnsf_ExportProductList, Line 63 Must declare the scalar variable "@GenreID". Msg 137, Level 15, State 2, Procedure aspdnsf_ExportProductList, Line 65 Must declare the scalar variable "@VectorID". Msg 207, Level 16, State 1, Procedure aspdnsf_UndoImport, Line 8 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_UndoImport, Line 9 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_UndoImport, Line 10 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_UndoImport, Line 11 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_UndoImport, Line 12 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 12 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 12 Invalid column name 'published'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 25 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 25 Invalid column name 'published'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 38 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 38 Invalid column name 'published'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 51 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 51 Invalid column name 'published'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 65 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 65 Invalid column name 'published'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 78 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 78 Invalid column name 'published'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 89 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 89 Invalid column name 'published'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 100 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 100 Invalid column name 'published'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 113 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_EntityMgr, Line 113 Invalid column name 'published'. Msg 207, Level 16, State 1, Procedure aspdnsf_SearchManufacturers, Line 13 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_SearchManufacturers, Line 14 Invalid column name 'name'. Msg 207, Level 16, State 1, Procedure aspdnsf_SearchDistributors, Line 14 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_SearchDistributors, Line 15 Invalid column name 'name'. Msg 207, Level 16, State 1, Procedure aspdnsf_SearchGenres, Line 13 Invalid column name 'deleted'. Msg 207, Level 16, State 1, Procedure aspdnsf_SearchGenres, Line 14 Invalid column name 'name'. Msg 137, Level 15, State 2, Procedure aspdnsf_GetSimpleObjectEntityList, Line 35 Must declare the scalar variable "@CustomerLevelID". Msg 137, Level 15, State 2, Procedure aspdnsf_GetSimpleObjectEntityList, Line 57 Must declare the scalar variable "@CustomerLevelID". Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 49 Invalid column name 'customerid'. Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 49 Invalid column name 'carttype'. Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50 Invalid column name 'customerid'. Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50 Invalid column name 'carttype'. Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50 Invalid column name 'variantid'. Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50 Invalid column name 'chosencolor'. Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50 Invalid column name 'chosensize'. Msg 207, Level 16, State 1, Procedure aspdnsf_ReloadCart, Line 50 Invalid column name 'textoption'. Msg 137, Level 15, State 1, Procedure aspdnsf_PageQuery, Line 69 Must declare the scalar variable "@symbol". Msg 137, Level 15, State 2, Procedure aspdnsf_PageQuery, Line 73 Must declare the scalar variable "@colList". Msg 207, Level 16, State 1, Procedure aspdnsf_BestSellers, Line 28 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_BestSellers, Line 28 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_BestSellers, Line 29 Invalid column name 'variantid'. Msg 207, Level 16, State 1, Procedure aspdnsf_BestSellers, Line 29 Invalid column name 'variantid'. Msg 207, Level 16, State 1, Procedure aspdnsf_RecentAdditions, Line 21 Invalid column name 'productid'. Msg 207, Level 16, State 1, Procedure aspdnsf_RecentAdditions, Line 21 Invalid column name 'productid'. Msg 207, Level 16, State 1, Line 335 Invalid column name 'groupName'. Msg 208, Level 16, State 1, Line 3 Invalid object name 'dbo.customer'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.DocumentType'. Msg 8107, Level 16, State 1, Line 3 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.KitGroupType'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.LOG_Event'. Msg 8107, Level 16, State 1, Line 1 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.PollSortOrder'. Msg 8107, Level 16, State 1, Line 3 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.ProductType'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.TaxClass'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.SalesPrompt'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.ShippingCalculation'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.ShippingMethod'. Msg 208, Level 16, State 1, Line 42 Invalid object name 'dbo.topic'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Category'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Section'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Manufacturer'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Product'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.ProductVariant'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.KitItem'. Msg 8107, Level 16, State 1, Line 3 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Country'. Msg 8107, Level 16, State 1, Line 4 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.AffiliateActivityReason'. Msg 8107, Level 16, State 1, Line 2 IDENTITY_INSERT is already ON for table 'AspDotNetStorefront.dbo.Customer'. Cannot perform SET operation for table 'dbo.Currency'. Msg 207, Level 16, State 1, Line 1 Invalid column name 'SkuSuffix'. Msg 207, Level 16, State 1, Line 1 Invalid column name 'SkuSuffix'. Msg 207, Level 16, State 1, Line 1 Invalid column name 'SkuSuffix'. Msg 207, Level 16, State 1, Line 1 Invalid column name 'SkuSuffix'. Msg 207, Level 16, State 1, Line 1 Invalid column name 'SkuSuffix'. Msg 207, Level 16, State 1, Line 1 Invalid column name 'SkuSuffix'. Msg 207, Level 16, State 1, Line 1 Invalid column name 'SkuSuffix'. Msg 207, Level 16, State 1, Line 1 Invalid column name 'SkuSuffix'. Msg 208, Level 16, State 1, Line 4 Invalid object name 'dbo.category'. Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.section'. Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.library'. Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.manufacturer'. Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.distributor'. Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.product'. Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.product'. Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.product'. Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.document'. Msg 208, Level 16, State 1, Line 3 Invalid object name 'customer'. Msg 207, Level 16, State 1, Line 3 Invalid column name 'name'. Msg 207, Level 16, State 1, Line 3 Invalid column name 'name'. Msg 1911, Level 16, State 1, Procedure aspdnsf_CreateIndexes, Line 5 Column name 'GIftRegistryGUID' does not exist in the target table or view.