Reporting Services Report Definition Caching problem

[SemperFiDownUnda]

Hi all,
This is a repost from the Microsoft SQL Server: Setup and Administration forum but has recieved no responces.

thread962-955934

Hi all,
Sorry for posting here but to this point David is still deciding if there is a need for a dedicated forum for Reporting services. Since I believe this has to do with the administration of the SQL Server that Reporting Services is using I thought it might be most appropriate here.

I'm having an issue when modifying reports that everything works fine locally but when I deploy them to the reporting server everything reports ok on the deploy but the server still holds the old definition of the report. The only way I've been able to get the changes up is to change the name of the report and deploy it under that name. Not acceptible in my view. Currently if I make a series of 20 small changes and test them individually then I end up with 20 reports on the server, normally with the same name but the number 2 through 20 at the end.

Anyone know of a fix for this bug?

Thanks in advance.

Hope I've been helpful,
Wayne Francis

If you want to get the best response to a question, please check out FAQ222-2244 first

 

[SemperFiDownUnda]

This is not the issue. I found the actual issue. .NET Studio 2003, others may be affected, sometimes does not actually save report definitions to disk.

I tried this on a new installation of XP SP2 and the .NET environment.

This is what would happen.

I'd open a project and modify a report definition (ie could be as easy as adding 1 column.
I would preview the report and it would appear with the changes.
I save the project, and all reports definitions.
I would publish the project up to the server.
I would view the report from the server and it would be the old definition

What was happening is that saving the report was NOT saving it. There was no source control or any other read only attribute effecting the RDL. Save simply was not actually saving to disk. Publishing obviously uses the physical file on the disk which was not updated with the changes. I had to resort to hitting F7 to grab the RDL code and pasting it into notepad and saving it over the originial.

The bug is intermitant but seems to run in streaks for me.



Hope I've been helpful,
Wayne Francis

If you want to get the best response to a question, please check out FAQ222-2244 first