Report works fine on VS.NET 2003, get error when uploaded

Hello,

I created a report and use stored procedure to retrieve data. The report works perfect on VS.NET 2003 IDE. But when I upload the .rdl file to the report server, it doesn't work. The error msg I got is:

Reporting Services Error

---

An error has occurred during report processing. (rsProcessingAborted)Get Online HelpQuery execution failed for data set 'dsTransTime'. (rsErrorExecutingCommand)Get Online HelpProcedure 'usp_RPT_Procedure_Name' expects parameter '@.Parameter1', which was not supplied.

---

Anyone know the problem?
Thanks,Finally, I make it works. But I still don't know how I made it.
I cannot find a similiar errors from google. So everything I did is based on guess. Becasuse the error msg shows the report cannot take the parameter, I removed the parameter and re-created it again. Also, I use refresh button on the Data view to refresh the dataset.

Sometime I feel waired about Reporting services.

Report Viewer not available in VB Express?

I'm trying to use report viewer controls, but the controls do not appear in the toolbox. The file reportviewer.exe was not in the location specified in the help files, but I have downloaded it, and when I try to add it to the toolbox, I get the message 'ReportViewer.exe' is not a .Net module. Should there be a .dll somewhere? Is it not possible to use this control w/ VB Express / SQLExpress?

ReportViewer.exe contains the dlls for the controls. You need to run it to extract the dlls, and install them in the GAC. See http://msdn2.microsoft.com/en-us/library/ms251723(VS.80).aspx

report viewer keep showing report is being generated

hi all,

i developed a web app with embedded report viewer to show the reports (server report). everything works alright. i created a setup file to install it at another machine. everything looks ok except that when i want to view the report, it will always show 'Report is being generated' for a very long time when it only takes a few seconds when i view it on report server.

i found the following warning in event viewer (application):

Process information:

Process ID: 4976

Process name: aspnet_wp.exe

Account name: DWPC1\ASPNET

Exception information:

Exception type: SoapException

Exception message: System.Web.Services.Protocols.SoapException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found > Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found

at Microsoft.ReportingServices.WebServer.SessionStarterAction.CreateExisting()

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

End of inner exception stack trace

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

Request information:

Request URL: http://localhost/AirForce/Reserved.ReportViewerWebControl.axd?ReportSession=icwhpl55jbfwm355yxxw152i&ControlID=56545a8d-aaa2-4050-b66e-3a18d3c931d8&Culture=1033&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&Interval=539000

Request path: /AirForce/Reserved.ReportViewerWebControl.axd

User host address: 127.0.0.1

User: DWPC1\dwdvpr

Is authenticated: True

Authentication Type: Negotiate

Thread account name: DWPC1\ASPNET

Thread information:

Thread ID: 7

Thread account name: DWPC1\ASPNET

Is impersonating: False

Stack trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2005.Execution.ReportExecutionService.GetExecutionInfo()

at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetExecutionInfo()

at Microsoft.Reporting.WebForms.ServerReport.TouchSession()

at Microsoft.Reporting.WebForms.SessionKeepAliveOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)

at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Please help. No specific error message to help me debug. i have no idea what's wrong.

Thanks!

I saw this message quite often before I've tried this approach: before trying to change the report path or HistoryId do the following:
ReportViewer1.ServerReport.ReportPath = "";
ReportViewer1.ServerReport.Refresh();

However, I still get sometimes the message "ASP.NET session expired" or something similar.

report viewer keep showing report is being generated

hi all,

i developed a web app with embedded report viewer to show the reports (server report). everything works alright. i created a setup file to install it at another machine. everything looks ok except that when i want to view the report, it will always show 'Report is being generated' for a very long time when it only takes a few seconds when i view it on report server.

i found the following warning in event viewer (application):

Process information:

Process ID: 4976

Process name: aspnet_wp.exe

Account name: DWPC1\ASPNET

Exception information:

Exception type: SoapException

Exception message: System.Web.Services.Protocols.SoapException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found > Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found

at Microsoft.ReportingServices.WebServer.SessionStarterAction.CreateExisting()

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

End of inner exception stack trace

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

Request information:

