If you delete a role in Microsoft CRM, the Microsoft CRM program may become inaccessible.
Deleting a sub-business role that was inherited from a parent business causes a Microsoft CRM program to stop working.
Update information
The following file is available for download from the Microsoft Download Center:
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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:
- 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.
- Connect to MSCRM DB.
- Run the following query:
SELECT Name, DeletionStateCode, * FROM RoleBase
- 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.
- 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:
- On the computer that is running SQL Server, click Start, point to Programs, point to Microsoft SQL Server, and then click SQL Query Analyzer.
- Connect to MSCRM DB.
- Expand the MSCRM database user table.
- Right-click dbo.rolebase, and then click Open.
- 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
For technical support questions, visit the following Great Plains Web site:
Under
Assisted Support, click
New Support Request. You can also obtain technical support for Microsoft Business Solutions by phone at (888) 477-7877.