.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Error SSRS 2008

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server
 

I would like to save a Report as PDF.

It says an error; Invalide URI: The hostname couldnt be parsed.

 

What does that mean? It works on the others.

 

Regards.


One who can read, have a clear advantage!


View Complete Post


More Related Resource Links

ssrs 2008 R2 - report parameter with no default set throws java script error

  
We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

  
Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

"Service not available " Error in SSRS 2008

  
HI ALL, I Have created few reports in SSRS 2008 and deployed to report manager,though reports are working fine in it but sometime what happens when we click any reports its shows error "Service UnAvailable". after getting that report ,i simply close the window and open again after 10 or so ,again it work fine . Please suggest whether its a bug in report manager or i am commited some mistakes over it.   Regards Amit.

SSRS 2008 error - Sys.WebForms.PageRequestManagerServerErrorException: status code 12029

  

Hi,

I am executing a huge report in SSRS 2008, after some time the report doesn't renders and there is an error icon at the left bottom of the web page. When I click open it to see the details, it gives following error;

Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while
processing the request on the server. The status code returned from the server was: 12029.

Any help on this will be appreciated.

Regards.


SSRS 2008 R2 Email error

  

I'm attempting to ude the email notification through a subscription in SSRS 2008 R2 but am getting the following error:

An error has occurred during report processing.

The logs say:

library!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
processing!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: An exception has occurred in data set 'ComponentList'. Details: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
processing!WindowsService_19!720!09/24/2010-10:10:25:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
processing!WindowsService_19!720!09/24/2010-10:10:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingS

SSRS 2008 ERROR - rsProcessingAborted:System.ArgumentOutOfRangeException: Index was out of range. Mu

  

Hi,