Request URL: http://localhost/AirForce/Reserved.ReportViewerWebControl.axd?ReportSession=icwhpl55jbfwm355yxxw152i&ControlID=56545a8d-aaa2-4050-b66e-3a18d3c931d8&Culture=1033&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&Interval=539000

Request path: /AirForce/Reserved.ReportViewerWebControl.axd

User host address: 127.0.0.1

User: DWPC1\dwdvpr

Is authenticated: True

Authentication Type: Negotiate

Thread account name: DWPC1\ASPNET

Thread information:

Thread ID: 7

Thread account name: DWPC1\ASPNET

Is impersonating: False

Stack trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2005.Execution.ReportExecutionService.GetExecutionInfo()

at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetExecutionInfo()

at Microsoft.Reporting.WebForms.ServerReport.TouchSession()

at Microsoft.Reporting.WebForms.SessionKeepAliveOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)

at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Please help. No specific error message to help me debug. i have no idea what's wrong.

Thanks!

I saw this message quite often before I've tried this approach: before trying to change the report path or HistoryId do the following:
ReportViewer1.ServerReport.ReportPath = "";
ReportViewer1.ServerReport.Refresh();

However, I still get sometimes the message "ASP.NET session expired" or something similar.sql

Report Viewer Control - Export to PDF, Works on local IIS computer, but not another.

When exporting a report to a pdf file, I am experiencing what seems to be a "hang up" on the server. The code executes fine from my development machine, but when moved to the server I get this response. I also recieve this message if I click the refresh button. Acrobat could not open 'pdf9c9.tmp' because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decode). To create an Adobe PDF document, go to the source application. Then print the document to Adobe PDF.

Here is my code for reference. It works fine on one IIS, but not another. What could I be missing?

Dim warningsAs Microsoft.Reporting.WebForms.Warning() =Nothing

Dim streamidsAsString() =Nothing

Dim mimeTypeAsString =Nothing

Dim encodingAsString =Nothing

Dim extensionAsString =Nothing

Dim deviceInfoAsString

Dim bytesAsByte()

Dim lrAsNew Microsoft.Reporting.WebForms.LocalReport

lr.ReportPath ="Report1.rdlc"

'lr.DataSources.Add(New Microsoft.Reporting.WebForms.ReportDataSource("DischargeSummary", ObjectDataSource1()))

deviceInfo ="<DeviceInfo><SimplePageHeaders>True</SimplePageHeaders></DeviceInfo>"

bytes = ReportViewer1.LocalReport.Render("PDF", deviceInfo, mimeType, encoding, extension, streamids, warnings)

Response.ClearContent()

Response.ClearHeaders()

Response.ContentType ="application/pdf"

Response.BinaryWrite(bytes)

Response.Flush()

Response.Close()

Check security permission on the server.

report viewer conrtol problem

alslamo alikom...

Hi all...i have a problem with the report viewer control in visual studio 2005 ...i use the control to view a local report file (.rdlc)...and when i change the corresponding xml file (.rdlc) for example using the notepad...and then clicking refresh in the report viewer no thing happens and the new changes done to the report viewer doesn't appear....i have to close the whole application and run it again....so the new changes appear in the viewer....or i tried to remove the control from the form and construct a new one at run time viewing the same .rdlc file and add the new coonstructed viewer to the form and it viewed the new changes done to the .rdlc file...so the question is :

is there any way to refresh the report viewer...making it connect again to the .rdlc file and redraw it with the new changes...?

happy to communicate with u....wish u all a happy life...and thx for ur concern....

Clicking the refresh button will only reload the data for a report, not the report definition itself. To reload the definition, call ReportViewer.Reset(), and set the necessary properties on ReportViewer.LocalReport.|||

alslamo alikom....

thx alot brian...u were very helpfull....

Report Versioning

Is there a way to add a version number to an rdl file? If so can someone give me pointers on how to do it.

Thanks

-JW

You can add custom properties to RDL under the CustomProperties element. We met a similar requirement by adding a Version property. However, custom properties are not surfaced to the UI (neither Report Manager nor SSMS) so you have to parse the RDL to get to them. Implementing a standard Version property could be a welcome addition to a future release.

|||

You can also add hidden (internal) "Version" parameter with default value, and use it within your report.

Maciej

Report updates not Saving

Hi,

