SQL script errors when upgrading from v11 to v12

MyPoint CreditUnion asked on December 18, 2021 00:27

When I ran the Kentico v12 upgrade and it attempted to update my site it errored out on the SQL script part running the upgrade.sql query from E:\Program Files (x86)\Kentico\12.0\Upgrade110_120\SQL.

I checked the permissions and removed the SQL timeout settings. I also don't know what to do about the existing files or missing files.

Msg 208, Level 16, State 1, Line 1 Invalid object name 'CMS_SettingsKey'. Msg 4902, Level 16, State 1, Line 34 Cannot find the object "CMS_PageTemplate" because it does not exist or you do not have permissions. Msg 4902, Level 16, State 1, Line 41 Cannot find the object "CMS_Document" because it does not exist or you do not have permissions. Msg 2714, Level 16, State 6, Line 48 There is already an object named 'Temp_PageBuilderWidgets' in the database. Msg 4902, Level 16, State 1, Line 69 Cannot find the object "SM_LinkedInAccount" because it does not exist or you do not have permissions. Msg 1088, Level 16, State 12, Line 171 Cannot find the object "COM_Department" because it does not exist or you do not have permissions. Msg 1088, Level 16, State 12, Line 288 Cannot find the object "COM_InternalStatus" because it does not exist or you do not have permissions. Msg 3701, Level 11, State 5, Line 297 Cannot drop the table 'Community_Friend', because it does not exist or you do not have permission. Msg 4902, Level 16, State 1, Line 301 Cannot find the object "CMS_Form" because it does not exist or you do not have permissions. Msg 4902, Level 16, State 1, Line 311 Cannot find the object "CMS_Form" because it does not exist or you do not have permissions. Msg 4902, Level 16, State 1, Line 319 Cannot find the object "CMS_WebFarmTask" because it does not exist or you do not have permissions. Msg 4902, Level 16, State 1, Line 331 Cannot find the object "CMS_UserSettings" because it does not exist or you do not have permissions. Msg 3701, Level 11, State 5, Line 336 Cannot drop the table 'Messaging_ContactList', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 339 Cannot drop the table 'Messaging_IgnoreList', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 342 Cannot drop the table 'Messaging_Message', because it does not exist or you do not have permission. Msg 4902, Level 16, State 1, Line 346 Cannot find the object "CMS_HelpTopic" because it does not exist or you do not have permissions. Msg 4902, Level 16, State 1, Line 354 Cannot find the object "SM_FacebookAccount" because it does not exist or you do not have permissions.

