Event Viewer Log - Debugging issue

[freshegg]

Hi Guys,

I have a problem with my web server (WIN 2000 SP4)

It throws up debugging errors which when I researched told me to check the event viewer and under 'system' there were multiple warnings related to the debug issue
The 'W3SVC' are on IIS (vers 5.0) and are the first part of our logfile extension which reports to our stats server for web traffic.
There is a possibility that it is something to do with URL rewrite although I find that unlikely as the sites being affected are not all URL rewritten.
I checked if this was a memory issue (perhaps running out of memory to process the pages on different websites) howeverwhen I monitored the performance of the machine and there was loads of free memory and plenty of processor time available.


Just wondered if anyone had experienced a similar problem before and what there thought were

Thanks
The errors are below

DEBUGGING ERROR:

Sorry, There was a fatal error in the SQL Statement.

Error Number -2147217900
Error Description Incorrect syntax near the keyword 'AND'.
Error Source Microsoft OLE DB Provider for SQL Server
SQLState 42000 (Syntax error or access violation)
Native Error 156
Script Name /products.asp
Rewrite Rule /oldsite/products/2_A5-Radix-HaulBag.htm
SQL SELECT * FROM _sub WHERE subID = AND deleted=0

EVENT VIEWER WARNING:

Out of process application '/LM/W3SVC/55/ROOT' terminated unexpectedly.
For additional information specific to this message please visit the Microsoft Online Support site located at:

http://www.microsoft.com/contentredirect.asp.

 

[Catadmin]

Find the part of your code on the Web server that is calling the SQL statement which includes "SELECT * FROM _sub WHERE subID = AND deleted=0"

The subID doesn't have anything that it is equal to. Either the webpage code isn't passing anything to the Where statement for SubID or the statement was just written badly.




Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[freshegg]

Hi,

Thanks for the quick reponse

The main problem i need to fix is the Out of Process Application error. The SQL statement's missing parameter is a symptom of IIS's failure to successfully handle the URL rewritting. However when we manually test the rule all is fine. The rule only seems to fail when a BOT or Crawler hits it, which suggests the problem is to do with server load.

Any thoughts?

thanks

 

[freshegg]

Hi,

Still no joy on this matter - anyone any ideas?

thanks