an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Installation > V4 Migration script errors
Last Post 1/21/2010 8:50:22 AM By lukezy. 7 replies.
1/3/2010 9:33:39 PM
jsduggan
Posts: 52
Joined: 3/19/2009
V4 Migration script errors
I ran the V4 migration script and although it completed, the following list of errors were reported in SQL Server Manager (Im not sure if this is normal or not):
 

Dropping dbo.vw_DSC_Category_Count.IK_vw_DSC_Category_Count...

Msg 3701, Level 11, State 6, Line 1

Cannot drop the index 'dbo.vw_DSC_Category_Count.IK_vw_DSC_Category_Count', because it does not exist or you do not have permission.

Dropping dbo.DSC_Manufacturer.IX_DSC_Manufacturer_Name...

Msg 3701, Level 11, State 6, Line 1

Cannot drop the index 'dbo.DSC_Manufacturer.IX_DSC_Manufacturer_Name', because it does not exist or you do not have permission.

Dropping dbo.FK_DSC_Category_Manufacturer_Count_DSC_Manufacturer...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_Category_Manufacturer_Count" because it does not exist or you do not have permissions.

Dropping dbo.FK_DSC_Product_DSC_Manufacturer...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_Product" because it does not exist or you do not have permissions.

Removing schema binding from dbo.vw_DSC_Category_Count...

Msg 208, Level 16, State 1, Procedure vw_DSC_Category_Count, Line 4

Invalid object name 'dbo.DSC_Category'.

Dropping dbo.DSC_Block_GetIdByBlockReferenceName...

Msg 3701, Level 11, State 5, Line 1

Cannot drop the procedure 'dbo.DSC_Block_GetIdByBlockReferenceName', because it does not exist or you do not have permission.

Dropping dbo.DSC_DisplayControl_GetAll...

Msg 3701, Level 11, State 5, Line 1

Cannot drop the procedure 'dbo.DSC_DisplayControl_GetAll', because it does not exist or you do not have permission.

Dropping dbo.DSC_SelectionType_GetAll...

Msg 3701, Level 11, State 5, Line 1

Cannot drop the procedure 'dbo.DSC_SelectionType_GetAll', because it does not exist or you do not have permission.

Altering dbo.DSC_BulkImport...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_BulkImport" because it does not exist or you do not have permissions.

Altering dbo.DSC_Category...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_Category" because it does not exist or you do not have permissions.

Altering dbo.DSC_GiftCertificate...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_GiftCertificate" because it does not exist or you do not have permissions.

Altering dbo.DSC_Manufacturer...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_Manufacturer" because it does not exist or you do not have permissions.

Altering dbo.DSC_PageGroup...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_PageGroup" because it does not exist or you do not have permissions.

Altering dbo.DSC_Product...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_Product" because it does not exist or you do not have permissions.

Altering dbo.DSC_Product_CrossSell_Map...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_Product_CrossSell_Map" because it does not exist or you do not have permissions.

Altering dbo.DSC_Selection_Type_DisplayControl_Map...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_Selection_Type_DisplayControl_Map" because it does not exist or you do not have permissions.

Creating dbo.DSC_Form...

Creating dbo.DSC_Form_Data...

Creating dbo.DSC_Form_Field...

Creating dbo.DSC_Product_VolumePricing...

Creating dbo.CategoryProductUDT...

Creating dbo.CrossSellProductUDT...

Creating dbo.FormDataUDT...

Creating dbo.IdUDT...

Creating dbo.ProductAttributeUDT...

Creating dbo.ProductDescriptorUDT...

Creating dbo.ProductDownloadUDT...

Creating dbo.ProductImageUDT...

Creating dbo.VolumePricingUDT...

Creating dbo.DSC_Manufacturer.IX_DSC_Manufacturer_Name...

Msg 1088, Level 16, State 12, Line 1

Cannot find the object "dbo.DSC_Manufacturer" because it does not exist or you do not have permissions.

Creating dbo.DSC_Form.IX_DSC_Form_Name...

Creating dbo.DSC_Form_Data.IX_DSC_Form_Data_FormIdCreated...

Creating dbo.DSC_Form_Field.IX_DSC_Form_Field_Form...

Creating dbo.DF_DSC_Form_Data_Created...

Creating dbo.PK_DSC_Form...

Creating dbo.PK_DSC_Form_Data...

Creating dbo.PK_DSC_Form_Field...

Creating dbo.PK_DSC_Product_VolumnPricing...

Altering Full Text...

Msg 208, Level 16, State 52, Line 1

Invalid object name 'dbo.DSC_Product'.

Creating Full Text...

