Monday, March 26, 2012

Report definitions - changes not apparent after upload/deploy.

We have SQL 2000 Reporting Services. There are a couple of reports that have been changed several times in the past, with no problems.

Now when we change these same reports, the new report definitions get successfully uploaded (as evidenced by the time stamp), but the old report definitions still show up.

We have tried the following.

1) Deleting the report from Reporting Services.

2) Recreating the report from scratch, then uploading the new report (w/ same name)

3) Uploading the desired report with a different name, then changing it to the desired name. (We have links and legacy applications that point to these reports). When we do this, the old version reappears.

This appears to be a caching problem. I have verified the caching option in the Properties > Data Execution [tab] is not selected. I have tried bouncing the SQL database, IIS services, and Reporting Services (let me know if there is a prescribed order).

Whatever we try, the old definitions remains persistently there.

Help!

Thanks in advance .

gmctech

Could this be client caching or proxy caching?

No comments:

Post a Comment