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.

Error message when you try to save a new custom entity in Microsoft Dynamics CRM 3.0: "An error has occurred. For more information, contact your administrator"


View products that this article applies to.

Symptoms

When you try to save a new custom entity in Microsoft Dynamics CRM 3.0, you receive the following error message:
An error has occurred. For more information, contact your administrator.
This problem occurs if you save the new entity in a Microsoft Dynamics CRM configuration that already includes many custom entities.

↑ Back to the top


Resolution

This problem was corrected in Microsoft Dynamics CRM 3.0 Update Rollup 3.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
935364Update Rollup 3 is available for Microsoft Dynamics CRM 3.0

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, submit a request to Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

File information

The English version of this hotfix 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 item in Control Panel.

Microsoft Dynamics CRM 3.0 server

File nameFile versionFile sizeDateTimePlatform
Setup.exe3.0.5300.1605471,91229-Mar-200720:18x86
Account distribution detail.rdlNot Applicable109,23702-May-200723:42Not Applicable
Account distribution.rdlNot Applicable65,37802-May-200708:42Not Applicable
Crmmsg.dll1.2.3297.12316,08829-Mar-200720:18x86
Crmnativeinteropproxy.dll3.0.5300.16153,422,05602-May-200712:04x86
Crmobjectmodel.dll3.0.5300.16156,760,29603-May-200703:04x86
Microsoft.crm.application.components.application.dll3.0.5300.1615689,51203-May-200702:48x86
Microsoft.crm.application.pages.dll3.0.5300.1615968,04003-May-200702:48x86
Microsoft.crm.objectmodel.dll3.0.5300.1615320,87203-May-200702:47x86
Microsoft.crm.platform.callout.manager.dll3.0.5300.161550,53603-May-200702:46x86
Microsoft.crm.platform.server.dll3.0.5300.1615247,14403-May-200702:46x86
Microsoft.crm.tools.importexportpublish.dll3.0.5300.1615161,12803-May-200702:46x86
Microsoft.crm.tools.workflowlibrary.dll3.0.5300.1615275,81603-May-200702:45x86
Mscrmcustom.dll3.0.5300.1605179,56029-Mar-200720:18x86
Msvcr71.dll7.10.3052.4355,03229-Mar-200720:18x86
Notes.htcNot Applicable16,90902-May-200723:41Not Applicable
Pkgutil.cmdNot Applicable11329-Mar-200705:18Not Applicable
Pkgutil.exe1.2.3297.10188,79229-Mar-200720:18x86
Print_dlg.aspxNot Applicable8,82202-May-200723:42Not Applicable
Sales pipeline detail.rdlNot Applicable92,00302-May-200723:42Not Applicable
Sales pipeline.rdlNot Applicable109,78702-May-200723:42Not Applicable
Microsoft.crm.tools.importexportpublish.dll3.0.5300.1615161,12803-May-200702:46x86
Microsoft.crm.objectmodel.dll3.0.5300.1318,21617-Nov-200504:39x86
Microsoft.crm.platform.callout.manager.dll3.0.5300.143,78417-Nov-200504:38x86
Microsoft.crm.platform.server.dll3.0.5300.1244,48817-Nov-200504:39x86
Crmdbhotfix.dll3.0.5300.1605105,83229-Mar-200720:18x86
Crmhotfix.cdfNot Applicable8,90206-May-200719:59Not Applicable
Kb927207_client.dll3.0.5300.161561,80003-May-200702:56x86
Kb930604_client.dll3.0.5300.161565,38402-May-200711:56x86
Kb931627_client.dll3.0.5300.1615160,10403-May-200702:56x86
Kb933214_client.dll3.0.5300.161571,01603-May-200702:56x86
Kb933423_client.dll3.0.5300.161591,49603-May-200702:56x86
Kb933658_client.dll3.0.5300.161567,43203-May-200702:56x86
Kb936204_client.dll3.0.5300.161592,52006-May-200718:55x86
Mscrmcustom.dll3.0.5300.1605179,56029-Mar-200720:18x86

Microsoft Dynamics CRM client for Microsoft Office Outlook

File nameFile versionFile sizeDateTimePlatform
Crmaddin.dll3.0.5300.16151,183,08003-May-200703:02x86
Crmmsg.dll1.2.3297.12316,08829-Mar-200720:18x86
Crmnativeinteropproxy.dll3.0.5300.16153,422,05603-May-200703:04x86
Crmobjectmodel.dll3.0.5300.16156,760,29603-May-200703:04x86
Microsoft.crm.application.components.application.dll3.0.5300.1615599,40002-May-200711:46x86
Microsoft.crm.application.pages.dll3.0.5300.1615738,66403-May-200702:46x86
Microsoft.crm.objectmodel.dll3.0.5300.1615320,87203-May-200702:47x86
Microsoft.crm.platform.callout.manager.dll3.0.5300.161550,53603-May-200702:47x86
Microsoft.crm.platform.server.dll3.0.5300.1615247,14403-May-200702:47x86
Mscrmcustom.dll3.0.5300.1605179,56029-Mar-200720:18x86
Msvcr71.dll7.10.3052.4355,03229-Mar-200720:18x86
Notes.htcNot Applicable16,90902-May-200723:42Not Applicable
Pkgutil.cmdNot Applicable11329-Mar-200705:18Not Applicable
Pkgutil.exe1.2.3297.10188,79229-Mar-200720:18x86
Print_dlg.aspxNot Applicable8,82202-May-200723:42Not Applicable
Syncqueue.dll3.0.5300.1615396,13603-May-200703:02x86
Microsoft.crm.objectmodel.dll3.0.5300.1318,23217-Nov-200504:42x86
Microsoft.crm.platform.callout.manager.dll3.0.5300.143,80017-Nov-200504:42x86
Microsoft.crm.platform.server.dll3.0.5300.1244,50417-Nov-200504:42x86
Crmhotfix.cdfNot Applicable5,14606-May-200719:57Not Applicable
Mscrmcustom.dll3.0.5300.1605179,56029-Mar-200720:18x86

