Deleting a role in Microsoft CRM causes the Microsoft CRM program to become inaccessible (832908)


The information in this article applies to:

  • Microsoft Business Solutions CRM 1.0

SYMPTOMS

If you delete a role in Microsoft CRM, the Microsoft CRM program may become inaccessible.

CAUSE

Deleting a sub-business role that was inherited from a parent business causes a Microsoft CRM program to stop working.

RESOLUTION

Update information

The following file is available for download from the Microsoft Download Center:

DownloadDownload the CRM1.0-TK29646-Server-Windows2000.exe package now.

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

Install this update on a Microsoft CRM-based server. Make sure that Microsoft CRM Deployment Manager is not running before you install this update. This update supports the following Setup switches:
  • /?: Show the list of installation switches.
  • /u: Use Unattended mode.
  • /f: Force other programs to quit when the computer shuts down.
  • /z: Do not restart when the installation is complete.
  • /q: Use Quiet mode (no user interaction).
  • /x: Extract the files without running Setup.
For example, to install the update without any user intervention, use the following command:

crm1.0-tk29646-server-windows2000.exe /u /q

To verify that the update is installed on your computer, confirm that the following registry key exists:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\Microsoft CRM\1.0\Server\SP0\TK29646

After you apply this update to your Microsoft CRM implementation, you cannot delete a sub-business role that was inherited from a parent business. If you try to delete such a role, you receive the following generic error message:
Microsoft Business Solutions Customer Relationship Management
An error has occurred. For more information, contact your system administrator.
Detailed information about this error message is available in the application log in Event Viewer on the Microsoft CRM-based server. This is the detailed error message:
Error Message: Cannot delete a role that is inherited from a parent business.
Error Details: The role with ID {GUID} is not a top-level role.\
For additional information about diagnosing problems by using Event Viewer, click the following article number to view the article in the Microsoft Knowledge Base:

302542 How to diagnose system problems with Event Viewer in Microsoft Windows 2000

If you have already deleted a sub-business role and your Microsoft CRM program is not working, follow these steps to recover your system:
  1. On the computer that is running Microsoft SQL Server, click Start, point to Programs, point to Microsoft SQL Server, and then click SQL Query Analyzer.
  2. Connect to MSCRM DB.
  3. Run the following query:

    SELECT Name, DeletionStateCode, * FROM RoleBase

  4. Verify that the total roles with the specified name (in this case, NewRole) equal the root plus the number of business units in the root. The numbers will probably match because having more than one organization in the system is not supported.
  5. Run the following query:

    UPDATE RoleBase SET DeletionStateCode=2 WHERE Name='NewRole'

Notes

  • You must change "NewRole" to the role name that was deleted from the child (but that still exists in the root).
  • Be careful when you run this script. It deletes all the roles with the specified name in the organization.
You can also manually change the values for the deletionstatecode field in the rolebase table. To do this, follow these steps:
  1. On the computer that is running SQL Server, click Start, point to Programs, point to Microsoft SQL Server, and then click SQL Query Analyzer.
  2. Connect to MSCRM DB.
  3. Expand the MSCRM database user table.
  4. Right-click dbo.rolebase, and then click Open.
  5. Change the values of the deletionstatecode field to 2 for all roles with the specified name.

Removal information

You cannot remove this update.

Restart requirement

To correctly apply this update, the installation program tries to stop and restart some system services. The services that must be stopped are listed during the installation process. If the attempt to stop a service times out or does not succeed, you are prompted to restart your computer to complete the update. If you are prompted, restart the computer to make sure that the update is applied correctly.

File information

The English version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
   Date         Time   Version       Size     File name
   -----------------------------------------------------------
   19-Mar-2003  16:36  1.0.3017.101  473,672  Bizprivilege.dll
   19-Mar-2003  16:36  1.0.3017.101   59,976  CRMErrors.dll
You can also verify the files that are installed by this update by reviewing the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\Microsoft CRM\1.0\Server\SP0\TK29313\Filelist

MORE INFORMATION

For technical support questions, visit the following Great Plains Web site:

http://www.microsoft.com/dynamics/gp/default.mspx

Under Assisted Support, click New Support Request. You can also obtain technical support for Microsoft Business Solutions by phone at (888) 477-7877.
Modification Type:MinorLast Reviewed:9/29/2006
Keywords:kbMBSMigrate kbprb KB832908 kbAudDeveloper kbAudEndUser kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.