Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Invalid object name 'vs_usergrp' error message when upgrading a database to Microsoft Dynamics SL 2011

Invalid object name 'vs_usergrp' error message when upgrading a database to Microsoft Dynamics SL 2011

View products that this article applies to.

Symptoms

After you upgrade a database to Microsoft Dynamics SL 2011 or Microsoft Dynamics SL 2011 Service Pack 1, you notice the upgrade is not completed successfully. In the DbBuild.log file, you notice the following error:

Error Code: -2146232060
Error Text: Invalid object name 'vs_usergrp'.

↑ Back to the top

Cause

Because of an issue in Database Maintenance (98.290.00), one of the VS_ views may not be created during an upgrade.

↑ Back to the top

Resolution

Download and run the B2734949_workaround.sql script against your Application Database(s). To do this, follow these steps:

  1. Download the B2734949_workaround.sql script. B2734949_workaround.sql
  2. Open the script in Microsoft SQL Server Management Studio.
  3. Select your SL Application Database from the Available Databases drop-down box.
  4. On line 39 of the script, replace NAMEOFSYSTEMDB with the name of your SL System Database.
  5. Execute the script by pressing F5.
  6. Repeat for each of your SL Application databases.
  7. You do not have to re-upgrade the database after running the script.

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2734949
Revision : 2
Created on : 2/3/2017
Published on : 2/3/2017
Exists online : False
Views : 416