I am using SQL Server 2008 R2 Ent. Edition 64 bit reporting services. The source data for report is at remote server and it is SQL Server 2005 Ent. Edition (though I don't think this matters here.) I have set the <WorkingSetMaximum> to 5GB for SSRS

I am testing the performance of report server and running a report with 100K records with 20 concurrent users. All 20 reports gets executed successfully. When I try with 25 or 30 users only 21 reports execute successfully when I see the ExecutionLog table. I see this exception in the report service log file. Please help.

ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.RemoveReadOnlyMembers(List`1 declarations)
   at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader..cto

SSRS 2008 R2 error

  

I wrote a custom function in a ssrs 2008 r2 report and tried to reference it in an experssion on a parameter, but I keep getting this error message "the defaultvalue exprsssion for thre report parameter "parm1" contains an error: Request for the permission of type 'Sytem.Security.Permissions.UIPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKey Token=b77a5c561934e089' failed."

My expression looks like this:  =Code.functioname(value1, value2)

I there  a security setting I need to make to get this to work?

 

Thanks in advance.

Dan

 

 


ssrs 2008 reports Datasource error in Test server..

  

Hi ,

 i Have upgraded my Reports from Report server  VS 2005 to  VS 2008 .

My reports works fine in local, development & test server.

After Ugrading to 2008 it works fine in local server & devlopement serverr.

 When i deployed to Test server i am trying to access my reports i am getting below errors,

 An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..

i checked the Datasource conncetion properties..its pointing to correct Test database only..

My reports are windows integrated...

Now it works in srs 2005 developement & test server. For same properties it works in dev server,  it  doesn't works in srs 2008 test server.

 

Why? Can anyone give me some idea...?

 


Word Export error when orientation is Landscape in SSRS 2008

  

Hi there,

        I have created a report in SSRS 2008, In the report properties I have selected Orientation as Landscape but when i Export the report to Word it prints the report on middle of the page and cuts the rest of the report.

Urgent help is needed!!!


SSRS 2008 Data Driven Subscription Timeout Error

  

Hi,

I have a report that pulls data from an SSAS 2008 cube.  The report does take a few minutes to run, as it is grabbing a lot of data.  The report is published to our sharepoint website, with stored credentials.  When I run this report manually on the sharepoint site, it works fine.  However, when I try to create a data driven subscription, it gives me the following error: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.  I've looked through the SSRS log file, and it basically just repeats this error.  I've also run SQL Server profiler, and I can see that all of the queries that populate the parameters run successfully, but then there are no more queries sent.  So, it seems that the connection is fine, but the data driven subscription has another timeout value that is causing the problem.  All of the datasets have a timeout = 0, so that is not the issue. 

I've also run a different data driven subscription using a smaller report (based on the same cube though), and it works fine.  Any thoughts on what I need to do to fix this?

Thanks!


Sum function giving error in SSRS 2008

  

Hi,

 Below expression is giving #Error in SSRS 2008, but working fine in SSRS 2005.

=Sum(Fields!Rate.Value)

Note: When i export the report result to excel sheet sum value is showing correctly.

Let me know if any one know about this error.

 

Thanks

Shiva


Problem Analysing SSRS 2008 R2 Error Logs

  

Hi,

I have a very simple SSRS 2008 R2 report in Sharepoint 2010 with embedded data source and data set connections. When I edited the deployed report within Report Builder 3.0 launched within Sharepoint 2010.
2.4.2) The query executed fine within the data set component of this report returning data.
2.4.3) On clicking on the run button I get the following error; -
"For more information about this error navigate to the report server on the local server machine, or enable remote errors
----------------------------
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
----------------------------
The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)"

I have been viewing the Execution log as follows; -

SELECT * FROM ReportServer.Dbo.ExecutionLogStorage ORDER BY LogEntryID DESC

I understand that I should get more information from; -

C:\Program Files\Microsoft SQL Server\MSRS10_50.<my instance name>\Reporting Services\logFiles\<today's log file>

But I don't know what my search criteria within this log file is. Can any body help?

I am currently looking at; - http://technet.micros

Error upgrading SQL Server 2008

  

i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:



Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

SSRS 2008 R2 and sharepoint 2007 report builder problems

  

I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu


SQL 2008 servers and MOSS 2007 with SSRS

  

I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS.  Here is the run down:

  • I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server.  In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
  • Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server.  The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)?  Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?


Server 2008 R2 -> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error mess

  

So I am using the aspnet_regiis.exe tool to encrypt sections of the web.config in my asp.net applications and services.  I have done this for years successfully on Windows Server 2003 (IIS 6).  However I just moved some apps over to Windows Server 2008 R2 (with IIS 7.5) and I am now receiving the following error at runtime:

"Server was unable to process request. ---> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: Bad Data."

Now I am quite familiar with this process and am stumped at what I have missed this time around.  I have done ALL of the following which typically suffices for the process on the server. PLEASE READ ALL AND DO NOT PROVIDE RESPONSES OR LINKS FOR THINGS I HAVE ALREADY DONE Thanks!!  Wink

  1. Imported the keys to the server using aspnet_regiis -pi  Result: Success
  2. Given FULL permission (using -full switch) using aspnet_regiis -pa to ALL of the following accounts  Result: Success
    1. VS 2008 Install - Windows Mobile 5.0 SDK R2 for Pocket PC: [2] Error: Installation failed for compon

        

      Hi,

      I am trying to install VS2008 on my Windows XP machine. I have MS Office 2003 and SP2. Disabled the Norton Anti-Virus. I am getting the following error. I appreciate if some one can help me.

      [08/26/10,07:04:36] Windows Mobile 5.0 SDK R2 for Pocket PC: [2] Error: Installation failed for component Windows Mobile 5.0 SDK R2 for Pocket PC. MSI returned error code 30
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Windows Mobile 5.0 SDK R2 for Pocket PC is not installed.
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Windows Mobile 5.0 SDK R2 for Smartphone was not attempted to be installed.
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Microsoft Device Emulator version 3.0 was not attempted to be installed.
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition (x86) was not attempted to be installed.
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Crystal Reports Basic for Visual Studio 2008 was not attempted to be installed.
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Microsoft Windows SDK for Visual Studio 2008 Tools (x86) was not attempted to be installed.
      [08/26/10,07:04:40] VS70pgui: [2] DepCheck indicates Microsoft Windows SDK for Visual Studio 2008 Headers and Libraries (x86) was not attempted to be installed.
      [08/26/10,07:04:40] VS70pgui: [2] DepCheck indicates Microsoft
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend