Value does not fall within the expected range sql reporting services
I just installed Reporting Services - and installed the sample reports and when I try view any of the individual reports all of them give this message "Value does not fall within the expected range sql reporting services" I also tried to create my own report, which compiles and I when I try to view it as well in the browser I get the same message.Thanks for any help.
January 19th, 2008 12:56am

>> the same message That's because the error you're getting has nothing to do with the reports. Ten to one that's a failure of the configuration file, which is XML. It's either failing validation when compared to the expected schema or missing a value in one of the required places or it's got a value it shouldn't have. You might want to read this post for a handle onwhat is wrong in your case: http://www.msdner.com/dev-archive/116/19-82-1169090.shtm ... and if it isn't exactly that set of nodes which is wrong in your case, maybe we can dope it out if you post your config files. (See here: http://spacefold.com/lisa/post/Configuring-Reporting-Services-is-a-bear-Will-this-bear-sh~t-or-emerge-from-the-woods-in-Katmai.aspx-- it is hard to believe how often this kind of stuff happens.) >L<
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2008 12:15am

>> the same message That's because the error you're getting has nothing to do with the reports. Ten to one that's a failure of the configuration file, which is XML. It's either failing validation when compared to the expected schema or missing a value in one of the required places or it's got a value it shouldn't have. You might want to read this post for a handle onwhat is wrong in your case: http://www.msdner.com/dev-archive/116/19-82-1169090.shtm ... and if it isn't exactly that set of nodes which is wrong in your case, maybe we can dope it out if you post your config files. (See here: http://spacefold.com/lisa/post/Configuring-Reporting-Services-is-a-bear-Will-this-bear-sh~t-or-emerge-from-the-woods-in-Katmai.aspx-- it is hard to believe how often this kind of stuff happens.) >L<
January 20th, 2008 12:15am

Lisa,Thanks for you help.Still have the prob - but your logic about it being an xml issue makes perfect sense. I have in the same entries in the web.config of the Report Manager mentioned in your first link.As for the second one when I remove the content of the ReportServerVirtualDirectory - I get an error "The ReportServerVirtualDirectory element is missing. " When I enter <ReportServerUrl>http://localhost/reports</ReportServerUrl> I get an error that "The report server requires that the computer name be specified instead. " ( but this is the way that I am browsing to the website ) - so if I do enter the name of the machine(http://devsql/reports I get prompted to give username and password credentials when I try to browse to the reports. Other than allowing anonymous access I am not sure how to get any further.Other than that this is what the rest of the rewebapplication.config file looks like.<Configuration> <UI> <ReportServerUrl>http://localhost/reports</ReportServerUrl> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel> </UI> <Extensions> <DeliveryUI> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider"> <DefaultDeliveryExtension>True</DefaultDeliveryExtension> <Configuration> <RSEmailDPConfiguration> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension> </RSEmailDPConfiguration> </Configuration> </Extension> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/> </DeliveryUI> </Extensions> <Add Key="MaxActiveReqForOneUser" Value="20"/> <Add Key="DisplayErrorLink" Value="true"/></Configuration>Really appreciate your help.ThanksSteve
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2008 6:27pm

Lisa,Thanks for you help.Still have the prob - but your logic about it being an xml issue makes perfect sense. I have in the same entries in the web.config of the Report Manager mentioned in your first link.As for the second one when I remove the content of the ReportServerVirtualDirectory - I get an error "The ReportServerVirtualDirectory element is missing. " When I enter <ReportServerUrl>http://localhost/reports</ReportServerUrl> I get an error that "The report server requires that the computer name be specified instead. " ( but this is the way that I am browsing to the website ) - so if I do enter the name of the machine(http://devsql/reports I get prompted to give username and password credentials when I try to browse to the reports. Other than allowing anonymous access I am not sure how to get any further.Other than that this is what the rest of the rewebapplication.config file looks like.<Configuration> <UI> <ReportServerUrl>http://localhost/reports</ReportServerUrl> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel> </UI> <Extensions> <DeliveryUI> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider"> <DefaultDeliveryExtension>True</DefaultDeliveryExtension> <Configuration> <RSEmailDPConfiguration> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension> </RSEmailDPConfiguration> </Configuration> </Extension> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/> </DeliveryUI> </Extensions> <Add Key="MaxActiveReqForOneUser" Value="20"/> <Add Key="DisplayErrorLink" Value="true"/></Configuration>Really appreciate your help.ThanksSteve
January 21st, 2008 6:27pm

