Error executing database query:   IFF serialization failure occurs, the script will prompt which process in session layer ... ;   Last updated on May 3, 2006

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; Error message starts here ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[Macromedia] [SQLServer JDBC Driver] [SQLServer] Transaction (Process ID 81) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

The error occurs in \\..\wwwroot\application_server\Modify_ListCases.cfm: line 85

83:     AND                    ((dbo.Applicants_Utility.Caseworker = '#trim(session.user)#')

84:     OR                              (Certifier = '#trim(session.user)#'))

85:     AND                    (Pay_type = '#trim(Paytype)#')

86:     ORDER by          Logged_Date          DESC

87:     </cfquery>

SQL

Please try the following:

                         Check the ColdFusion documentation to verify that you are using the correct syntax.

                         Search the Knowledge Base to find a solution to your problem.

Browser     Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322)

Remote Address     OctOct.OctOctOct.OctOctOct.Oct

Referrer     http://domain_name/application_server/Modify_listPaytypes.cfm

Date/Time     01-May-06 10:10 AM

Stack Trace (click to expand)

...

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; Error message ends here ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; Script sample starts here ...

Tags such as: </PLAINTEXT> <PRE> </PRE> </Q> </S> </SAMP> </SCRIPT> </SELECT> </SMALL> </STRIKE> </STRONG> </SUB> </SUP> </TABLE> <UL> </UL> </VAR> </WBR> <XMP> </XMP> <FONT face=arial> </FONT>

<SCRIPT language=JavaScript> Java script inside HTML compatible CFML starts here

function ShowHide(targetName) {

if (document.getElementById) { // NS6+ web browser version specification

target = document.getElementById (targetName);

} else if (document.all) { // IE4+ web browser version specification

target = document.all [targetName];

}

if (target) {

if (target.style.display == "none") {

target.style.display = "inline";

} else {

target.style.display = "none";

}

}

} Java script inside HTML compatible CFML ends here

<TABLE borderColor=#123456 cellPadding=Number bgColor=#AlphaNumberAlphaNumberAlphaNumber border=Number>

<TBODY>

    <TR>

<TD bgColor=#123456><FONT style="FONT: 11pt/13pt verdana; COLOR: white"
color=white>Error occurred while processing request </FONT> </TD>

    </TR>

<TR>

<TD> <FONT style="FONT: 8pt/11pt verdana; COLOR: black">

<TABLE cellSpacing=Zero cellPadding=Zero width=Number border=Zero>

<TBODY>

                                <TR>

<TD id=tableProps2 vAlign=center align=left width=Number>
<H1 id=textSection1
style="FONT: 13pt/15pt verdana; COLOR: block">Element COMPLETED is
undefined in QRYGETDUPS. </H1></TD>

                                </TR>

            <TR>
<TD id=tablePropsWidth width=Number colSpan=Number><FONT
style="FONT: 8pt/11pt verdana; COLOR: black"></FONT></TD>
            </TR>

<TR><TD>&nbsp;</TD></TR>

                                                            <TR>
<TD width=Number colSpan=Number><FONT style="FONT: 8pt/11pt verdana; COLOR: black">
The error occurred in
<B> C:\..\wwwroot\application_server\WebPageFileName_action.cfm: line 831</B>
<BR>
<B>Called from</B>
C:\..\wwwroot\application_server\WebPageFileName.action.cfm: line 806
<BR>
<B> Called from</B>
C:\..\wwwroot\application_server\WebPageFileName_action.cfm: line 788
<BR>
<B>Called from</B>
C:\..\wwwroot\application_server\WebPageFileName_action.cfm: line 778
<BR>
<B>Called from</B>
C:\..\wwwroot\application_server\WebPageFileName_action.cfm: line 1
<BR>
</FONT></TD>
                                                            </TR>

                                                                                                    <TR>