(438 rows affected) Msg 208, Level 16, State 1, Procedure View_CMS_Tree_Joined, Line 4 [Batch Start Line 375] Invalid object name 'dbo.CMS_Tree'. Msg 1088, Level 16, State 12, Line 383 Cannot find the object "dbo.View_CMS_Tree_Joined" because it does not exist or you do not have permissions. Msg 1088, Level 16, State 12, Line 392 Cannot find the object "dbo.View_CMS_Tree_Joined" because it does not exist or you do not have permissions. Msg 3701, Level 11, State 5, Line 401 Cannot drop the view 'View_Community_Friend_Friends', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 403 Cannot drop the view 'View_Community_Friend_RequestedFriends', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 406 Cannot drop the view 'View_Messaging_IgnoreList', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 408 Cannot drop the view 'View_Messaging_ContactList', because it does not exist or you do not have permission. Msg 208, Level 16, State 1, Procedure View_Community_Member, Line 3 [Batch Start Line 409] Invalid object name 'CMS_User'. Msg 208, Level 16, State 1, Procedure View_CMS_User, Line 3 [Batch Start Line 413] Invalid object name 'CMS_User'. Msg 2715, Level 16, State 3, Procedure Proc_Staging_SelectTasksForSynchronization, Line 3 [Batch Start Line 417] Column, parameter, or variable #1: Cannot find data type Type_CMS_OrderedIntegerTable. Parameter or variable '@TaskIDs' has an invalid data type. Msg 1087, Level 16, State 1, Procedure Proc_Staging_SelectTasksForSynchronization, Line 15 [Batch Start Line 417] Must declare the table variable "@TaskIDs". Msg 1087, Level 16, State 1, Procedure Proc_Staging_SelectTasksForSynchronization, Line 23 [Batch Start Line 417] Must declare the table variable "@TaskIDs". Msg 1087, Level 16, State 1, Procedure Proc_Staging_SelectTasksForSynchronization, Line 29 [Batch Start Line 417] Must declare the table variable "@TaskIDs". Msg 208, Level 16, State 6, Procedure Proc_Newsletter_Emails_FetchEmailsToSend, Line 2 [Batch Start Line 453] Invalid object name 'Proc_Newsletter_Emails_FetchEmailsToSend'. Msg 3701, Level 11, State 5, Line 521 Cannot drop the procedure 'Proc_Newsletter_Issue_AddSentEmails', because it does not exist or you do not have permission. Msg 208, Level 16, State 1, Line 526 Invalid object name 'Newsletter_NewsletterIssue'. Msg 208, Level 16, State 1, Line 572 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 584 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 596 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 608 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 631 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 649 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 669 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 684 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 690 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 696 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 702 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 708 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 714 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 720 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 726 Invalid object name 'CMS_Document'. Msg 208, Level 16, State 1, Line 732 Invalid object name 'CMS_DocumentAlias'. Msg 208, Level 16, State 1, Line 736 Invalid object name 'CMS_PageTemplate'. Msg 4902, Level 16, State 1, Line 740 Cannot find the object "COM_OrderAddress" because it does not exist or you do not have permissions. Msg 208, Level 16, State 1, Line 748 Invalid object name 'COM_Order'. Msg 4902, Level 16, State 1, Line 790 Cannot find the object "COM_Order" because it does not exist or you do not have permissions. Msg 208, Level 16, State 1, Line 808 Invalid object name 'COM_OrderAddress'. Msg 1088, Level 16, State 12, Line 817 Cannot find the object "COM_OrderAddress" because it does not exist or you do not have permissions. Msg 208, Level 16, State 1, Line 821 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 825 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 851 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 877 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 890 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 903 Invalid object name 'CMS_Resource'. Msg 208, Level 16, State 1, Line 915 Invalid object name 'CMS_ScheduledTask'. Msg 208, Level 16, State 1, Line 919 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 932 Invalid object name 'CMS_MetaFile'. Msg 208, Level 16, State 1, Line 940 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 969 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 1019 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 1033 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 1051 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 1102 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 1128 Invalid object name 'CMS_PageTemplateCategory'. Msg 208, Level 16, State 1, Line 1165 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 1197 Invalid object name 'Newsletter_Subscriber'. Msg 208, Level 16, State 1, Line 1246 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 1255 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 1258 Invalid object name 'CMS_EmailTemplate'. Msg 208, Level 16, State 1, Line 1262 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 1266 Invalid object name 'CMS_Resource'. Msg 208, Level 16, State 1, Line 1278 Invalid object name 'CMS_Resource'. Msg 208, Level 16, State 1, Line 1320 Invalid object name 'CMS_Resource'. Msg 208, Level 16, State 1, Line 1363 Invalid object name 'CMS_Resource'. Msg 208, Level 16, State 1, Line 1407 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 1418 Invalid object name 'CMS_Widget'. Msg 208, Level 16, State 1, Line 1431 Invalid object name 'CMS_WebPart'. Msg 208, Level 16, State 1, Line 1462 Invalid object name 'CMS_Resource'. Msg 208, Level 16, State 1, Line 1468 Invalid object name 'CMS_WebTemplate'. Msg 208, Level 16, State 1, Line 1473 Invalid object name 'CMS_MacroRule'. Msg 208, Level 16, State 1, Line 1479 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 1493 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 1505 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 1531 Invalid object name 'CMS_Culture'. Msg 208, Level 16, State 1, Line 1553 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 1577 Invalid object name 'CMS_ScheduledTask'. Msg 208, Level 16, State 1, Line 1581 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 1632 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 1651 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 1670 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 1676 Invalid object name 'CMS_Resource'. Msg 208, Level 16, State 1, Line 1715 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 1725 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 1749 Invalid object name 'CMS_PageTemplateCategory'. Msg 208, Level 16, State 1, Line 1766 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 1900 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 1910 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 1920 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 1930 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 1935 Invalid object name 'CMS_EmailTemplate'. Msg 208, Level 16, State 1, Line 1941 Invalid object name 'CMS_Widget'. Msg 208, Level 16, State 1, Line 1957 Invalid object name 'CMS_WebPart'. Msg 208, Level 16, State 1, Line 1971 Invalid object name 'CMS_Resource'. Msg 208, Level 16, State 1, Line 1980 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 2005 Invalid object name 'CMS_Class'. Msg 208, Level 16, State 1, Line 2016 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 2028 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 2052 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 2064 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 2082 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 2094 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 2108 Invalid object name 'CMS_HelpTopic'. Msg 208, Level 16, State 1, Line 2304 Invalid object name 'CMS_HelpTopic'. Msg 208, Level 16, State 1, Line 2321 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 2325 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 2354 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 2400 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 2411 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 2431 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 2444 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 2463 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 2477 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 2491 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 2512 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 2531 Invalid object name 'CMS_FormUserControl'. Msg 208, Level 16, State 1, Line 2551 Invalid object name 'CMS_Resource'. Msg 208, Level 16, State 1, Line 2566 Invalid object name 'CMS_SettingsKey'. Msg 208, Level 16, State 1, Line 2691 Invalid object name 'CMS_SettingsCategory'. Msg 208, Level 16, State 1, Line 2723 Invalid object name 'CMS_UIElement'. Msg 208, Level 16, State 1, Line 2755 Invalid object name 'CMS_SettingsKey'.

sql script error v12

Recent Answers

vasu yerramsetti answered on December 19, 2021 09:13 (last edited on December 19, 2021 09:15)

Please check the Target DB connection details like user credentials and DB name is Correct or not. Also check user have sufficient permission to execute db scripts from SSMS/Database.

1 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on December 20, 2021 13:21

What is the objects prefix like? Or, who is the owner of the DB objects? By default it is DBO. However, the SQL script should be "DB owner" agnostic. What is the user account you are using to run the script? It seems to me that this user does not have sufficient permissions for all the operations over the DB.

0 votesVote for this answer Mark as a Correct answer

David te Kloese answered on December 21, 2021 11:56

As stated above, probably insufficient permissions. Usually "db_reader" and "db_writer" are enough for normal use, but especially during upgrades you often need "db_owner" permissions.

0 votesVote for this answer Mark as a Correct answer