Hi there, 1. first, take the ReportServer information out of <ReportServerVirtualDirectory></ReportServerVirtualDirectory>. 2. second, I realize that you are using localhost to browse now, but you do (as explained in the KB article on the second link) need to use a fully-qualified name (not localhost) in the ReportServerUrl node. 3. Third, look at the name of the node in step #2 <s>. I know this is the Report *Manager* config file, but you don't put the URL for the report *Manager* in there. You put the URL for the report *Server* in there, so the report Manager can find it. So in your case that might be http://devsql/reportserver . 4. You should be able to browse to http://localhost/reports (or http://devsql/reports) if you do it this way. Yes, you may get prompted for credentials. Are you on Vista as an OS, by any chance? Then we're probably not done <sigh>, although your error should be gone. See http://support.microsoft.com/kb/934164for starters. >L<
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2008 7:10pm

Hi there, 1. first, take the ReportServer information out of <ReportServerVirtualDirectory></ReportServerVirtualDirectory>. 2. second, I realize that you are using localhost to browse now, but you do (as explained in the KB article on the second link) need to use a fully-qualified name (not localhost) in the ReportServerUrl node. 3. Third, look at the name of the node in step #2 <s>. I know this is the Report *Manager* config file, but you don't put the URL for the report *Manager* in there. You put the URL for the report *Server* in there, so the report Manager can find it. So in your case that might be http://devsql/reportserver . 4. You should be able to browse to http://localhost/reports (or http://devsql/reports) if you do it this way. Yes, you may get prompted for credentials. Are you on Vista as an OS, by any chance? Then we're probably not done <sigh>, although your error should be gone. See http://support.microsoft.com/kb/934164for starters. >L<
January 21st, 2008 7:10pm

Lisa,Here's what the config file looks like now: and even though I can navigate using http://localhost/reports I still get the "Value does not fall within the expected range" error when I click on a report<Configuration> <UI> <ReportServerUrl>http://devsql/reportserver</ReportServerUrl> <ReportServerVirtualDirectory></ReportServerVirtualDirectory> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel> </UI> <Extensions> <DeliveryUI> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider"> <DefaultDeliveryExtension>True</DefaultDeliveryExtension> <Configuration> <RSEmailDPConfiguration> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension> </RSEmailDPConfiguration> </Configuration> </Extension> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/> </DeliveryUI> </Extensions> <Add Key="MaxActiveReqForOneUser" Value="20"/> <Add Key="DisplayErrorLink" Value="true"/></Configuration>Thanks
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2008 7:47pm

Lisa,Here's what the config file looks like now: and even though I can navigate using http://localhost/reports I still get the "Value does not fall within the expected range" error when I click on a report<Configuration> <UI> <ReportServerUrl>http://devsql/reportserver</ReportServerUrl> <ReportServerVirtualDirectory></ReportServerVirtualDirectory> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel> </UI> <Extensions> <DeliveryUI> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider"> <DefaultDeliveryExtension>True</DefaultDeliveryExtension> <Configuration> <RSEmailDPConfiguration> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension> </RSEmailDPConfiguration> </Configuration> </Extension> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/> </DeliveryUI> </Extensions> <Add Key="MaxActiveReqForOneUser" Value="20"/> <Add Key="DisplayErrorLink" Value="true"/></Configuration>Thanks
January 21st, 2008 7:47pm

Lisa,forgot to mention - using MS Windows Server 2003 Service Pack 1.Thanks
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2008 7:49pm