Msg 208, Level 16, State 49, Line 1

Invalid object name 'dbo.DSC_Manufacturer'.

Creating Full Text...

Msg 208, Level 16, State 49, Line 1

Invalid object name 'dbo.DSC_PageHeader'.

Creating dbo.FK_DSC_Category_Manufacturer_Count_DSC_Manufacturer...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_Category_Manufacturer_Count" because it does not exist or you do not have permissions.

Creating dbo.FK_DSC_Product_DSC_Manufacturer...

Msg 4902, Level 16, State 1, Line 1

Cannot find the object "dbo.DSC_Product" because it does not exist or you do not have permissions.

Creating dbo.FK_DSC_Form_Data_DSC_Form...

Creating dbo.FK_DSC_Form_Data_DSC_User...

Msg 1767, Level 16, State 0, Line 1

Foreign key 'FK_DSC_Form_Data_DSC_User' references invalid table 'dbo.DSC_User'.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

Creating dbo.FK_DSC_Form_Field_DSC_Form...

Creating dbo.FK_DSC_Form_Field_DSC_Selection_Type_DisplayControl_Map...

Msg 1767, Level 16, State 0, Line 1

Foreign key 'FK_DSC_Form_Field_DSC_Selection_Type_DisplayControl_Map' references invalid table 'dbo.DSC_Selection_Type_DisplayControl_Map'.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

Creating dbo.FK_DSC_Product_VolumnPricing_DSC_Product...

Msg 1767, Level 16, State 0, Line 1

Foreign key 'FK_DSC_Product_VolumnPricing_DSC_Product' references invalid table 'dbo.DSC_Product'.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

Altering dbo.DSC_Category_Add...

Msg 208, Level 16, State 6, Procedure DSC_Category_Add, Line 28

Invalid object name 'dbo.DSC_Category_Add'.

Altering dbo.DSC_Category_GetDetail...

Msg 208, Level 16, State 6, Procedure DSC_Category_GetDetail, Line 31

Invalid object name 'dbo.DSC_Category_GetDetail'.

Altering dbo.DSC_Category_Update...

Msg 208, Level 16, State 6, Procedure DSC_Category_Update, Line 44

Invalid object name 'dbo.DSC_Category_Update'.

Altering dbo.DSC_Html_Search...

Msg 208, Level 16, State 6, Procedure DSC_Html_Search, Line 25

Invalid object name 'dbo.DSC_Html_Search'.

Altering dbo.DSC_Order_AddRecurring...

Msg 208, Level 16, State 6, Procedure DSC_Order_AddRecurring, Line 77

Invalid object name 'dbo.DSC_Order_AddRecurring'.

Altering dbo.DSC_Product_Add_To_Category_Product_Map...

Msg 208, Level 16, State 6, Procedure DSC_Product_Add_To_Category_Product_Map, Line 11

Invalid object name 'dbo.DSC_Product_Add_To_Category_Product_Map'.

Altering dbo.DSC_Product_Add_To_Product_Attribute...

Msg 208, Level 16, State 6, Procedure DSC_Product_Add_To_Product_Attribute, Line 16

Invalid object name 'dbo.DSC_Product_Add_To_Product_Attribute'.

Altering dbo.DSC_Product_Add_To_Product_CrossSell_Map...

Msg 208, Level 16, State 6, Procedure DSC_Product_Add_To_Product_CrossSell_Map, Line 11

Invalid object name 'dbo.DSC_Product_Add_To_Product_CrossSell_Map'.

Altering dbo.DSC_Product_Add_To_Product_Descriptor...

Msg 208, Level 16, State 6, Procedure DSC_Product_Add_To_Product_Descriptor, Line 11

Invalid object name 'dbo.DSC_Product_Add_To_Product_Descriptor'.

Altering dbo.DSC_Product_Add_To_Product_Download...

Msg 208, Level 16, State 6, Procedure DSC_Product_Add_To_Product_Download, Line 11

Invalid object name 'dbo.DSC_Product_Add_To_Product_Download'.

Altering dbo.DSC_Product_Add_To_Product_Image_Map...

Msg 208, Level 16, State 6, Procedure DSC_Product_Add_To_Product_Image_Map, Line 11

Invalid object name 'dbo.DSC_Product_Add_To_Product_Image_Map'.

Altering dbo.DSC_Product_Delete...

Msg 208, Level 16, State 6, Procedure DSC_Product_Delete, Line 56

Invalid object name 'dbo.DSC_Product_Delete'.

Altering dbo.DSC_Product_GetSummaryByTempTable...

Msg 208, Level 16, State 6, Procedure DSC_Product_GetSummaryByTempTable, Line 79

