Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Software Development Software Development
Search Search
Search for:
Tech Support Guy > > >

Trying to resolve a 12031 error


(!)

Tristaan's Avatar
Tristaan Tristaan is offline
Member with 46 posts.
THREAD STARTER
 
Join Date: Aug 2003
Experience: Intermediate
11-Jan-2005, 10:50 AM #1
Trying to resolve a 12031 error
Okay, without going into detail that may violate my companies non-disclosure...

...we're developing an application that sends an XML message to a server-side ASP page. That ASP page then sends the XML to a server-side DLL for processing.

When the XML file is very large (> 2 MB), we're experiencing a 12031 error on the client side. Research has shown this is a Connection Reset error.

Both the server-side DLL and the client side application are written in Delphi 7 and, as far as I can tell, all three "stages" in this process are using IXMLHTTPRequest for transmitting and processing the XML.

Further research on my part seems to indicate that the 12031 error is happening because the MSXML class is timing out on processing the large file.

I know the detail is rather sketchy, but does anyone have any suggestions on resolving this problem?
Rockn's Avatar
Computer Specs
Member with 21,189 posts.
 
Join Date: Jul 2001
Location: Somalia of the North, MN
Experience: Disenfranchised American
11-Jan-2005, 12:08 PM #2
You may want to look at your IIS servers script timeout settings.
Tristaan's Avatar
Tristaan Tristaan is offline
Member with 46 posts.
THREAD STARTER
 
Join Date: Aug 2003
Experience: Intermediate
11-Jan-2005, 03:42 PM #3
Assume I'm a total tyro and don't know where to find those and you would be right (I work in the QA department and I know how to break software but not necessarily all configurations necessary to set up software).

Also, I did check the settings on the particular web site and noticed that the connection time out was set to 120 seconds. It is most definitely taking more than 2 minutes to perform this task and, from what I can tell, we're not sending "Keep-Alive" messages across the connection.

I've upped that setting to 360 to see if it has any impact. But any further suggestions are welcome (including instructions to the script time out settings).
Rockn's Avatar
Computer Specs
Member with 21,189 posts.
 
Join Date: Jul 2001
Location: Somalia of the North, MN
Experience: Disenfranchised American
11-Jan-2005, 05:27 PM #4
Script timeout settings are located in the Windows Management Console.

http://support.microsoft.com/default...b;en-us;268364
Tristaan's Avatar
Tristaan Tristaan is offline
Member with 46 posts.
THREAD STARTER
 
Join Date: Aug 2003
Experience: Intermediate
11-Jan-2005, 06:06 PM #5
Actually, it turns out that it was the Connection Time out on the Web Site within IIS. It was set for 2 minutes. The XML transmission and the server side processing time was taking in excess of an hour and there were no keep alive messages being sent, therefore, after two minutes, the connection reset, generating a 12031.

So, it was a timeout setting... but it was ConnectionTime out.

Thanks, RockN, for confirming our suspicions.

Next question on the same lines....obviously, we may not want to have the connection timeout on the entire website set so high. Does anyone have a programmatic solution to be able to get past this timeout or, perhaps, for the specific task, disable the timeout until the task is done?
Rockn's Avatar
Computer Specs
Member with 21,189 posts.
 
Join Date: Jul 2001
Location: Somalia of the North, MN
Experience: Disenfranchised American
12-Jan-2005, 10:41 AM #6
Why in gods name would you even want any kind of scripting that takes that long to process? Is this a client side thing that initiates the whole process? I would be mad after two minutes had elapsed. Might need to investigate an updated DLL or something to speed up the process.
__________________
My no line signature
a
a
Tristaan's Avatar
Tristaan Tristaan is offline
Member with 46 posts.
THREAD STARTER
 
Join Date: Aug 2003
Experience: Intermediate
12-Jan-2005, 12:54 PM #7
We are examining some redesign work on our DLL to try and speed up the process.

However, the task being peformed is essentially a web admin task and not necessarily a general user task. The idea is that an XML message containing commands to update the web site's SQL database is transmitted. The XML is placed into memory and a process to update the web site's SQL database is started and the data is processed.

The XML file being transmitted on the REALLY large data is approximately 40 MB in size (takes many hours to process that, even on a fast server class machine). However, standard data size is approximately 1-2 MB of XML which updates within the regular 2 minute time frame. And the frequency at which data that size will be transmitted is VERY infrequent, with a standard change transmission consisting of maybe 30-40K of XML.

The problem is that the user that we are developing this process for has data consisting of, for a single SQL table, 91000 records to be transmitted and inserted. This is in addition to the several hundred records in other tables.

For now, we've bumped the connection timeout up to 6 minutes and documented to the user that, until we can figure out a better design for the process, to limit the amount of their upload. There are "workarounds" to get the data up there and, since the 91000 is like a once-a-year upload, they are easily done.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