<TD colSpan=Number><PRE>829: XXXXXXXXXXXXXXX &lt;/tr&gt;
830 : XXXXXXXXXXXXXXX &lt;/cfform&gt; ColdFusion form and time
<B>831 : XXXXXXXXXXXXXXX &lt;cfif trim(qrygetdups.completed) IS ''P''&gt;</B>
832 : XXXXXXXXXXXXXXX &lt;tr&gt;
833 : XXXXXXXXXXXXXXX &lt;td align="center"&gt;
</PRE></TD>                                                                            </TR>
<TR>
<TD colSpan=2>
<HR color=#c0c0c0 noShade>
</TD></TD>
<TR>
<TD colSpan=2><FONT style="FONT: 8pt/11pt verdana; COLOR: black">Please try the following:
<UL>
<LI>Check the <A
href="http://www.macromedia.com/go/proddoc_getdoc"
target=new>ColdFusion documentation</A> to verify that you are using the correct syntax.
<LI>Search the <A
href="http://www.macromedia.com/support/coldfusion/"
target=new>Knowledge Base</A> to find a solution to your problem.
</LI></UL>
<P></P></FONT></TD></TR>
<TR>
<TD colSpan=2>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD><FONT style="FONT: 8pt/11pt verdana; COLOR: black">Browser i.e.Browser&nbsp; &nbsp;
</FONT></TD>
<TD><FONT style="FONT: 8pt/11pt verdana; COLOR: black">Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322) </FONT></TD></TR>
<TR>
<TD><FONT style="FONT: 8pt/11pt verdana; COLOR: black">Remote address&nbsp; &nbsp; </FONT></TD>
<TD><FONT style="FONT: 8pt/11pt verdana; COLOR: black">10.254.160.8</FONT></TD></TR>
<TR>
<TD><FONT style="FONT: 8pt/11pt verdana; COLOR: black">Referrer&nbsp; &nbsp; </FONT></TD>
<TD><FONT style="FONT: 8pt/11pt verdana; COLOR: black">http://Domain_Name/Server_Name/WebPageFileName.cfm</FONT>
<TR>
<TD><FONT style="FONT: 8pt/11pt verdana; COLOR: black">Date/Time&nbsp;&nbsp; </FONT></TD>
<TD><FONT style="FONT: 8pt/11pt verdana; COLOR: black">01-Apr-06 12:01 AM</FONT></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=500>
<TBODY>
<TR>
<TD vAlign=top><FONT style="FONT: 8pt/11pt verdana"><A>
onmouseover="window.status='Click to expand stack trace';return true;"
onclick="showHide('cf_stacktrace');return true;"
onmouseout="window.status=' ' ;return true; " href="javascript: ;">Stack
Trace (click to expand)</A> </FONT></TD></TR>
<TR>
<TD id=cf_stacktrace style="DISPLAY: none"><FONT style="FONT: 8pt/11pt verdana; COLOR: black">at
cfWebPageFileName_action2ecfm1936052398._factor13(C:\Inetpub\wwwroot\Application_Server\WebPageFileName_action.cfm:831)
at
cfWebPageFileName_action2ecfm1936052398._factor14(C:\Inetpub\wwwroot\Application_Server\WebPageFileName_action.cfm:806)
at
cfWebPageFileName_action2ecfm1936052398._factor15(C:\Inetpub\wwwroot\Application_Server\WebPageFileName_action.cfm:788)
at
cfWebPageFileName_action2ecfm1936052398._factor32(C:\Inetpub\wwwroot\Application_Server\WebPageFileName_action.cfm:778)
at
cfWebPageFileName_action2ecfm1936052398.runPage(C:\Inetpub\wwwroot\Application_Server\WebPageFileName_action.cfm:1)
<BR><BR><PRE>coldfusion.runtime.UndefinedElementException: Element COMPLETED is undefined in
at coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java.1049)
at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1004)
at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1111)
at cfWebPageFileName_action2ecfm1936052398._factor13(C:\Inetpub\wwwroot\Application_Server\WebPageFileName_action.cfm:831)
at cfWebPageFileName_action2ecfm1936052398._factor14(C:\Inetpub\wwwroot\Application_Server\WebPageFileName_action.cfm:806)
at cfWebPageFileName_action2ecfmTRANSACTION NUMBER._factor15(C:\Inetpub\wwwroot\Application_Server\WebPageFileName_action.cfm:788)
at cfWebPageFileName_action2ecfm1936052398._factor32(C:\Inetpub\wwwroot\Application_Server\WebPageFileName_action.cfm:778)
at cfWebPageFileName_action2ecfm1936052398.runPage(C:\Inetpub\wwwroot\Application_Server\WebPageFileName_action.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
</PRE></FONT></TD></TR></TBODY></FONT></TD></TR></TBODY></TABLE></BODY></HTML>

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; Script sample starts here ...