Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br />Record not found<br /><br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 4559<br />MSG_ERROR_REPORT (433) - OWXWEBAPPERROR (18) - at address 14498<br />MSG_SWEEPSESSION (6131) - OWXSESSION (52) - at address 20715<br />MSG_INITWEBSYSTEM (6133) - OWXSESSION (52) - at address 20763<br />GET_DOCALL (1284) - OCALLINTERFACE (53) - in native code<br />GET_DOCALL (1284) - OWXSESSION (52) - at address 8678<br />MSG_ONDFFUNC (4901) - OVDFINETSESSION (40) - at address 7256<br />MSG_STARTWEBAPP (5261) - OWEBAPP (38) - at address 11436<br />[start] - at address 36069<br /><br /><br /><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>

<head>
  <meta http-equiv="imagetoolbar" content="no">
  <meta name="Generator" content="cWebEx Framework ">
  <link rel="shortcut icon" href="images/favicon.ico">
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  <meta name="Description" content="Open Source for Visual DataFlex programming language" />
  <meta name="keywords" content="Visual DataFlex, DataFlex, WebApp, Crystal Reports, OSS, Open Source" />
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <title>VDF-GUIdance - cSQLWebAppError</title>
  <link rel="StyleSheet" href="css/screen.css" type="text/css"> 
  <link rel="StyleSheet" href="css/content.css" type="text/css"> 

  <script language="JavaScript" src="Scripts/help.js" type="text/javascript"></script>

<script language="JavaScript" src="scripts/buttons.js" type="text/javascript"></script>
<script language="JavaScript" src="scripts/editmenu.js" type="text/javascript"></script>
</head>

<body>

<table border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td valign="top" align="left" width="120" bgcolor="#535353"><div align="left"><table cellspacing="0"
    cellpadding="0" width="120" height="50%" bgcolor="#535353">
      <tr>
        <td valign="top" align="left" width="120" height="146" colspan="2"><a
        href="http://www.vdf-guidance.com" target="_parent"><img src="Images/vdfguilogo.gif"
        width="115" height="114" border="0" alt="VDF-GUIdance logo"></a> </td>
      </tr>

        <td height="100" valign="top" align="left" width="140">

<table border="0" cellspacing="0" width="100%" cellpadding="0" style="padding-left:6px;">
  <tr>
    <td width="100%" class="Menu">
    
    <table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='ViewPage.asp?Page=HOME'  >Homepage</a></td></tr></table>
<span><table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td class="Menu">&nbsp;<img src="Images/pls.gif" width="11" height="13" border="0" alt=""><a class='Menu' href='ViewPage.asp?Page=NEW'  >What's New</a></td></tr></table></span>
<table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='Page.asp?Page=SUBVERSION'  >Subversion</a></td></tr></table>
<table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='Page.asp?Page=HOWTO'  >How-To's</a></td></tr></table>
<table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='Page.asp?Page=PKG'  >Packages</a></td></tr></table>
<table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='Page.asp?Page=SOFTWARE'  >Software</a></td></tr></table>
<table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='Page.asp?Page=PRESENTATIONS'  >Presentations</a></td></tr></table>
<table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='Misc.asp?Page=MISCELLANEOUS'  >Tools</a></td></tr></table>
<table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='Page.asp?Page=RESOURCES'  >Resources</a></td></tr></table>
<table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='Page.asp?Page=DFLINKS'  >Links</a></td></tr></table>
<table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='Page.asp?Page=DISCLOSE'  >Disclaimer</a></td></tr></table>
<span><table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td class="Menu">&nbsp;<img src="Images/pls.gif" width="11" height="13" border="0" alt=""><a class='Menu' href='Page.asp?Page=OSDPROJECT'  >Projects</a></td></tr></table></span>
<span><table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td class="Menu">&nbsp;<img src="Images/pls.gif" width="11" height="13" border="0" alt=""><a class='Menu' href='Page.asp?Page=TEAM'  >About</a></td></tr></table></span>
<table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='Page.asp?Page=WAYBACK'  >Wayback</a></td></tr></table>
<span><table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td class="Menu">&nbsp;<img src="Images/pls.gif" width="11" height="13" border="0" alt=""><a class='Menu' href='ViewPage.asp?Page=FUNDING'  >Funding</a></td></tr></table></span>
<table border="0"  cellspacing="0" cellpadding="0" width="100%"><tr><td width=10 Class="Menu"></td><td Class="Menu" ><a class='Menu' href='Page.asp?Page=VIDEO'  >Videos</a></td></tr></table>
</td></tr></table>

      
    </td>
  </tr>
</table>
</td>
      </tr>
      <tr>
        <td height="1" valign="top" align="left" width="8" background="Images/lbbackground.gif"></td>
        <td height="1" valign="top" align="left" width="112"></td>
      </tr>
      <tr>
        <td align="left" colspan="2" background="Images/lbbackground.gif"></td>
      </tr>
      <tr>
        <td align="left" colspan="2"></td>
      </tr>
    </table>
    <table cellspacing="0" cellpadding="0" width="120" height="50%" bgcolor="#535353">
      <tr>
        <td height="1" valign="top" align="left" width="8"></td>
        <td height="1" valign="top" align="left" width="112"><br>
        <br>

        <br>
        </td>
      </tr>
      <tr>
        <td valign="top" align="left" width="120" height="146" colspan="2" bgcolor="#535353">&nbsp;
        <a href="https://www.dataaccess.com/" target="_blank">
         <img src="Images/PoweredByOrange.png" border="0" alt="Visual DataFlex Logo" align="center" width="100px">
         </a> 
        </td>
      </tr>
      <tr>
        <td height="1" valign="top" align="left" width="8"></td>
        <td height="1" valign="top" align="left" width="112"></td>
      </tr>
    </table>
    </div></td>
    <td valign="top" align="left" width="8" rowspan="2">&nbsp;&nbsp;</td>
    <td valign="top" align="left" width="90%" rowspan="2"><table width="100%" height="100%"
    cellspacing="0" cellpadding="0" border="0" valign="top">
      <tr>
        <td valign="top"><p align="center"><strong><em><font color="#BCBE56" face="Book Antiqua">Shared
        knowledge leads to accumulated knowledge</font></em></strong></p></td>

