Stefan Motz
asked on
IISRESET from web page
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.
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.
ASKER
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={Terad ata};UID=A BCDEF;PWD= pw123456;P ersist Security Info=True;
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={Terad
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?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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".
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".
ASKER
I'm sorry; I meant to award the points equally for the three of you.
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