microsoft newsgroup web access
     dot net    |    ms sql    |    ms access    |    office    |    windows    |   
Microsoft ms sql group
sqlserver.ce
sqlserver.clients
sqlserver.clustering
sqlserver.connect
sqlserver.datawarehouse
sqlserver.dts
sqlserver.fulltext
sqlserver.msde
sqlserver.mseq
sqlserver.notificationsvcs
sqlserver.odbc
sqlserver.olap
sqlserver.programming
sqlserver.replication
sqlserver.reportingsvcs
sqlserver.security
sqlserver.server
sqlserver.setup
sqlserver.tools
sqlserver.xml
  
    

Query crashes olap services



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

Fri, 14 Jan 2005 11:51:18 -0600 Zach Wells

Re: Query crashes olap services



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

Fri, 14 Jan 2005 11:55:03 -0600 Zach Wells


COPYRIGHT © 2004, EUROFRONT WORLDWIDE LTD., ALL RIGHT RESERVE
http://www.meetholland.com

advertisement:   complete list of microsoft newsgroup    |    uk based newsgroup    |