Hi all,

For some time now we have had a problem where data on our Analysis Services
2000 server appears to disappear. For example, a query such as:

select
{ [time].[rolling].[current year].children } on axis(0),
{ [salesreps].[all salesreps].children } on axis(1)
from [sales]
where ([products].&[12345], [measures].[quantity])

would return nulls for certain salesreps where previously there had been
totals. In a few circumstances, when the same query executed under different
sessions (eg Reporting Services and the MDX Query Analyser), one would
return correct data while the other did not.

It appears that once the problem occurs, data will appear to be "missing"
for new connections but previously connected sessions will continue to show
correct data. It does not make any difference which client is used- the same
symptoms appear in MDX Query Analyser, Analysis Manager or our own client
application.

The problem always goes away after a restart of MSSQLServerOLAPService. That
and the fact that previously connected sessions continue to show correct
data makes me wonder whether the problem is related to caching. After a
restart, everything is fine for a week or so until the problem recurs. I am
not able to reproduce the problem, and the event log does not show anything
unusual. We have SQL Server 2000 SP3a, with the repository on Sql, and
Windows 2003 Server for SBS.

Before I log an incident with Microsoft, does anybody have any suggestions
to make to help track down the fault? Has anybody struck this problem
before?

Thanks,

Peter