We are having problems with Reports that Access MSAS. After about
15-30 minutes the reports no longer work and we have to stop and
restart IIS and make one visit to the report manager page. We have to
continue to visit reports or the report manager page every 15 minutes
of we get rsProcessingAborted errors related to a MSAS data source
connection. The environment looks like the following:
Windows Server 2003 SP1
Reports Services SP2
SQL Server SP3
Analysis Services SP3
(everything is on the same box)
The Problem:
After about 30 minutes reports fail with the following error:
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'VIS_DATAMART'.
(rsErrorOpeningConnection) Get Online Help
The 'MSOLAP.2' provider is not registered on the local machine.
No error information available: REGDB_E_CLASSNOTREG(0x80040154).
We can prevent the above problem with the following hack:
Created an application that visits the report manager url every 15
minutes. So far near as we can tell, that approach prevents the
rsprocessingaborted error. We've also noticed that if our testers
continue to test without 15-30 minutes of in-active time, the site will
continue to work.
I'd like to eliminate this problem and the hack we are relying on. The
problem seems like it is related to caching. Anyone have any thought
or suggestions?Finally found a solution!
I had to create an additional application pool in IIS and move our custom
ASP.NET application to that pool and leave reporting services in the default
pool. After that change the problem went away.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment