Solved

Help MS Reporting Services: Value does not fall within the expected range" error

Posted on 2010-09-22
6
1,945 Views
Last Modified: 2012-05-10
Hi,

Background:
A customer's DBA rcently moved MS SQL Server 2005 DB files belong to our database from LUN to another last week. This customer has MS reporting services 2005 installed and a report server configured, that contain reports reporting on data from that database. The report server database is also on that DB server, which is local to that machine.

My problem.
Since our database files were moved, none of the reports work via the report server. I get the following error:

Value does not fall within the expected range" error

It is like the report server has lost it's connection with its database.

Points to observe:
1. MS SQL Server 2005 database is up and running fine.
2. The Report Server DB files were NOT moved, just the DB files belong to our database that the reports report from.
3. The reports execute fine within Visual Studio Development environment, but fail when deployed.
4. I tried re-deploying them again but they still fail with the same error.
5. All database, IIS and reporting services services are running. I tried re-starting them all and nothing changed.
6. Reporting Services Configuration reports that all is ok.

I have no idea what else to do. Can anyone help? All was working fine until our database files were moved to the new drive. Coincidence?

Many thanks,

Iain
0
Comment
Question by:mullykid
  • 3
  • 3
6 Comments
 
LVL 25

Expert Comment

by:slam69
ID: 33733646
Probably not, Have you tested the data source within the reports package?
0
 

Author Comment

by:mullykid
ID: 33734125
Yes. The datasource works fine. I redeployed that too.

Is there a config file or something that may need altering? I am finding it hard to undestand from the outset how this has effected the report server.
0
 
LVL 25

Assisted Solution

by:slam69
slam69 earned 200 total points
ID: 33734261
when you tried to redploy did you just try overwriting them? Also within BIDS do teh reports run ok in that environment is it just when they are running from teh report manager?

if this is teh case then delete the report first... keep refereshing until its deleted..... and then try redploying teh report... sometimes teh overwrite doesnt work in this case.

if that fails please can you advise if this is a sharepoint integrated solution or stand alone native SSRS
0
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 

Author Comment

by:mullykid
ID: 33734436
Hi,

No, I deleted first. I will try it again.

It is standalone.

Reports run fine within BIDS, when previewing!

One thing I should mention. The DPA moved the project folder, containing the reports etc., to the new drive too. I moved it back to the original drive path and it didn't make a difference.
0
 

Accepted Solution

by:
mullykid earned 0 total points
ID: 33735733
Solved. They had moved the dir Inetpub to another drive too. I brought it back, restarted the services and it worked. Thanks to all who helped.
0
 
LVL 25

Expert Comment

by:slam69
ID: 33735780
sry bud my sharepoint server has died at work so had to concentrate on that congrats on teh solve
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now