"The given key was not present in the dictionary"

I have a report that will not run in "preview" mode in VS 2005. Whereas the
deployed report runs correctly and shows results in about 15 seconds, the
same report (downloaded from the report server) tries to run in preview for
about 60 seconds and then displays "The given key was not present in the
dictionary".
Each of the 4 datasets (3 used for runtime parameter selections and one for
the report's data) run fine.
I've tried some of the other reports developed in SSRS and don't seem to
have this problem elsewhere. (I've not tried all my reports yet though.)
I've recently downloaded and installed .NET 3.0 and the variouls
add-ons/extensions for WCF, WPF and WWF and wonder if this is the root of the
problem.
I've seen some postings related to AJAX and this message but have not yet
downloaded AJAX.
Thanks for any help.
JonThis report had a relatively simple pic chart at the very bottom that
displayed summary data from the prime dataset. The error goes away if I
delete the chart.
(This is the only report I have that includes a chart.)
So, having isolated the problem a little, anyone have an idea what was
happening? This report has been in place for almost 2 years now.
Jon|||why hasn't this been answered. I have the same problem with a chart
From http://www.developmentnow.com/g/115_2007_3_0_0_950996/The-given-key-was-not-present-in-the-dictionary.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||On Aug 20, 11:26 am, Jonathon<nos...@.developmentnow.com> wrote:
> why hasn't this been answered. I have the same problem with a chart.
> Fromhttp://www.developmentnow.com/g/115_2007_3_0_0_950996/The-given-key-w...
> Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com
This link might be helpful.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=528044&SiteID=1
Regards,
Enrique Martinez
Sr. Software Consultant|||Has anyone found anything other than deleting the rdl.data? I copied a report.rdl and pulled it into the same solution so I could try working some objects slightly differently. But now when I try to run the modified report I am getting this message. It seems to be related to the document map and bookmarks, but I can't see anything wrong with them. I've refreshed all the fields on the datasets, I've deleted the rdl.data, but still getting the same error ...
From http://www.developmentnow.com/g/115_2007_3_0_0_950996/The-given-key-was-not-present-in-the-dictionary.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

"Next Page" is extremely slow - like it's requerying

I have a report with a single dataset, 3-levels of table grouping, and
returns 5 pages. When I preview the report in VStudio, it returns the 5
pages and I can navigate the pages real quickly. The problem is, when I run
it online via the RS front-end and click "Next Page," it takes a good 30
seconds to load the subsequent page or pages. The query itself runs in about
45 seconds, but why is the paging not near instantaneous?
Thanks,
jI hope you must have asked some questions yourself like
1. Is this report is slow or all the reports are slow?
2. Is your dev environment and production is different then how fast is your
production machine, is the machine slow (database server)?
3. Is Cache enabled/disabled ?
4. Are you doing the dev and online chking on the same machine ?
Probabily you can go to configuration from RS manager screen and check for
the cache options.
Amarnath
"Jordan" wrote:
> I have a report with a single dataset, 3-levels of table grouping, and
> returns 5 pages. When I preview the report in VStudio, it returns the 5
> pages and I can navigate the pages real quickly. The problem is, when I run
> it online via the RS front-end and click "Next Page," it takes a good 30
> seconds to load the subsequent page or pages. The query itself runs in about
> 45 seconds, but why is the paging not near instantaneous?
> Thanks,
> j
>
>|||Absolutely.
1. This report is slow. All the other reports paginate just fine, even those
that use the same datasources.
2. It's a production machine.
3. It's not caching a temporary copy, but neither is any of the other
reports. I set the caching (every 10 minutes) and it's 99% faster, but I
still don't understand. The report shouldn't refresh itself on every page,
only every time it is run.
4. Yes. Would this really matter?
Thanks,
j
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:DC42BC35-CD2A-42EB-BADA-E7FA77FCCA5F@.microsoft.com...
>I hope you must have asked some questions yourself like
> 1. Is this report is slow or all the reports are slow?
> 2. Is your dev environment and production is different then how fast is
> your
> production machine, is the machine slow (database server)?
> 3. Is Cache enabled/disabled ?
> 4. Are you doing the dev and online chking on the same machine ?
> Probabily you can go to configuration from RS manager screen and check for
> the cache options.
> Amarnath
> "Jordan" wrote:
>> I have a report with a single dataset, 3-levels of table grouping, and
>> returns 5 pages. When I preview the report in VStudio, it returns the 5
>> pages and I can navigate the pages real quickly. The problem is, when I
>> run
>> it online via the RS front-end and click "Next Page," it takes a good 30
>> seconds to load the subsequent page or pages. The query itself runs in
>> about
>> 45 seconds, but why is the paging not near instantaneous?
>> Thanks,
>> j
>>|||Absolutely.
1. This report is slow. All the other reports paginate just fine, even those
that use the same datasources.
2. It's a production machine.
3. It's not caching a temporary copy, but neither is any of the other
reports. I set the caching (every 10 minutes) and it's 99% faster, but I
still don't understand. The report shouldn't refresh itself on every page,
only every time it is run.
4. Yes. Would this really matter?
Thanks,
j

"Index was out of range" error on a very simple report with one ma

Hello,
I have a very simple report with one matrix setup on a landscape page
orientation. Margins are properly setup. I cannot get this to preview in
Report Designer. What is the solution for this?
Thanks,
SamA couple of questions:
* Do you have Reporting Services SP1 installed?
* Can you post to the newsgroup or send me an RDL that reproduces the
problem?
Ideally the report should work against a sample database (Northwind,
Pubs, or AdventureWorks).
* If you have SP1 installed could you delete the rdl.Data file for this
report and then preview the report?
The rdl.Data files are created in the report project directory.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:A4F98E05-A7FB-4BAC-81C4-E76685047B10@.microsoft.com...
> Hello,
> I have a very simple report with one matrix setup on a landscape page
> orientation. Margins are properly setup. I cannot get this to preview in
> Report Designer. What is the solution for this?
> Thanks,
> Sam|||* Yes.
* I have recreated the report. It works fine now.
Thanks,
Sam
"Bruce Johnson [MSFT]" wrote:
> A couple of questions:
> * Do you have Reporting Services SP1 installed?
> * Can you post to the newsgroup or send me an RDL that reproduces the
> problem?
> Ideally the report should work against a sample database (Northwind,
> Pubs, or AdventureWorks).
> * If you have SP1 installed could you delete the rdl.Data file for this
> report and then preview the report?
> The rdl.Data files are created in the report project directory.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sam" <Sam@.discussions.microsoft.com> wrote in message
> news:A4F98E05-A7FB-4BAC-81C4-E76685047B10@.microsoft.com...
> > Hello,
> >
> > I have a very simple report with one matrix setup on a landscape page
> > orientation. Margins are properly setup. I cannot get this to preview in
> > Report Designer. What is the solution for this?
> >
> > Thanks,
> > Sam
>
>