I've got an ODD problem and I'm looking for some ideas as to where to
look next for a solution.

I have a dot net app that queries a cube using adomd.net. I use 3 basic
queries depending on what the user selects on the web page. 2 of the 3
queries work fine, the 3rd crashes the olap service and puts the
following error in the event log:

"The MSSQLServerOLAPService service terminated unexpectedly. It has
done this 1 time(s). The following corrective action will be taken in 0
milliseconds: No action. "

Now here's the kicker. This query runs fine against the server if I run
the app on my local development machine or if I run it from the analysis
server directly. What that tells me is that there is a configuration
issue on the web server causing the query to crash the serivce. What I
can't figure out is how one particular query can cause the crash while
other queries run fine. I've patched the web server with everything I
could think of and all my other apps that access cubes run perfectly
with no problems. Again, it is only ONE query that is causing this crash.

Here is the query:
SELECT
{[Month_National].[All Month_National].[2005].Children,
Ytd([Month_National].[All Month_National].[2005]) } ON COLUMNS,
non empty TOPCOUNT(descendants([Customers_ByID],
[Customers_ByID].[Customer ID], SELF_AND_BEFORE), 21,
([Month_National].[All Month_National].[2005],
measures.[Temp_And_Perm]))
DIMENSION PROPERTIES
[Customers_ByID].[Customer ID].[Customer Name]
ON ROWS
FROM [My Cube]
WHERE ([Company_National].[All Company_National].[CompanyName],
MEASURES.[Temp_And_Perm], [Country].[All Country].[USA])

One other bit of information, this query has worked on this server in
the past, however, the server crashed a while back and had to be
rebuilt. I can trace this failure starting back to when the server was
rebuilt, which again leads me to believe that something on the web
server is simply out of date, but, I've updated everything I could think of.

Any help or things to investigate would be much appreciated! Thanks.

Zach

Guess I should have provided some specs:

Web server:
Windows 2000 (all service packs/patches)
MDAC 2.8 RTM
ADOMD.net V8.0
MSXML 4.0
dot net framework 1.1

Analysis Server:
Windows 2000 (all service packs/patches)
SQL Server 2000 SP3
Analysis Services SP3
dot net framework 1.1


Zach

Every time query crashes a server - it is a server bug and not configuration
issue. If you have SP3 - you can collect minidump of the crash and pass it
to PSS for analysis.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Zach Wells" <zwells (AT) ain_removethis (DOT) com> wrote