I have a problem when uploading changes/ new reports to the report manager. I can get to the upload file screen, I can even browse to the .rdl file that I want to upload, but then the "OK" button seems to be disabled. I cannot seem to get the Report manager to accept any new reports or changes to the old ones.

I have System Administrator access and everything was working perfectly untill about a week or two ago, no changes were made that I can see.

Please help!

See this tread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=173608&SiteID=1

Report updates not Saving

Hi,

I have a problem when uploading changes/ new reports to the report manager. I can get to the upload file screen, I can even browse to the .rdl file that I want to upload, but then the "OK" button seems to be disabled. I cannot seem to get the Report manager to accept any new reports or changes to the old ones.

I have System Administrator access and everything was working perfectly untill about a week or two ago, no changes were made that I can see.

Please help!

See this tread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=173608&SiteID=1

Report to be printed in the orientation set in the rpt

I run a crystal report from VB. I send the report directly to the printer. The rpt file of the report that i am generating has paper orientation set to "Landscape". When i print the report , it prints in Portrait(setting of the default printer). But, if i preview the report instead of directly sending to the printer, the orientation is what is in the rpt. How to solve this problem ? Has anyone came up with this problem.

thanks
priyaI have a code example in my signature called "VB6/CR Print Setup Dialog Ex." which shows how to preset the printer setting and use those for printing, etc.

Report to a text file

Hi !
When creating a maintenance plan, I can activate the option "Report to a
text file" available on the last page. How can I enable this option after
the maintenance plan was created ?
Thank you !
HugoDear Hugo,
Thank you for posting here.
We can manually enable the option "Report to a text file" by the steps
below:
1. Right click on the Maintenance Plan that you would like to enable the
option -> Click Modify.
2. In the right panel of the screen, we will find a button named "Reporting
and Logging" (just besides the "Manage Connections" button) on the design
Tab.
3. Click on this button, enable the option "Generate a test file report"
and then specify the location.
4. Click OK to apply the settings.
If anything is unclear regarding above steps, please don't hesitate to let
me know.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
| From: "Hugo" <newschrg@.noemail.noemail>
| Subject: Report to a text file
| Date: Mon, 24 Sep 2007 14:08:26 -0400
| Lines: 11
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| Message-ID: <OfApmXt$HHA.5424@.TK2MSFTNGP05.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: isis.reg03.rtss.qc.ca 142.84.196.21
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26187
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi !
|
| When creating a maintenance plan, I can activate the option "Report to a
| text file" available on the last page. How can I enable this option after
| the maintenance plan was created ?
|
| Thank you !
|
| Hugo
|
|
||||Thank you !
Hugo
"Adams Qu [MSFT]" <v-adamqu@.online.microsoft.com> a écrit dans le message de
news: yU9jbNy$HHA.240@.TK2MSFTNGHUB02.phx.gbl...
> Dear Hugo,
> Thank you for posting here.
> We can manually enable the option "Report to a text file" by the steps
> below:
> 1. Right click on the Maintenance Plan that you would like to enable the
> option -> Click Modify.
> 2. In the right panel of the screen, we will find a button named
> "Reporting
> and Logging" (just besides the "Manage Connections" button) on the design
> Tab.
> 3. Click on this button, enable the option "Generate a test file report"
> and then specify the location.
> 4. Click OK to apply the settings.
> If anything is unclear regarding above steps, please don't hesitate to let
> me know.
> Have a nice day!
> Best regards,
> Adams Qu
> MCSE, MCDBA, MCTS
> Microsoft Online Support
> Microsoft Global Technical Support Center
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
> | From: "Hugo" <newschrg@.noemail.noemail>
> | Subject: Report to a text file
> | Date: Mon, 24 Sep 2007 14:08:26 -0400
> | Lines: 11
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
> | Message-ID: <OfApmXt$HHA.5424@.TK2MSFTNGP05.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: isis.reg03.rtss.qc.ca 142.84.196.21
> | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
> | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26187
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | Hi !
> |
> | When creating a maintenance plan, I can activate the option "Report to a
> | text file" available on the last page. How can I enable this option
> after
> | the maintenance plan was created ?
> |
> | Thank you !
> |
> | Hugo
> |
> |
> |
>|||Dear Hugo,
We wanted to see if the information provided was helpful. Please keep us
posted on your progress and let us know if you have any additional
questions or concerns.
We are looking forward to your response.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| X-Tomcat-ID: 40360268
| References: <OfApmXt$HHA.5424@.TK2MSFTNGP05.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Tue, 25 Sep 2007 03:22:48 GMT
| Subject: RE: Report to a text file
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <yU9jbNy$HHA.240@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 53
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26212
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Dear Hugo,
|
| Thank you for posting here.
|
| We can manually enable the option "Report to a text file" by the steps
| below:
|
| 1. Right click on the Maintenance Plan that you would like to enable the
| option -> Click Modify.
| 2. In the right panel of the screen, we will find a button named
"Reporting
| and Logging" (just besides the "Manage Connections" button) on the design
| Tab.
| 3. Click on this button, enable the option "Generate a test file report"
| and then specify the location.
| 4. Click OK to apply the settings.
|
| If anything is unclear regarding above steps, please don't hesitate to
let
| me know.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| =====================================================| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| =====================================================| This posting is provided "AS IS" with no warranties, and confers no
rights.
| --
| | From: "Hugo" <newschrg@.noemail.noemail>
| | Subject: Report to a text file
| | Date: Mon, 24 Sep 2007 14:08:26 -0400
| | Lines: 11
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| | X-RFC2646: Format=Flowed; Original
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| | Message-ID: <OfApmXt$HHA.5424@.TK2MSFTNGP05.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: isis.reg03.rtss.qc.ca 142.84.196.21
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26187
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | Hi !
| |
| | When creating a maintenance plan, I can activate the option "Report to
a
| | text file" available on the last page. How can I enable this option
after
| | the maintenance plan was created ?
| |
| | Thank you !
| |
| | Hugo
| |
| |
| |
|
|sql