Microsoft Dynamics CRM client for Microsoft Office Outlook Compatibility Update

File nameFile versionFile sizeDateTimePlatform
Setup.xmlNot Applicable2,90406-May-200720:14Not Applicable
V3cclientpatch30.mspNot Applicable3,153,92006-May-200720:46Not Applicable
Crmaddin.dll3.0.5300.16151,209,70403-May-200703:02x86
Crmnativeinteropproxy.dll3.0.5300.16153,422,05602-May-200712:04x86
Crmobjectmodel.dll3.0.5300.16156,760,29603-May-200703:04x86
Microsoft.crm.application.components.application.dll3.0.5300.1615599,40003-May-200702:48x86
Microsoft.crm.application.components.core.dll3.0.5300.1615292,20003-May-200702:46x86
Microsoft.crm.application.components.platform.dll3.0.5300.1615410,98403-May-200702:46x86
Microsoft.crm.application.components.strings.dll3.0.5300.1615726,37603-May-200702:46x86
Microsoft.crm.application.pages.dll3.0.5300.1615738,66403-May-200702:48x86
Microsoft.crm.dll3.0.5300.1615382,31203-May-200702:46x86
Microsoft.crm.objectmodel.dll3.0.5300.1615320,87203-May-200702:46x86
Microsoft.crm.platform.callout.manager.dll3.0.5300.161550,53603-May-200702:46x86
Microsoft.crm.platform.server.dll3.0.5300.1615247,14403-May-200702:46x86
Notes.htcNot Applicable16,90902-May-200723:42Not Applicable
Print_dlg.aspxNot Applicable8,82202-May-200723:42Not Applicable
Syncqueue.dll3.0.5300.1615396,13603-May-200703:02x86
Setup.xmlNot Applicable1,73006-May-200720:13Not Applicable
V3clightclientpatch30.mspNot Applicable887,29606-May-200720:46Not Applicable
Crmaddin.dll3.0.5300.16151,209,70403-May-200703:02x86
Microsoft.crm.application.components.core.dll3.0.5300.1615292,20003-May-200702:46x86
Microsoft.crm.application.components.platform.dll3.0.5300.1615410,98403-May-200702:46x86
Microsoft.crm.application.components.strings.dll3.0.5300.1615726,37603-May-200702:46x86
Microsoft.crm.dll3.0.5300.1615382,31203-May-200702:46x86

Installation information

Install this hotfix on computers that are running the Microsoft Dynamics CRM 3.0 server software or the Microsoft Dynamics CRM client for Microsoft Office Outlook.

Prerequisites

You must have Update Rollup 2 for Microsoft Dynamics CRM 3.0 installed to apply this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
927751 Update Rollup 2 for Microsoft Dynamics CRM 3.0 is available

Restart requirement

If you are prompted to restart the computer, you must restart the computer after you apply this hotfix.

Removal information

To remove this hotfix from a computer that is running Microsoft Windows Server 2003, Windows XP, or Windows 2000, use Add or Remove Programs in Control Panel. System administrators can use the Spuninst.exe tool to remove this hotfix from a computer that is running Windows Server 2003, Windows XP, or Windows 2000.

The Spuninst.exe tool is located in the %Windir%\$NTUninstallKB936204$\Spuninst folder. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
832475 Description of the new features in the package installer for Windows software updates

↑ Back to the top


More information

When this problem occurs, you receive the following error message in the Microsoft Dynamics CRM platform trace:
CRM Platform Trace:
RelationshipService.Update caught exception: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'and'.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.Metadata.CascadingSpGenerator.Process(CrmDbConnection dbconn, SqlTransaction transaction) at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue()
at Microsoft.Crm.Metadata.RelationshipService.Update(Guid relationshipId, RelationshipUpdateInfo relationshipInfo)
Additionally, you receive the following error message in the SQL Profiler trace:
User Error Message - Incorrect syntax near the keyword 'and'.

For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

↑ Back to the top


Keywords: KB936204, kbmbsmigrate, kbqfe, kbhotfixserver, kberrmsg, kbmbscustomization, kbautohotfix

↑ Back to the top

Article Info
Article ID : 936204
Revision : 5
Created on : 4/3/2008
Published on : 4/3/2008
Exists online : False
Views : 327