This is called a database deadlock. It occurs when two processes are
occurring simultaneously, and each process is waiting for the other
process to complete before it can continue. The result is that one
process is terminated, allowing the other process to grab the free'd up
resources, and complete its task. This was the single biggest problem we
ran into when converting from Access to SQL Server. There are various
steps you can take to try and reduce the occurrences of
deadlocks....email me off list and i'll be happy to share some of the
things we did to address this issue.
HTH
Brian Grant
----- Original Message -----
From: Brian Peddle <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 20, 2000 3:15 PM
Subject: Re: Serialization failure
> Your query could ber taking a very long time to execute. Do you use
any OR statements in it? I ran into this problem for the first time a
few weeks ago and altered the query and it has gone away.
>
>
> ---------- Original Message ----------------------------------
> From: "Lincoln Manning" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Tue, 20 Jun 2000 15:13:18 -0400
>
> >I keep getting this.... Help
>
> Error Occurred While Processing Request
>
> Error Diagnostic Information
>
> ODBC Error Code = 40001 (Serialization failure)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction
> (process ID #20) was deadlocked with another process and has
> been chosen as the deadlock victim. Rerun your transaction.
>
> Data Source = "ADS"
>
> The error occurred while processing an element with a general
> identifier of (CFQUERY), occupying document position (754:15) to
> (754:73) in the template file
> D:\ADS\ADMIN\SALESMANAGEMENT\DETAILS.CFM.
> --
> Lincoln Manning
> Web Application Developer
> Applied Virtual Vision
> [EMAIL PROTECTED]
> http://www.avv.com
> -----------------------------------------------------------------------
-------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
>
> -----------------------------------------------------------------------
-------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