Report times out on Export after 90 seconds.

I have a report that is timing out after 90 seconds of run-time - but only
when exporting to an alternate file type (PDF, XLS, etc)- if I use the HTML
Viewer format, the report is displayed properly and only takes a couple of
seconds to run. The error message that I get back says "The operation has
timed-out", and I'll include the stack trace at the end of this message.
My application is calling the ReportingService.Render method using SOAP
Reporting Services Web Service to perform the export to a PDF format. I'm
able to see the same problem when using the Report manager to export the
report to PDF format. This report definition is using a table to display the
query results (no matrices), and is printing in landscape mode. I have RS
Service Pack 2 installed on the server.
The report is running off of a fairly small data set (4000-5000 records),
with a couple of tricky joins, but I can execute the query using SQL Server
Enterprise Manager in about 2 seconds. I have tried setting the data set
'Timeout' value to 3600 (1 hr) and 2147483647 (documentation named maximum
value) in the Report Designer for the .rdl itself (timeout element under
query element in rdl). I've tried setting "Connect Timeout=3600" in the
connection string for my Data Set defined on the Report Server. I have also
set the Report Server to not timeout report execution both in Site Settings
and the individual settings for the submitted report definition. What
timeout am I missing?
If I trim down my data set to under 1000 records, the Render call completes
before the timeout can occur, and I get my PDF. I've spent some time trying
to figure out what's going on, and am at a loss. Here's what I see happening
over time:
0:00 - Submit report - Render() call is made
0:05 - CPU Utilization on server jumps to 100%, I can see report job in
Report Manager
1:30 - I get error message back from Render() call saying "The operation has
timed-out."
2:35 - CPU utilization on server slows back down to normal, job is no longer
visible in Report Manager
Any help or suggestions greatly appreciated!With this same report, trying different export formats - this is what I've
found:
PDF - times out after 90 seconds
XLS - times out after 90 seconds.
TIF - times out after 90 seconds.
CSV - results show up after ~ 10 seconds.
HTML - results show up after ~ 10 seconds.
XML - results show up after ~ 10 seconds.
So it looks like anything that doesn't end up in a plain text export is
timing out on me. And here's that stack trace I promised earlier:
The operation has timed-out.
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest
request) at
System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest
request) at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at UT.RSRef.ReportingService.Render(String
Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds) in C:\Documents and Settings\Ben\My
Documents\Visual Studio Projects\REPOUTIL\Web
References\RSRef\Reference.cs:line 653 at UT.repoutil.Page_Load(Object
sender, EventArgs e) in c:\documents and settings\ben\my documents\visual
studio projects\repoutil\repoutil.cs:line 5209|||Ben,
Can you render other reports without timeouts? If they all time out, I
would say its somthing wrong with the export feature...
If its just this one report it might just be taking a long time to render if
the report is large, I believe you can change the timeout values in one of
the rsserver config files to allow you more time to either get your export,
or generate some other type of error that your not seeing now because of the
timeout.
Hope this helps in some way.
"Ben Shaffer" wrote:
> With this same report, trying different export formats - this is what I've
> found:
> PDF - times out after 90 seconds
> XLS - times out after 90 seconds.
> TIF - times out after 90 seconds.
> CSV - results show up after ~ 10 seconds.
> HTML - results show up after ~ 10 seconds.
> XML - results show up after ~ 10 seconds.
> So it looks like anything that doesn't end up in a plain text export is
> timing out on me. And here's that stack trace I promised earlier:
> The operation has timed-out.
> at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest
> request) at
> System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest
> request) at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at UT.RSRef.ReportingService.Render(String
> Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> Warning[]& Warnings, String[]& StreamIds) in C:\Documents and Settings\Ben\My
> Documents\Visual Studio Projects\REPOUTIL\Web
> References\RSRef\Reference.cs:line 653 at UT.repoutil.Page_Load(Object
> sender, EventArgs e) in c:\documents and settings\ben\my documents\visual
> studio projects\repoutil\repoutil.cs:line 5209
>|||Thanks Jason,
It's only one report that is giving me this headache. I have dozens more
that export before the timeout.
Can you point me towards any documentation on what the reportserver config
files are and what the settings do? I've found various *.config files in the
report server directories on the server, but haven't seen any keys that jump
out at me as being the right one for the timeout that's giving me grief.
"Jason Brinkley" wrote:
> Ben,
> Can you render other reports without timeouts? If they all time out, I
> would say its somthing wrong with the export feature...
> If its just this one report it might just be taking a long time to render if
> the report is large, I believe you can change the timeout values in one of
> the rsserver config files to allow you more time to either get your export,
> or generate some other type of error that your not seeing now because of the
> timeout.
> Hope this helps in some way.

Report subscription ...help !

I am facing problem today with subscription..it was working fine...but it stopped working today after I tried to make some changes in config file.. ..after I corrected again...its still not working.Here is my problem...I create subsctiptoon for file share ..I enter all required info in page and then click on OK button. but instead of showing my subscription list, it shows this error "The SQL Agent service is not running. This operation requires the SQL Agent service. (rsSchedulerNotResponding) Get Online Help " I have checked agent service hundred times in last few hours, its started ...I restarted it again ..I restarted Report Server service too...but its of no use..I am getting the same error again and again... Its quite critical issue for me ...so help me if u have any idea... Thanks !prashant

restart your SQL Agent service and then is should work

Report Size Limitation

Has anyone had issues with deploying large reports to a report server? I am
trying to deploy a 4061 Kb ".rdl" file. I get the error "Maximum request
length exceeded."
Is there any way to increase the acceptable file size or is this a
limitation of the product?
Any advice would be most appreciated.
Thankyou :)In the c:\windows\microsoft.net\framework\v1.1.4322\config\machine.config,
you can increase the file size. Search for maxRequestLength.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Darren" <Darren@.discussions.microsoft.com> wrote in message
news:B5FD289D-C0B7-48D7-B3A3-C8D888BA3826@.microsoft.com...
> Has anyone had issues with deploying large reports to a report server? I
am
> trying to deploy a 4061 Kb ".rdl" file. I get the error "Maximum request
> length exceeded."
> Is there any way to increase the acceptable file size or is this a
> limitation of the product?
> Any advice would be most appreciated.
> Thankyou :)
>|||Hi Darren:
By default ASP.NET uploads are limited to 4MB. You can change this
limit in the server's machine.config file.
Details are here:
PRB: Cannot Upload Large Files When You Use the HtmlInputFile Server
Control
http://support.microsoft.com/default.aspx?scid=kb;EN-US;295626
Hope this helps,
--
Scott
http://www.OdeToCode.com
On Tue, 10 Aug 2004 15:43:02 -0700, Darren
<Darren@.discussions.microsoft.com> wrote:
>Has anyone had issues with deploying large reports to a report server? I am
>trying to deploy a 4061 Kb ".rdl" file. I get the error "Maximum request
>length exceeded."
>Is there any way to increase the acceptable file size or is this a
>limitation of the product?
>Any advice would be most appreciated.
>Thankyou :)|||Thankyou Champion :)
That solved it...
"Brian Hartman [MSFT]" wrote:
> In the c:\windows\microsoft.net\framework\v1.1.4322\config\machine.config,
> you can increase the file size. Search for maxRequestLength.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Darren" <Darren@.discussions.microsoft.com> wrote in message
> news:B5FD289D-C0B7-48D7-B3A3-C8D888BA3826@.microsoft.com...
> > Has anyone had issues with deploying large reports to a report server? I
> am
> > trying to deploy a 4061 Kb ".rdl" file. I get the error "Maximum request
> > length exceeded."
> >
> > Is there any way to increase the acceptable file size or is this a
> > limitation of the product?
> >
> > Any advice would be most appreciated.
> >
> > Thankyou :)
> >
>
>|||Darren:
On the web server that you are deploying toâ?¦ The ReportServer application
(Reporting Services WebService App) web.config file must have the following
settingâ?¦.. <httpRuntime maxRequestLength="32768" />
This setting is within the system.web node of the web.config fileâ?¦without
this setting the maxRequestLength is set to 4096K by default..not enough for
long reports
Regards,
Dean Nero
Momentun Healthware Inc.
"Darren" wrote:
> Has anyone had issues with deploying large reports to a report server? I am
> trying to deploy a 4061 Kb ".rdl" file. I get the error "Maximum request
> length exceeded."
> Is there any way to increase the acceptable file size or is this a
> limitation of the product?
> Any advice would be most appreciated.
> Thankyou :)
>