<td valign="top" >
<table cellspacing="0" cellpadding="0" border="0">
 <tr>
<td>
</td>
        <td valign="right"><p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a title='Printer Friendly Page' href='PrintContribPage.asp?Page=PKGCLSSQLWEBAPPE&ContribRecId=125' target='_blank'><img border='0' src='Images/Print.gif' alt='Printer Friendly Page' align='top'></a>
</p>
</td>
</tr>
</table>
      </tr>
      <tr>
        <td class="Content" valign="top" Width="700" colspan="2">
<br>
<h2>cSQLWebAppError                                                                                                         </h2>
<i>by Wil van Antwerpen                                                               </i><br /><br />
<table border="0" width="100%" bordercolor="#000000" cellpadding="0">
<tr>
<td width="66%" rowspan="8" align="left">
<h4>Summary</h4>
<small>A hickup in your SQL Server can take your webapp down for a long time. Here&#39;s a package I wrote for a customer to take care of this particular example.</small></td>
<td align="right"><small><small>Size: 8 KB </small></small></td>
<td><small><strong><a href="Contrib/PKG/CLS/SQLWEBAPPERR/cSQLWebAppError-20071231.zip">Download</a></strong> </small></td>
</tr>
<tr>
<td align="right"><small><small>Date Created:</small></small></td>
<td><small><small>15/02/2011</small></small></td>
</tr>
<tr>
<tr>
<td align="right"><small><small>Date Updated:</small></small></td>
<td><small><small>15/02/2011</small></small></td>
</tr>
<tr>
<td align="right"><small><small>Author:</small></small></td>
<td><small><small><a href="#" title="You have to login in order to be able to contact the author">Wil van Antwerpen                                                               </a>
</small></small></td>
</tr>
<tr>
<td align="right"><small><small>Company:</small></small></td>
<td><small><small><a href="http://www.antwise.com" target="_blank">Antwise Solutions                                                               </a></small></small></td>
</tr>
<tr>
</tr>
<tr>
</tr>
</table>
<br />
<br />
<a name="PKGCLSSQLWEBAPPE0"></a>
<div align="left" class="Content"><h3> WebApp SQL Errorhandler</h3> <br>
<br>
One of the fun things with webapps is when they don't work.<br>
A failing webapp might take your website down, not for just one user, but for all of them.<br>
Especially if you happen to restart your SQL server while a user queries a page. Then that particular process is stuck until it gets killed by the webapp service (if it gets killed)<br>
<br>
Here is an extended webapp error handler that helps you with this particular "process gets stuck" problem.<br>
</div>
<a name="PKGCLSSQLWEBAPPE1"></a>
<div align="left" class="Content">With this code, we can take the SQL server down, have a customer request a page during the down time and still have your webapp server completely recover within 2 minutes (assuming the SQL server connection is back up) It could even recover between a faulty page (server down) and the next one, although serving the first page is slower then as it has to set up the connection to the database once more.<br>
<br>
One thing you'll see in the new webapp error handler is that we added process Ids so that you can see in the webapp errorlog which process hung itself up... (Can you see the fun here where you cannot remotely debug such an event)<br>
<br>
Simple code, once you got it figured out.<br>
<br>
<h4> Thanks</h4> <br>
With special thanks to McFarland Cascade for allowing me to share this code.<br>
</div>
<a name="PKGCLSSQLWEBAPPE2"></a>
<div align="left" class="Content"><h4> Download</h4> <br>
<br>
<a href="https://www.vdf-guidance.com/Contrib/PKG/CLS/SQLWEBAPPERR/cSQLWebAppError-20071231.zip"><img src="images/icons/zip.gif" width="16" height="16" alt="" /> cSQLWebappError.zip</a> ~ 8kB<br>
</div>
<a name="PKGCLSSQLWEBAPPE3"></a>
<div align="left" class="Content"><h4> Subversion</h4> <br>
<br>
<a href="http://svn.vdf-guidance.com/cSQLWebAppError/trunk/SQLWebAppError/">http://svn.vdf-guidance.com/cSQLWebAppError/trunk/SQLWebAppError/</a><br>
</div>


        </td>
      </tr>
      <tr>
        <td class="Content" valign="top" height="100%"><p class="Content"><br>
        </td>
      </tr>
      <tr>
        <td class="footer" valign="bottom" height="20"><p align="center">Copyright &copy; 1999 - 2024 VDF-GUIdance on all material published, for details see our <a href="Viewpage.asp?Page=DISCLOSE">Disclaimer</a>.</p></td>
      </tr>
    </table>
    </td>
  </tr>
</table>
</body>
</html>