how to correct error on server side

I have a report that uses a stored procedure (DB2). I sometimes get this
error when running certain parameter combinations from the report deployed on
a portal.
"Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web browser to
retry your request.
Administrator Note: An error message detailing the cause of this specific
request failure can be found in the application event log of the web server.
Please review this log entry to discover what caused this error to occur. "
I am not sure where to intercept this. I assume it is coming from the
reporting services server but I dont know where to step in from requesting
the report ... to the execution ... to the display of this rather unfriendly
message. And where do I find the application event log ? Have looked
everywhere on report server for such a log to no avail :-(
Thanks!You might find information in one of the files at: C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
However, the error actually sounds like it comes from ASP.Net, not
Reporting Services. I searched for the error, and there can be many reasons
why this happens. Hope there is something in one of the logs to help you.
--
| Thread-Topic: how to correct error on server side
| thread-index: AcUfV6qsL0pjpLP9THCLVqoegvsWsQ==| X-WBNR-Posting-Host: 192.85.50.2
| From: "=?Utf-8?B?TUogVGFmdA==?=" <MJTaft@.discussions.microsoft.com>
| Subject: how to correct error on server side
| Date: Wed, 2 Mar 2005 10:43:03 -0800
| Lines: 19
| Message-ID: <6E08FFDD-6C09-49DA-AED3-5776FAAB6F67@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTCMTY1.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:44361
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have a report that uses a stored procedure (DB2). I sometimes get this
| error when running certain parameter combinations from the report
deployed on
| a portal.
|
| "Server Application Unavailable
| The web application you are attempting to access on this web server is
| currently unavailable. Please hit the "Refresh" button in your web
browser to
| retry your request.
| Administrator Note: An error message detailing the cause of this specific
| request failure can be found in the application event log of the web
server.
| Please review this log entry to discover what caused this error to occur.
"
|
| I am not sure where to intercept this. I assume it is coming from the
| reporting services server but I dont know where to step in from
requesting
| the report ... to the execution ... to the display of this rather
unfriendly
| message. And where do I find the application event log ? Have looked
| everywhere on report server for such a log to no avail :-(
|
| Thanks!
||||Thanks for the reply Brad. I have looked in the log files in the reporting
services location and should have put that in my initial post. There was
nothing there to help with this. I did see something in the system app event
log stating something like aspnet_wp.exe stopped unexpectedly but it didnt
give any more info than that. Also ... I have noticed in this newgroup that
there are several people that seem to be getting that error message however I
have not seen many suggestions as to how to correct it or where it comes
from. I will keep hoping that someone will help. Thanks.
""Brad Syputa - MS"" wrote:
> You might find information in one of the files at: C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
> However, the error actually sounds like it comes from ASP.Net, not
> Reporting Services. I searched for the error, and there can be many reasons
> why this happens. Hope there is something in one of the logs to help you.
> --
> | Thread-Topic: how to correct error on server side
> | thread-index: AcUfV6qsL0pjpLP9THCLVqoegvsWsQ==> | X-WBNR-Posting-Host: 192.85.50.2
> | From: "=?Utf-8?B?TUogVGFmdA==?=" <MJTaft@.discussions.microsoft.com>
> | Subject: how to correct error on server side
> | Date: Wed, 2 Mar 2005 10:43:03 -0800
> | Lines: 19
> | Message-ID: <6E08FFDD-6C09-49DA-AED3-5776FAAB6F67@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTCMTY1.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:44361
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I have a report that uses a stored procedure (DB2). I sometimes get this
> | error when running certain parameter combinations from the report
> deployed on
> | a portal.
> |
> | "Server Application Unavailable
> | The web application you are attempting to access on this web server is
> | currently unavailable. Please hit the "Refresh" button in your web
> browser to
> | retry your request.
> | Administrator Note: An error message detailing the cause of this specific
> | request failure can be found in the application event log of the web
> server.
> | Please review this log entry to discover what caused this error to occur.
> "
> |
> | I am not sure where to intercept this. I assume it is coming from the
> | reporting services server but I dont know where to step in from
> requesting
> | the report ... to the execution ... to the display of this rather
> unfriendly
> | message. And where do I find the application event log ? Have looked
> | everywhere on report server for such a log to no avail :-(
> |
> | Thanks!
> |
>