Problem:

ERROR: Your transaction (process ID #%d) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.

Resolution:

Information in this Brief applies to:

• Starbase Server 5.x
• Microsoft SQL 7

Problem

When running the Universal Command line (stcmd) to perform check outs or checkins, the user may get the below error during the process if they are using a MSSQL 7 backend database.

" Your transaction (process ID #%d) was deadlocked with anotherprocess and has been chosen as the deadlock victim. Rerun yourtransaction."

Workaround

Microsoft has confirmed this to be a problem in SQL Server 7.0. Refer tobelow link for further information on this problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;239753

As a workaround, you can rerun the command line "stcmd" process andavoid deadlocks by referring to the Avoiding Deadlockssection of SQL Server Books Online for complete details. See above link.

This problem is only seen with MS SQL 7 so we (Borland Starteam) recommendsthat customer upgrades to MS SQL 2000.