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!
> |
>

How to copy reports to different servers

Hi,

Once a report is deployed to a specific server (server A), is there a way to "copy" it to a different server (servers B, C), without having to actually deploy it server by server?

In my case, I am trying to have the developers deploy the reports on the development server first (server A), and then manually or automatically copy them to a Preview server (server B), and later to a production server (server C). I cannot grant the developers full permissions on the production server, so a "copy" is what I'm thinking about....

Thanks in advance for any ideas.

Edwin.

Create one Solution file and add 3 reporting project files to it with different deployment locations. That will allow your devs to test and publish reports to your dev & preview enviroments, as well as copy reports to the production project so that someone with publishing rights to your prod server can deploy them.

Remeber to practice safe source!

|||You can always try Reporting Services Scripter at http://www.sqldbatips.com/

Or you can write some code for yourself either by copying reports from server A to B using the RS webservice, or a program that takes your rdl files and deploys it to all the servers.Check out "rs utility" and "ReportingService2005 class" in Books-OnLine. I can create a small code sample for you if you want to.|||

Right-click on the solution in Solution Explorer -> Properties

You can setup multiple configuration, each with different settings for

TargetDataSourceFolder

TargetReportFolder

TargetServerURL

Default configurations include

Active(Debug)

Debug

Debug(local)

Production

Funny thing is, I just noticed this today, as I used to change the TargetReportFolder a few times within the same solution, so thanks for asking