Invalid object name 'dbo.DSC_Product_GetSummaryByTempTable'.

Altering dbo.DSC_Product_Search...

Msg 208, Level 16, State 6, Procedure DSC_Product_Search, Line 111

Invalid object name 'dbo.DSC_Product_Search'.

Altering dbo.DSC_Product_Update_Product_Attribute...

Msg 208, Level 16, State 6, Procedure DSC_Product_Update_Product_Attribute, Line 51

Invalid object name 'dbo.DSC_Product_Update_Product_Attribute'.

Altering dbo.DSC_Product_UpdateQuantity...

Msg 208, Level 16, State 6, Procedure DSC_Product_UpdateQuantity, Line 74

Invalid object name 'dbo.DSC_Product_UpdateQuantity'.

Altering dbo.DSC_User_Add...

Msg 208, Level 16, State 6, Procedure DSC_User_Add, Line 42

Invalid object name 'dbo.DSC_User_Add'.

Altering dbo.DSC_UserTrack_DailyCleanUp...

Msg 208, Level 16, State 6, Procedure DSC_UserTrack_DailyCleanUp, Line 92

Invalid object name 'dbo.DSC_UserTrack_DailyCleanUp'.

Creating dbo.DSC_FormData_Add...

Creating dbo.DSC_FormData_AddField...

Creating dbo.DSC_FormData_DeleteField...

Creating dbo.DSC_FormData_Get...

Creating dbo.DSC_FormData_GetById...

Creating dbo.DSC_FormData_Update...

Creating dbo.DSC_Order_GetMetrics...

Creating dbo.DSC_Order_UpdateCheckoutPaymentType...

Creating dbo.DSC_Order_UpdateEmail...

Creating dbo.DSC_Product_Add_To_Product_VolumePricing...

Creating dbo.DSC_Product_GetRestockProduct...

Creating dbo.DSC_Product_UpdateRestockNotificationSent...

Creating dbo.DSC_Sale_GetMetrics...

Creating dbo.DSC_Statistic_GetMetrics...

Altering dbo.DSC_Manufacturer_Delete...

Msg 208, Level 16, State 6, Procedure DSC_Manufacturer_Delete, Line 30

Invalid object name 'dbo.DSC_Manufacturer_Delete'.

Altering dbo.DSC_Product_Add...

Msg 208, Level 16, State 6, Procedure DSC_Product_Add, Line 78

Invalid object name 'dbo.DSC_Product_Add'.

Altering dbo.DSC_Product_Update...

Msg 208, Level 16, State 6, Procedure DSC_Product_Update, Line 120

Invalid object name 'dbo.DSC_Product_Update'.

Altering dbo.DSC_Category_GetCategoryIdFromCategoryPath...

Msg 208, Level 16, State 6, Procedure DSC_Category_GetCategoryIdFromCategoryPath, Line 56

Invalid object name 'dbo.DSC_Category_GetCategoryIdFromCategoryPath'.

Creating dbo.DSC_Product_VolumePricingGetRate...

Altering dbo.DSC_Order_Add_OrderItem...

Msg 208, Level 16, State 6, Procedure DSC_Order_Add_OrderItem, Line 131

Invalid object name 'dbo.DSC_Order_Add_OrderItem'.

Altering dbo.DSC_Order_Add_OrderItems...

Msg 208, Level 16, State 6, Procedure DSC_Order_Add_OrderItems, Line 89

Invalid object name 'dbo.DSC_Order_Add_OrderItems'.

Altering dbo.DSC_Order_Item_Add...

Msg 208, Level 16, State 6, Procedure DSC_Order_Item_Add, Line 33

Invalid object name 'dbo.DSC_Order_Item_Add'.

Altering dbo.DSC_Product_GetByCategoryPath_OrderByFeatured...

Msg 208, Level 16, State 6, Procedure DSC_Product_GetByCategoryPath_OrderByFeatured, Line 9

Invalid object name 'dbo.DSC_Product_GetByCategoryPath_OrderByFeatured'.

Altering dbo.DSC_Product_GetByCategoryPath_OrderByPrice...

Msg 208, Level 16, State 6, Procedure DSC_Product_GetByCategoryPath_OrderByPrice, Line 9

Invalid object name 'dbo.DSC_Product_GetByCategoryPath_OrderByPrice'.

Altering dbo.DSC_Product_GetByCategoryPath_OrderByProductName...

Msg 208, Level 16, State 6, Procedure DSC_Product_GetByCategoryPath_OrderByProductName, Line 9

Invalid object name 'dbo.DSC_Product_GetByCategoryPath_OrderByProductName'.

