Solved

IISRESET from web page

Posted on 2014-11-05
14
147 Views
Last Modified: 2015-04-26
Hi Experts,
It happens quite often that my web page displays the error message below:

Provider error '8000ffff'
Catastrophic failure

The only way I can fix this is by resetting the IIS with the following command:
IISRESET

I am using Classic ASP.
I was wondering if the IIS could be reset automatically from the web page whenever the Catastrophic failure error appears.

Thank you for your help.
0
Comment
Question by:romsom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +1
14 Comments
 
LVL 53

Expert Comment

by:Scott Fell, EE MVE
ID: 40424427
What type of connection string  and database are you using?  What time of info are you getting (just text or images/blobs??  

Is there a specific place in your code?  Just one page or random?


http://classicasp.aspfaq.com/general/why-do-i-get-8000ffff/8002802b-errors.html
0
 

Author Comment

by:romsom
ID: 40424441
I get this error only when I return values from Teradata.
The query is quite complex and sometimes it causes the page time out. It's supposed to return real time data from different Data Warehouse tables.
This is the  connection string I'm using:
DSN=Teradata;DRIVER={Teradata};UID=ABCDEF;PWD=pw123456;Persist Security Info=True;
0
 
LVL 34

Expert Comment

by:Paul MacDonald
ID: 40424451
While it may be possible to do the IISReset from within the codebehind, it probably makes more sense to fix the problem.

As previously noted, is there any pattern to this behavior?  Is it daily?  Weekly?  Random?

Are there tasks being performed when the problem occurs?  Hitting a database?  Accessing an SSL page?  Etc...

What version of IIS are you running on?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 34

Assisted Solution

by:Paul MacDonald
Paul MacDonald earned 250 total points
ID: 40424458
Perhaps if you specified a timeout for the query?

DSN=Teradata;DRIVER={Teradata};UID=ABCDEF;PWD=pw123456;Persist Security Info=True; default command timeout=60; Connection Timeout=60;

...or something like that?
0
 

Author Comment

by:romsom
ID: 40424482
I've tried to increase the timeout but that didn't change the situation.
I get the Catastrophic Failure message about twice a month, but ironically almost always on my days off.
The page where the error message appears returns data from a Teradata database, and I guess it happens when too many users are querying the database at the same time.
I don't have codebehind, because I'm using Classic ASP. I am just curious if there is a piece of code that would automatically reset the IIS without me having to remote into the server and type IISRESET into the command prompt.
0
 
LVL 53

Assisted Solution

by:Scott Fell, EE MVE
Scott Fell,  EE MVE earned 125 total points
ID: 40424511
What about experimenting without using a DSN connection.

https://www.connectionstrings.com/ole-db-provider-for-teradata/
Provider=TDOLEDB;Data Source=myServerAddress;Persist Security Info=True;
User ID=myUsername;Password=myPassword;Session Mode=ANSI;

Open in new window

0
 

Author Comment

by:romsom
ID: 40424554
I've tried the connections string but this is the error I get:

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.
0
 
LVL 34

Assisted Solution

by:Paul MacDonald
Paul MacDonald earned 250 total points
ID: 40424729
I don't understand why an IISReset would fix a data access issue, other than to clear the error on the page itself.  A "Back" button could do that...

That said, can you try to trap the exception and re-run the query if the problem happens?

(Codebehind also refers to code inline...at least in this shop)
0
 
LVL 33

Accepted Solution

by:
Big Monty earned 125 total points
ID: 40424737
to perform an actual IISRESET from an asp page, have your link or whatever go to an asp page with the following code in it:

<%
Server.CreateObject("WSCript.Shell").Run "cmd.exe /c iisreset /reboot"
%>

Open in new window


you may want to put it in its own folder with Anonymous access disabled if your site is a public site, otherwise anyone would be able to reset the site, and I'm guessing you don't want that :)

I agree with the others in this post, this is just a band aid to the problem, best to find the actual issue causing the problem....
0
 

Author Comment

by:romsom
ID: 40424779
Thank you very much for your help and advise.
Fixing the problem makes more sense than just rebooting the server when it happens.
I've found some connections left open, maybe that's what caused the "Catastrophic Failure".
0
 

Author Comment

by:romsom
ID: 40424784
I'm sorry; I meant to award the points equally for the three of you.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Question about ASP Including Files 6 66
Button to go back 3 44
asp classic find word in string and get its value 7 48
add 'N to prepared ASP/VB insert statement 1 37
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question