Report Server Web Site Shows File Not Found

Hi -

I have installed VS2005 and SQL Server 2005, with all reporting services features turned on. When I look at IIS i see applications for ReportingServer and Reports.

But i cannot seem to browse or run any reports. From SQL Server management Studio, from IIS, from browser all give same results - page not found. Did I miss a configuration? Who needs permissions to what? I created the report in VS2005 and deployed it but i cannot see it in the IIS virtual directory for ReportServices. When i look at folders in management studio, i see the folders for the project, and the report, but they dont show up in IIS.

HELP! nothing works!

Deployed reports don't go into IIS. They are stored internally in the reporting services databases.

Go to http://localhost/reports

This should show you 'Report Manager'. You can execute your reports from there.

Regards

Paul

|||When you deploy reports in VS, what is the ReportServerUrl property of the project? You should be able to access the same url from IE.|||

The ReportServer settings on the project are to the Reporting Services web services. For URL access to a report you need to look at the help file. Here is an example:

http://servername/reportserver?/SampleReports/Employee Sales Summary&rs:Command=Render&rs:format=HTML4.0

Report Server Issue Object reference not set to an instance of an object

Hi all,

I'm getting this problem 'Object reference not set to an instance of an object.' whenever I try to review a report and I checked the log file and this is what it had

w3wp!ui!1!11/14/2006-10:54:20:: Unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Some previous forums stated checking the webconfig file but the web config file look okay. Is there another way to fix this.

Much Thanks,

Carl

All,

I forgot to mention that I can view the report okay in my local SQL development - When I deploy my reports to the Report Server I can not view the same reports in the Report Manager.

I get the ''Object reference not set to an instance of an object' where my report should be - Also I get this recorded in the log file:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 11/14/2006
Time: 1:39:03 PM
User: N/A
Computer: BOPIISDEV
Description:
Event code: 3005
Event message: An unhandled exception has occurred.

Event time: 11/14/2006 1:39:03 PM
Event time (UTC): 11/14/2006 7:39:03 PM

Event ID: 8dc01000f90d4cc39638a5abca4af97c
Event sequence: 16

Event occurrence: 1

Event detail code: 0

Application information:

Application domain: /LM/W3SVC/1/root/Reports-1-128080066085671029

Trust level: RosettaMgr

Application Virtual Path: /Reports

Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\

Machine name: BOPIISDEV
Process information:

Process ID: 5928

Process name: w3wp.exe

Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:

Exception type: NullReferenceException