Altering dbo.DSC_Category_GetChildren...

Msg 208, Level 16, State 6, Procedure DSC_Category_GetChildren, Line 33

Invalid object name 'dbo.DSC_Category_GetChildren'.

Creating dbo.DSC_Product_GetAttributeQuantity...

Creating dbo.DSC_Product_GetTopProducts...

Adding schema binding to dbo.vw_DSC_Category_Count...

Msg 208, Level 16, State 1, Procedure vw_DSC_Category_Count, Line 5

Invalid object name 'dbo.DSC_Category'.

Creating dbo.vw_DSC_Category_Count.IK_vw_DSC_Category_Count...

Msg 1088, Level 16, State 12, Line 1

Cannot find the object "dbo.vw_DSC_Category_Count" because it does not exist or you do not have permissions.

Refreshing dbo.vw_DSC_Product_Stock...

Msg 15165, Level 16, State 1, Procedure sp_refreshsqlmodule_internal, Line 55

Could not find object 'dbo.vw_DSC_Product_Stock' or you do not have permission.

Altering dbo.DSC_Product_GetCrossSell...

Msg 208, Level 16, State 6, Procedure DSC_Product_GetCrossSell, Line 25

Invalid object name 'dbo.DSC_Product_GetCrossSell'.

Msg 1088, Level 16, State 11, Line 2

Cannot find the object "dbo.DSC_Block_Type_lkp" because it does not exist or you do not have permissions.

Msg 208, Level 16, State 1, Line 2

Invalid object name 'dbo.DSC_Order_Status_lkp'.

Msg 15151, Level 16, State 1, Line 2

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 3

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 4

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 5

Cannot find the object 'DSC_DisplayControl_lkp', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 6

Cannot find the object 'DSC_Selection_Type_DisplayControl_Map', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 7

Cannot find the object 'DSC_Selection_Type_lkp', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 8

Cannot find the object 'DSC_Image', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 10

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 11

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 12

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 13

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 14

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 15

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 16

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 17

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 18

Cannot find the user 'DSC_Public', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 2

Cannot find the object 'DSC_UserTrack', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 3

Cannot find the object 'DSC_Statistic', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 4

Cannot find the object 'DSC_Statistic_Category_lkp', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 5

Cannot find the user 'dynamicCertUser', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 7

Cannot find the certificate 'dynamicCert', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 8

Cannot find the certificate 'dynamicCert', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 9

Cannot find the certificate 'dynamicCert', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 10

Cannot find the certificate 'dynamicCert', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 11

Cannot find the certificate 'dynamicCert', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 12

Cannot find the certificate 'dynamicCert', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 13

Cannot find the certificate 'dynamicCert', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 14

Cannot find the certificate 'dynamicCert', because it does not exist or you do not have permission.

Msg 15151, Level 16, State 1, Line 15

Cannot find the certificate 'dynamicCert', because it does not exist or you do not have permission.

1/3/2010 9:48:22 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: V4 Migration script errors
Which version did you have before you ran the migration script? There are a few migration scripts. You might need to run more than one scripts if your previous version was older than V3.1. For example if you have V3.0 you will need to run MigrateV3.0ToV3.1.sql and then follow by MigrateV3.1ToV4.0.sql.
DotShoppingCart Staff
1/4/2010 10:35:36 AM
jsduggan
Posts: 52
Joined: 3/19/2009
Re: V4 Migration script errors
How do I check which version?  This is the one you installed for me on the 2008 server when I signed up for your hosting.
 
 
1/4/2010 11:30:37 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: V4 Migration script errors
Log in to the site admin and check the footer at the bottom. You should see something like "All Rights Reserved. v3.1.000 ".
DotShoppingCart Staff
1/4/2010 12:37:34 PM
jsduggan
Posts: 52
Joined: 3/19/2009
Re: V4 Migration script errors
I logged into admin and verified that my current version of DSC is 3.1.  The script I ran that produced all of the errors was the V3.1 to V4. So, it appears I ran the correct script.   
1/5/2010 3:10:24 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: V4 Migration script errors
Jeff, do you want us to do the migration for you? If so, you can just puchase a per incident support. If not, we will further investigate the issue and give you the hints to work around this issue.
DotShoppingCart Staff
1/21/2010 8:39:57 AM
seldi
Posts: 8
Joined: 12/2/2009
Re: V4 Migration script errors
I have the same problem. Plese any help 
 
Please can you describe in details the process.
1/21/2010 8:50:22 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: V4 Migration script errors
Make sure you download the latest version DotShoppingCartSuiteV4.01.zip which contains the fix already.
DotShoppingCart Staff