Microsoft KB Archive/828524

= You receive a deadlock in Commerce Server 2002 in the catalogproducts_upd_tr trigger =

Article ID: 828524

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition
 * Microsoft Commerce Server 2002 Service Pack 1
 * Microsoft Commerce Server 2002 Service Pack 2
 * Microsoft Commerce Server 2002, Service Pack 3 (SP3)

-





SYMPTOMS
When you update or delete items in the catalog programmatically in Microsoft Commerce Server 2002, you may notice that your application does not respond. Additional investigation indicates that a deadlock occurred on the Microsoft SQL Server. In a deadlock, various threads cannot continue because they are waiting on a set of resources that are held by each other or that are held by other threads.



CAUSE
Catalog tables have a trigger that is named catalogproducts_upd_tr. This trigger has a section that updates the global catalog information with a date that the catalog was last updated. This behavior occurs to support the DeltaExportXML method. With the DeltaExportXML method, you can export just the updated sections of the catalog.



RESOLUTION
To resolve this behavior, edit the _catalogproducts_upd_tr catalog trigger, where   is the name of your catalog. Then, remove the sections that are marked with braces (&quot;{ }&quot;): CREATE TRIGGER [name_catalogproducts_upd_tr] ON [name_catalogproducts] FOR UPDATE AS BEGIN SET NOCOUNT ON UPDATE [Ad_catalogproducts] SET LastModified=getdate from [Ad_catalogproducts] P, INSERTED I where P.oid = I.oid {UPDATE Catalogglobal} {SET ProductTableUpdated = getdate} {Where catalogname = N'name' } END



STATUS
This behavior is by design.

Keywords: kbprb KB828524

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.