ASP / XML issue with IIS

[cordt.huneke]

Here is a brief description of the problem.


We have an ASP file (listener.asp) that is used to process
SOAP transactions on our web server. The ASP file uses
XML Core Services to load an XML file into a DOM document
variable. We process around 50,000 transactions a day
using this process. We have been getting intermittent
errors while trying to load the XML file. We typically
receive between 3 and 20 errors a day. We have attempted
many different fixes and we recently upgraded to XML Core
Services 4.0. None of our attempts have been successful
in resolving the issue. Here is an excerpt of the code
that fails.
Set oXMLDoc = Server.CreateObject
("Msxml2.DomDocument.4.0")
oXMLDoc.async = false
oXMLDoc.Load (strSchemaLocPhys)

where strSchemaLocPhys
is "C:\Inetpub\wwwroot\cbwapiprod\CBWWorkflow.xml".

 

[Jeff Cochran]

Here is a brief description of the problem.

We have an ASP file (listener.asp) that is used to process
SOAP transactions on our web server. The ASP file uses
XML Core Services to load an XML file into a DOM document
variable. We process around 50,000 transactions a day
using this process. We have been getting intermittent
errors while trying to load the XML file. We typically
receive between 3 and 20 errors a day. We have attempted
many different fixes and we recently upgraded to XML Core
Services 4.0. None of our attempts have been successful
in resolving the issue. Here is an excerpt of the code
that fails.
Set oXMLDoc = Server.CreateObject
("Msxml2.DomDocument.4.0")
oXMLDoc.async = false
oXMLDoc.Load (strSchemaLocPhys)

where strSchemaLocPhys
is "C:\Inetpub\wwwroot\cbwapiprod\CBWWorkflow.xml".

Might help if you post the error, in full.

Jeff

 

[Sanders Kaufman]

My experience is that "file-based" databases get these sporadic errors -
regardless of what you do.

You should always have error-handling code for if a database becomes
temporarily unavailable. At over 100 transactions per hour it's a sure bet
that SOMETHING will create this problem - antivirus stuff, anti-spam stuff,
defragmentation - something will make it unavailable for a few seconds per
day.