Lisa,forgot to mention - using MS Windows Server 2003 Service Pack 1.Thanks
January 21st, 2008 7:49pm

Wait a minute. I'm terribly sorry. You get this error when you try to view any of the individual reports. NOT when you navigate. SIgh. I'm really sorry. If it happens when you try to view reports it may *still* be a configuration error but only if it happens with every report.But we're looking in the wrong place. So, acouple of questions: 1) Does this happen with all reports, even a very simple one ? 2) If it happens with all reports, are they all using the same datasource? If so, what can you tell me about the datasource? 3) Does it happen even with a report without any parameters defined? 4) Are you using Sharepoint (don't ask me what this has to do with it, except that this error seems to happen with Sharepoint a lot) Assuming the answers are yes-no-yes-no above, let's keep looking at your configuration: 5) Have you checked the Reporting Services Configuration tool -- does anything show "red" (it is okay if the web service one does, it is okay if you have not configured e-mail, and it is okay, usually for just viewing reports, if you haven't set the execution account)? 6) If everything looks okay there, I guess we could look in the report manager's security settings file (rsmgrpolicy.config) and, just in case, in the manager's web.config file. But the issuemight also be your reporitng services config file (rsreportserver.conifg, other directory) or its permissions setting or even its web.config. Just in case, what version of the .NET framework are the web apps set to run under? (check this in IIS) Are we having fun yet? >L<
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2008 7:37pm

Wait a minute. I'm terribly sorry. You get this error when you try to view any of the individual reports. NOT when you navigate. SIgh. I'm really sorry. If it happens when you try to view reports it may *still* be a configuration error but only if it happens with every report.But we're looking in the wrong place. So, acouple of questions: 1) Does this happen with all reports, even a very simple one ? 2) If it happens with all reports, are they all using the same datasource? If so, what can you tell me about the datasource? 3) Does it happen even with a report without any parameters defined? 4) Are you using Sharepoint (don't ask me what this has to do with it, except that this error seems to happen with Sharepoint a lot) Assuming the answers are yes-no-yes-no above, let's keep looking at your configuration: 5) Have you checked the Reporting Services Configuration tool -- does anything show "red" (it is okay if the web service one does, it is okay if you have not configured e-mail, and it is okay, usually for just viewing reports, if you haven't set the execution account)? 6) If everything looks okay there, I guess we could look in the report manager's security settings file (rsmgrpolicy.config) and, just in case, in the manager's web.config file. But the issuemight also be your reporitng services config file (rsreportserver.conifg, other directory) or its permissions setting or even its web.config. Just in case, what version of the .NET framework are the web apps set to run under? (check this in IIS) Are we having fun yet? >L<
January 22nd, 2008 7:37pm

No worries Lisa.Thanks for checking back.Ok so here we go. You are correct in your understanding - I can navigate - but when I drill down to any of the individual reports I get the error.1. Happens with a simple one.2. I used the datasource that came with the Reporting Services Samples as well as my own - but you should note that I can inside Bids see the Data coming back even preview the report by hitting the Preview tab. 3.Happens even without any parameters in query.4. Not using sharepoint.5. Everything in config tool is green.6. not sure what to check.7. Using 2.0 Framework.Additional Info: when inside Bids even though I can preview the data by hitting the preview tab, if hit ctrl F5 I get an error which is rsInternalError : File does not exist. When I check the log file I seenot sure if this is relevant)01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 358401/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0370586001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0003.mdmp01/22/08 10:50:09, ERROR , aspnet_wp.exe, Unable to open file trace.log, error 201/22/08 10:50:09, ACTION, aspnet_wp.exe, Watson Invoke: NoDefinitely having fun now.ThanksSteve
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2008 8:35pm

