SYMPTOMS

When you run a program that was created by using the Microsoft Business Solutions CRM Software Developers Kit (SDK) in Microsoft CRM 1.2, the program does not run. Additionally, you may receive the following error message:

80040e14

Incorrect syntax near the keyword 'group'.

CAUSE

This problem may occur when you run a program that is similar to the following program.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.

<fetch version='1.0' output-format='xml-platform' aggregate='true' mapping='logical' page='1' count='50'> <entity name='activity'> <attribute name='activityid' /> <attribute name='createdon' /> <filter type='or'> <filter type='and'> <!-- meeting --> <condition attribute='activitytypecode' operator='eq' value='142' /> <filter type='or'> <condition attribute='actualend' operator='on-or-after' value='2005-07-04T12:42:30' /> <condition attribute='scheduledstart' operator='on-or-after' value='2005-07-04T12:42:30' /> </filter> </filter> <filter type='and'> <condition attribute='activitytypecode' operator='ne' value='142' /> <filter type='or'> <filter type='and'> <condition attribute='actualend' operator='on-or-after' value='2005-07-04T12:42:30' /> </filter> <filter type='and'> <condition attribute='actualend' operator='null' /> <condition attribute='modifiedon' operator='on-or-after' value='2005-07-04T12:42:30' /> </filter> </filter> </filter> </filter> <link-entity name='activityparty' from='activityid' to='activityid'> <attribute name='participationtypemask' aggregate='count' alias='number' /> <filter> <condition attribute='partyid' operator='in'> <value>{5DFDE5AB-75DE-4EB0-B896-5EAA56BC1769}</value> </condition> </filter> </link-entity> <order attribute='createdon' descending='true' /> </entity> </fetch>

This example code creates a Transact-SQL statement on the Microsoft SQL Server side. Inside this statement, "group by" and "order by" Transact-SQL statements are used. This problem occurs when these statements are incorrectly used.

RESOLUTION

Microsoft CRM has a fix for this problem that is part of a cumulative update. The cumulative update information is described in the following Microsoft Knowledge Base article:

Update Rollup 2 is available for Microsoft CRM 1.2

MORE INFORMATION

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:

Description of the standard terminology that is used to describe Microsoft software updates

Microsoft Business Solutions CRM software hotfix and update package naming standards

MORE INFORMATION

You can contact a Microsoft CRM support professional directly at 877-752-1122

For Additional Information, please see:

http://mscrm.exiis.net/microsoft-crm-consulting/Pages/default.aspx