Re: Script Time Out Issue

Dash wrote:
Hi All
I have been fighting this one for several days and will much appreciate any pointers.

The issue concerns a vbscript running on Windows Server 2k3 SP2. The purpose of the script is to read from a SQL Server DB on the same server, process the data and and write it back to other tables in the DB.
There is a total of about 4k rows to process.

The issue is that the script fails after 75 seconds with no immediate error message. In Task Manager the CPU activity of wscript.exe which was bouncing between 10 and 15 % drops to 0 at the 75 second point, with no measurable variation from run to run.

After another 60 seconds I get a WSH Script Error message with a VB script Run Time error.

1. I have shuffled the DB so I don't think it is data related.
2. I have made multiple code changes to change the order of tyhe operations with no effect
3. wscript.timeout set for either 0 or 600 has no effect
4. IIS script timeout is set for 600s and I would not think was involved anyway.

I supect there is a timeout I am missing - I didn't find out about the wscript.timeout until long into the trouble shooting and fully expected that might have been the culprit - but it isn't.

Any suggestions will be much appreciated.



I'm assuming you are using ODBC to access SQL. I searched quickly, and it seems that 60 seconds is a default timeout. I wasn't able to quickly find how to change this, but this might give you something to look into.

Marco

--
Microsoft MVP - Windows PowerShell
http://www.microsoft.com/mvp

PowerGadgets MVP
http://www.powergadgets.com/mvp

Blog:
http://marcoshaw.blogspot.com
.

Relevant Pages

  • Re: Problem with script to add printers ports, need help.
    ... Windows Server 2003 R2, SP1 ... The script, which I will paste below, works fine on my XP machine. ... I have found that Win32_TCPIPPrinterPort *WILL* work on my server. ... Dim ArgObj, var1 ...
    (microsoft.public.windows.server.scripting)
  • RE: Why Cant You Set the PageFile on Server 2008 using VBScript and W
    ... During our automated build of Windows Server 2008, ... The script runs without errors AND outputs '0' to show that the setting has ... It looks like AutomaticManagedPagefile is a property, ...
    (microsoft.public.scripting.vbscript)
  • Re: Windows Server 2008 and redirected printer names
    ... Client Requires Windows Vista or Windows XP. ... Server Requires Windows Server 2008 or Windows Server 2003. ... But your script needs to impersonate a user account with at least ...
    (microsoft.public.windows.terminal_services)
  • Re: Windows Server 2008 and redirected printer names
    ... Client Requires Windows Vista or Windows XP. ... Server Requires Windows Server 2008 or Windows Server 2003. ... But your script needs to impersonate a user account with at least ...
    (microsoft.public.windows.terminal_services)
  • Re: Can you create a timed loop?
    ... the server is only a front end to the data store which is all on SAN. ... and I am getting the same timeout period of 45-50 ... You would then call this script from your logon script using either the ...
    (microsoft.public.scripting.vbscript)
Loading