No worries Lisa.Thanks for checking back.Ok so here we go. You are correct in your understanding - I can navigate - but when I drill down to any of the individual reports I get the error.1. Happens with a simple one.2. I used the datasource that came with the Reporting Services Samples as well as my own - but you should note that I can inside Bids see the Data coming back even preview the report by hitting the Preview tab. 3.Happens even without any parameters in query.4. Not using sharepoint.5. Everything in config tool is green.6. not sure what to check.7. Using 2.0 Framework.Additional Info: when inside Bids even though I can preview the data by hitting the preview tab, if hit ctrl F5 I get an error which is rsInternalError : File does not exist. When I check the log file I seenot sure if this is relevant)01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 358401/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0370586001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000001/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used01/22/08 10:50:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0003.mdmp01/22/08 10:50:09, ERROR , aspnet_wp.exe, Unable to open file trace.log, error 201/22/08 10:50:09, ACTION, aspnet_wp.exe, Watson Invoke: NoDefinitely having fun now.ThanksSteve
January 22nd, 2008 8:35pm

Hi Steve, well even though it happens "without any parameters in the query" *something* looks like it has errors having to do with parameters <g>. BTW I didn't ask "does the query have parameters". I asked does the *report* have parameters (or I meant to). >>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0003.mdmp Do you see a matching C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0003.log file and if so what does it have in it? One thing I remember that can cause problems like this is if you have edited your web.config (in either server or manager apps) with a tool that puts a xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0" into the configuration node. Can you check for that and remove in both web.configs if found? You can post all your config files in a zip file to me if you want (my sig has my site in it, my site has my contact e-amil). >L<
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2008 10:01pm

Hi Steve, well even though it happens "without any parameters in the query" *something* looks like it has errors having to do with parameters <g>. BTW I didn't ask "does the query have parameters". I asked does the *report* have parameters (or I meant to). >>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0003.mdmp Do you see a matching C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0003.log file and if so what does it have in it? One thing I remember that can cause problems like this is if you have edited your web.config (in either server or manager apps) with a tool that puts a xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0" into the configuration node. Can you check for that and remove in both web.configs if found? You can post all your config files in a zip file to me if you want (my sig has my site in it, my site has my contact e-amil). >L<
January 22nd, 2008 10:01pm

Lisa,you are correct you didn't say query paramaters I just assumed - and your logic about something requiring parameters seems well founded.Thanks for the contact info.Steve
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2008 11:30pm

You're welcome. Unfortunately I haven't found anything that looks like a meaningful difference, yet. The only thing I've noticed is that I have an extra section in web.config(s), but I think that is just for IIS 7: <system.webServer><handlers><add name="Reserved.ReportViewerWebControl.axd_*" path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" preCondition="integratedMode,runtimeVersionv2.0" /><add name="Reserved.ReportServer_*" path="Reserved.ReportServer" verb="*" type="Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler, ReportingServicesWebServer" preCondition="integratedMode,runtimeVersionv2.0" /></handlers><validation validateIntegratedModeConfiguration="false" /></system.webServer> ... I literally diff'd our files... and didn't see anything beyond our logon creds, and DSNs, expected stuff like that. SO now it is down to IIS configuration ? Or I have to used Shared View with you and see what is going on <g>. Because this is driving me bananas and I am sure you feel worse! Look: without wasting more of either of our time... most of the time MS just says "de-install and re-install" when this stuff happens. You will see that "solution" referred to all over the forums. If they give up, I don't exactly know why I keep trying... >L<
January 23rd, 2008 5:46am