Exception message: Object reference not set to an instance of an object.
Request information:

Request URL: http://bopiisdev/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.1399.00

Request path: /Reports/Reserved.ReportViewerWebControl.axd

User host address: XXX.168.93.50

User: XXXX\cevans

Is authenticated: True

Authentication Type: Negotiate

Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:

Thread ID: 1

Thread account name: NT AUTHORITY\NETWORK SERVICE

Is impersonating: True

Stack trace: at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

|||

Hi Carl,

Did you ever solve this issue? I'm getting the same error.

Thanks,

Rob

Report Server Issue Object reference not set to an instance of an object

Hi all,

I'm getting this problem 'Object reference not set to an instance of an object.' whenever I try to review a report and I checked the log file and this is what it had

w3wp!ui!1!11/14/2006-10:54:20:: Unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Some previous forums stated checking the webconfig file but the web config file look okay. Is there another way to fix this.

Much Thanks,

Carl

All,

I forgot to mention that I can view the report okay in my local SQL development - When I deploy my reports to the Report Server I can not view the same reports in the Report Manager.

I get the ''Object reference not set to an instance of an object' where my report should be - Also I get this recorded in the log file:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 11/14/2006
Time: 1:39:03 PM
User: N/A
Computer: BOPIISDEV
Description:
Event code: 3005
Event message: An unhandled exception has occurred.

Event time: 11/14/2006 1:39:03 PM
Event time (UTC): 11/14/2006 7:39:03 PM

Event ID: 8dc01000f90d4cc39638a5abca4af97c
Event sequence: 16

Event occurrence: 1

Event detail code: 0

Application information:

Application domain: /LM/W3SVC/1/root/Reports-1-128080066085671029

Trust level: RosettaMgr

Application Virtual Path: /Reports

Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\

Machine name: BOPIISDEV
Process information:

Process ID: 5928

Process name: w3wp.exe

Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:

Exception type: NullReferenceException

Exception message: Object reference not set to an instance of an object.
Request information:

Request URL: http://bopiisdev/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.1399.00

Request path: /Reports/Reserved.ReportViewerWebControl.axd

User host address: XXX.168.93.50

User: XXXX\cevans

Is authenticated: True

Authentication Type: Negotiate

Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:

Thread ID: 1

Thread account name: NT AUTHORITY\NETWORK SERVICE

Is impersonating: True

Stack trace: at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

|||

Hi Carl,

Did you ever solve this issue? I'm getting the same error.

Thanks,

Rob

report renders manually; subscription doesn't work

I can manually render and view a report, but my subscription to the same
report fails with this error in the log file:
ReportingServicesService!library!1210!07/19/2005-15:20:55:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!1210!07/19/2005-15:20:55:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1210!07/19/2005-15:20:55:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!1210!07/19/2005-15:20:55::
Notification e07ed229-a912-4843-b66f-fb15c2af2596 completed. Success: False,
Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension: Report
Server Email, Report: <report name>, Attempt 0
I have verified that the SMTP service is working, and there is no
undelivered mail in the mailroot.
Any ideas?
--
Berry Morgan
JSOHi Berry,
Based on my experience, the KB article 834859 probably applies to the issue
related to email delivery on your computer. As mentioined in the KB 834859,
there is a known issue that AuthzInitializeContextFromSid function passes a
non-null-terminated string to the DsGetDcName function. Apparently this
issue potentially cause problems when Reporting Services tries to use this
function.
To resolve this problem immediately, please contact Microsoft Product
Support Services to obtain the hotfix. For a complete list of Microsoft
Product Support Services phone numbers and information about support costs,
visit the following Microsoft Web site:
http://support.microsoft.com/default.aspx?scid=fh;[LN];CNTACTMS
Note In special cases, charges that are ordinarily incurred for support
calls may be canceled if a Microsoft Support Professional determines that a
specific update will resolve your problem. The usual support costs will
apply to additional support questions and issues that do not qualify for
the specific update in question.
You may also want to apply Windows 2003 SP1 which includes this hotfix.
If the issue persists, I suggest that you refer to the following article to
troubleshoot the issue:
842423 A call to the AuthzInitializeContextFromSid API function may fail
during
http://support.microsoft.com/?id=842423
If anything is unclear, feel free to let us know.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.