Lisa, Do you have any experience with integrating RS with WSS 3.0? I am receiving the same error when trying to configure with WSS 3.0 -- I recenetly completed the WSS 3.0 Report Services integration by following "Installation/Configuration Guide for SharePoint Integration Mode" (http://blogs.msdn.com/sharepoint/attachment/4194088.ashx) When I click on "Set server defaults" under Reporting Services (also part of step 20 in the guide) I receive the following error - "An internal error occurred on the report server. See the error log for more details. ---> An internal error occurred on the report server. See the error log for more details. ---> Value does not fall within the expected range." Error logs display: --- End of inner exception stack trace --- w3wp!library!6!02/01/2008-17:58:56:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= AllMemory, AllThreads, SendToWatson w3wp!library!6!02/01/2008-17:59:31:: Call to GetPermissionsAction(http://rhfsweb/salestraining/Reports/Product Pricing and Availability Sales.rdl). w3wp!library!6!02/01/2008-17:59:31:: Call to ListParentsAction(http://rhfsweb/salestraining/Reports/Product Pricing and Availability Sales.rdl). w3wp!library!6!02/01/2008-17:59:36:: Call to GetPermissionsAction(http://rhfsweb/salestraining). w3wp!library!6!02/01/2008-17:59:36:: Call to GetSystemPropertiesAction(). w3wp!library!6!02/01/2008-17:59:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.ArgumentException: Value does not fall within the expected range. at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemMetaDataAndContent(String path, UserContext userContext, Boolean returnContent, Guid& id, ISecurableObject& secObj, SharePointImpersonatedWeb& wrapper, Byte[]& content, String& mimeType) at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemType(String objectName, UserContext userContext, Guid& id, ISecurableObject& secObj, SharePointImpersonatedWeb& wrapper) at Microsoft.ReportingServices.SharePoint.Server.SharePointAuthorizationExtension.InternalCheckAccess(UserContext userContext, String itemPath, SPBasePermissions requiredRights) at Microsoft.ReportingServices.SharePoint.Server.SharePointAuthorizationExtension.CheckAccess(UserContext userContext, String path, CatalogOperation requiredOperation) at Microsoft.ReportingServices.SharePoint.Server.SharePointSecurity.CheckAccess(Byte[] secDesc, CatalogOperation catalogOperation, String catalogPath) at Microsoft.ReportingServices.Library.GetSystemPropertiesAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() --- End of inner exception stack trace --- I have been able to deploy reports to sharepoint (with errors) from VS 2005. Errors state after a report has been deployed it cannot be found. I discoverd that once a report is deployed, I had to update the datasource link to point to the datsource in WSS. Once I click on the report in document library - the same error: "An internal error occurred on the report server. See the error log for more details. ---> An internal error occurred on the report server. See the error log for more details. ---> Value does not fall within the expected range." I can view the reports when I browse on the report server -- example - http://rhfsdb:8080/reportserver1?http%3a%2f%2frhfsweb%2fsalestraining%2fReports%2fProduct+Pricing+and+Availability+Sales.rdl&rs:Command=Render The report renders fine. Any help will be greatly appreciated. Thank you, Chris
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2008 2:59am

Lisa, Do you have any experience with integrating RS with WSS 3.0? I am receiving the same error when trying to configure with WSS 3.0 -- I recenetly completed the WSS 3.0 Report Services integration by following "Installation/Configuration Guide for SharePoint Integration Mode" (http://blogs.msdn.com/sharepoint/attachment/4194088.ashx) When I click on "Set server defaults" under Reporting Services (also part of step 20 in the guide) I receive the following error - "An internal error occurred on the report server. See the error log for more details. ---> An internal error occurred on the report server. See the error log for more details. ---> Value does not fall within the expected range." Error logs display: --- End of inner exception stack trace --- w3wp!library!6!02/01/2008-17:58:56:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= AllMemory, AllThreads, SendToWatson w3wp!library!6!02/01/2008-17:59:31:: Call to GetPermissionsAction(http://rhfsweb/salestraining/Reports/Product Pricing and Availability Sales.rdl). w3wp!library!6!02/01/2008-17:59:31:: Call to ListParentsAction(http://rhfsweb/salestraining/Reports/Product Pricing and Availability Sales.rdl). w3wp!library!6!02/01/2008-17:59:36:: Call to GetPermissionsAction(http://rhfsweb/salestraining). w3wp!library!6!02/01/2008-17:59:36:: Call to GetSystemPropertiesAction(). w3wp!library!6!02/01/2008-17:59:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.ArgumentException: Value does not fall within the expected range. at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemMetaDataAndContent(String path, UserContext userContext, Boolean returnContent, Guid& id, ISecurableObject& secObj, SharePointImpersonatedWeb& wrapper, Byte[]& content, String& mimeType) at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemType(String objectName, UserContext userContext, Guid& id, ISecurableObject& secObj, SharePointImpersonatedWeb& wrapper) at Microsoft.ReportingServices.SharePoint.Server.SharePointAuthorizationExtension.InternalCheckAccess(UserContext userContext, String itemPath, SPBasePermissions requiredRights) at Microsoft.ReportingServices.SharePoint.Server.SharePointAuthorizationExtension.CheckAccess(UserContext userContext, String path, CatalogOperation requiredOperation) at Microsoft.ReportingServices.SharePoint.Server.SharePointSecurity.CheckAccess(Byte[] secDesc, CatalogOperation catalogOperation, String catalogPath) at Microsoft.ReportingServices.Library.GetSystemPropertiesAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() --- End of inner exception stack trace --- I have been able to deploy reports to sharepoint (with errors) from VS 2005. Errors state after a report has been deployed it cannot be found. I discoverd that once a report is deployed, I had to update the datasource link to point to the datsource in WSS. Once I click on the report in document library - the same error: "An internal error occurred on the report server. See the error log for more details. ---> An internal error occurred on the report server. See the error log for more details. ---> Value does not fall within the expected range." I can view the reports when I browse on the report server -- example - http://rhfsdb:8080/reportserver1?http%3a%2f%2frhfsweb%2fsalestraining%2fReports%2fProduct+Pricing+and+Availability+Sales.rdl&rs:Command=Render The report renders fine. Any help will be greatly appreciated. Thank you, Chris
February 19th, 2008 2:59am

I'm having the exact same problem and it's killing me to resolve this. The only thing I can add is that I get the same error message whenyou gothe 'SurfaceArea Configuration for features' and then click windows integrated security. It will hang for awhile and then the SAC will give the same error message. I know there is a configuration problem with the reporting service but I can't identify the problem. I hope someonecanfigure outthis problem soon.
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2008 5:59am

I'm having the exact same problem and it's killing me to resolve this. The only thing I can add is that I get the same error message whenyou gothe 'SurfaceArea Configuration for features' and then click windows integrated security. It will hang for awhile and then the SAC will give the same error message. I know there is a configuration problem with the reporting service but I can't identify the problem. I hope someonecanfigure outthis problem soon.
February 19th, 2008 5:59am

>>Do you have any experience with integrating RS with WSS 3.0? Funny you should ask that. The answer is that I have been avoiding it like the plague but may be forced to do it soon. I am sorry that I can't help much with this except to observe that, on the SharePoint forums, a "value does not fall within the expected range" can be anything from a permissions/access thing to a page "referencing a page layout on another server", which might very well apply to a reporting services page being referenced from within SP. See http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2018857&SiteID=17 I will keep an eye open. >L<
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2008 7:54am

>>Do you have any experience with integrating RS with WSS 3.0? Funny you should ask that. The answer is that I have been avoiding it like the plague but may be forced to do it soon. I am sorry that I can't help much with this except to observe that, on the SharePoint forums, a "value does not fall within the expected range" can be anything from a permissions/access thing to a page "referencing a page layout on another server", which might very well apply to a reporting services page being referenced from within SP. See http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2018857&SiteID=17 I will keep an eye open. >L<
February 19th, 2008 7:54am

Dim rds As New Microsoft.Reporting.WebForms.ReportDataSource("SampleDataSource",myDataset.Tables(0)) Dim cmds As New CreeMESRPTDataSet() rds.Value = cmds <<--------Getting Exception rds.Name = "SampleReport_Datasource" Exception Details: Value does not fall within the expected range. Plz help me out.
Free Windows Admin Tool Kit Click here and download it now
December 31st, 2010 5:00am

Dim rds As New Microsoft.Reporting.WebForms.ReportDataSource("SampleDataSource",myDataset.Tables(0)) Dim cmds As New CreeMESRPTDataSet() rds.Value = cmds <<--------Getting Exception rds.Name = "SampleReport_Datasource" Exception Details: Value does not fall within the expected range. Plz help me out.
December 31st, 2010 5:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics