Hi,

I am experiencing this fatal error on an AS 2000 SP3 or SP3a.
This AS is installed on an Windows 2000 prof. SP3 & with windows
update on.
All software in english.

I am not doing something special, just normal MDX queries (see example
below).
During the test, this kind of MDX query is sent many times (25-30) to
the AS, as we are splicing the reports by geography rolling the where
slice clause.
I performed the test with the same cube and the same MDX sentences.
I only loaded one cube on the AS, just to isolate the problem.

I uninstall AS 2000, re install it upto SP2, all works fine, but when
updated to SP3 or SP3a I got the fatal error.

I tried the same procedures on a Windows XP Prof. SP1 and all works
fine with AS 2000 sp2 and AS 2000 sp3.

I am very disoriented.
Any help? I don't like to move all our AS 2000 servers to SP2!
I have the dump files generated by AS 2000, where could I send it?

Thanks in advance,
Alberto Plottier
Application Architect
IMS Health
Leandro N Alem 1050 - 7th Floor
Buenos Aires (1001AAS) - Argentina
voice: 54 11 4516 0453 fax: 54 11 4516 0456
email: <mailto:aplottier (AT) ar (DOT) imshealth.com>
www.imshealth.com


Sample:

DROP MEMBER
[NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[Product].[All
Product].[#GROUP#Product#IMS1#&@SOLUGEL]

DROP SET
[NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[#G SET1#Product#IMS1#&@SOLUGEL],
[NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[#G SET2#Product#IMS1#&@SOLUGEL],
[NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].IMS1SLICE1,
[NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].IMS1SLICE2,
[NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].IMS1SLICE3,
[NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].IMS1SLICE4,
[NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].IMS1SLICE5


DROP SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1ATCs]
DROP SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1Geography]
DROP SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1Market]
DROP SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1Monodrug]
DROP SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1Period]
DROP SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1Product]
DROP SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1MEASURES]


CREATE
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[#G
SET1#Product#IMS1#&@SOLUGEL] AS '{[Product].[All Product].[TOTAL
REPORT 10].[10004#&@004 - PEROX].[SOLUGEL (STF)10004#&@SOLUGEL (STF)],
[Product].[All Product].[TOTAL REPORT 10].[10004#&@004 -
PEROX].[SOLUGEL PLUS (STF)10004#&@SOLUGEL PLUS (STF)]}'
MEMBER [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[Product].[All
Product].[#GROUP#Product#IMS1#&@SOLUGEL] AS 'SUM({[Product].[All
Product].[TOTAL REPORT 10].[10004#&@004 - PEROX].[SOLUGEL
(STF)10004#&@SOLUGEL (STF)], [Product].[All Product].[TOTAL REPORT
10].[10004#&@004 - PEROX].[SOLUGEL PLUS (STF)10004#&@SOLUGEL PLUS
(STF)]} )', SOLVE_ORDER=0
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[#G
SET2#Product#IMS1#&@SOLUGEL] AS '{[#GROUP#Product#IMS1#&@SOLUGEL]}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1ATCs] AS '{{[ATCs].[All
ATCs].[ARG (ATCs)]}}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1Geography] AS
'{{[Geography].[All Geography].[ARG],[Geography].[All
Geography].[ARG].[1 - RAMON ESQUIVEL].[11 - RAMON ESQUIVEL].[1121 -
20-21-001],[Geography].[All Geography].[ARG].[2 - GOMEZ MARIANI].[21 -
GOMEZ MARIANI].[2113 - 10-07-001],[Geography].[All Geography].[ARG].[2
- GOMEZ MARIANI].[21 - GOMEZ MARIANI].[2116 -
10-20-001],[Geography].[All Geography].[ARG].[2 - GOMEZ MARIANI].[21 -
GOMEZ MARIANI].[2117 - 10-20-002]}}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1Market] AS
'{{[Market].[All Market].[ARG (Mkt.)]}}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1Monodrug] AS
'{{[Monodrug].[All Monodrug].[ARG (MONODRUG)]}}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1Period] AS
'{{[Period].[All Period].[2003].[2003, QTR 3].[2003 September]}}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1Product] AS '{{[#G
SET2#Product#IMS1#&@SOLUGEL]}}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].[IMS1MEASURES] AS
'{{[Measures].[Units]}}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].IMS1SLICE1 AS
'{[IMS1Geography]}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].IMS1SLICE2 AS
'{[IMS1MEASURES]}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].IMS1SLICE3 AS '{[IMS1ATCs]}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].IMS1SLICE4 AS
'{[IMS1Market]}'
SET [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997].IMS1SLICE5 AS
'{[IMS1Monodrug]}'



SELECT [IMS1SLICE1] ON 0 FROM [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997]
SELECT [IMS1SLICE2] ON 0 FROM [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997]
SELECT [IMS1SLICE3] ON 0 FROM [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997]
SELECT [IMS1SLICE4] ON 0 FROM [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997]
SELECT [IMS1SLICE5] ON 0 FROM [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997]


WITH
SET [IMS1ROWS] AS '{FILTER([IMS1Product], NOT
ISEMPTY(SUM([IMS1COLS])))}'
SET [IMS1COLS] AS '{[IMS1Period]}'
SELECT
[IMS1ROWS] PROPERTIES MEMBER_TYPE ON 1,
NON EMPTY [IMS1COLS] PROPERTIES MEMBER_TYPE ON 0

FROM [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997]

WHERE
([IMS1SLICE1].ITEM(0).ITEM(0),
[IMS1SLICE2].ITEM(0).ITEM(0),
[IMS1SLICE3].ITEM(0).ITEM(0),
[IMS1SLICE4].ITEM(0).ITEM(0),
[IMS1SLICE5].ITEM(0).ITEM(0))

CELL PROPERTIES VALUE, FORMATTED_VALUE, FORE_COLOR, BACK_COLOR,
FORMAT_STRING



WITH
MEMBER MEASURES.[~#~Calc~1] As 'Count({ [ATCs].[All ATCs].[ARG
(ATCs)]})'
MEMBER MEASURES.[~#~Calc~2] As 'Count({ [Geography].[All
Geography].[ARG],[Geography].[All Geography].[ARG].[1 - RAMON
ESQUIVEL].[11 - RAMON ESQUIVEL].[1121 - 20-21-001],[Geography].[All
Geography].[ARG].[2 - GOMEZ MARIANI].[21 - GOMEZ MARIANI].[2113 -
10-07-001],[Geography].[All Geography].[ARG].[2 - GOMEZ MARIANI].[21 -
GOMEZ MARIANI].[2116 - 10-20-001],[Geography].[All Geography].[ARG].[2
- GOMEZ MARIANI].[21 - GOMEZ MARIANI].[2117 - 10-20-002]})'
MEMBER MEASURES.[~#~Calc~3] As 'Count({ [Market].[All Market].[ARG
(Mkt.)]})'
MEMBER MEASURES.[~#~Calc~4] As 'Count({ [Monodrug].[All Monodrug].[ARG
(MONODRUG)]})'
MEMBER MEASURES.[~#~Calc~5] As 'Count({ [Period].[All
Period].[2003].[2003, QTR 3].[2003 September]})'
MEMBER MEASURES.[~#~Calc~6] As 'Count({ [Product].[All
Product].[#GROUP#Product#IMS1#&@SOLUGEL], [#G
SET2#Product#IMS1#&@SOLUGEL]})'
MEMBER MEASURES.[~#~Calc~7] As 'Count({ [Measures].[Units]})'

SELECT
{[~#~Calc~1], [~#~Calc~2], [~#~Calc~3], [~#~Calc~4], [~#~Calc~5],
[~#~Calc~6], [~#~Calc~7]} ON 0,
{[ATCs].Members.Item(0) } ON 1
FROM [NEWDDD_ARG_997_A__YYYYMMDD_ARG_997]

Hi Alberto,

Thanks for your post. Based on my research, it seems that your Analysis
Services (AS) is installed on Windows 2000 professional. Are you sure the
operation system AS installed is windows 2000 professional? If so, because
Microsoft? SQL Server 2000? Analysis Services need to be installed on
Microsoft Windows? 2000 Server or Microsoft Windows NT? Server 4.0 with
Service Pack 5 or later. I am unable to guarantee there are not any
problems with AS 20000 when you updated it to Sp3 or Sp3a.

Also, looking at the nature of this issue, I would highly recommend you
contact Microsoft Product Support Services since it would require intensive
troubleshooting which would be done quickly and effectively with direct
assistance from a Microsoft Support Professional. You may want to use one
of the Support Incidents which comes with MSDN Subscription.

Microsoft support home page: http://support.microsoft.com.
To view support options:
http://support.microsoft.com/default...d=sz;en-us;top.
To submit an online request:
http://support.microsoft.com/default...incidentsubmit.

Thanks for using MSDN newsgroup.

Thanks & Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Thanks for your reply.
I did a mistake. Our AS 2000 server are installed on Windows 2000 Server.

Regards,
Alberto

v-yshao (AT) online (DOT) microsoft.com (Michael Shao [MSFT]) wrote in message news:<FAIEsCFpDHA.2624 (AT) cpmsftngxa06 (DOT) phx.gbl>...

Hello Alberto,

In addition to contacting Microsoft PSS directly, as mentioned by Michael,
if this is not an urgent issue and you would like us to create an incident
for you and have Microsoft Customer Service Representative contact you
directly, please send email to (remove "online." from this no Spam email
address) mailto:dscommhf (AT) online (DOT) microsoft.com with the following
information,


*Include "Followup: IssueID 19774090" in the email Subject.
*Location of the post
*First Name, Last Name
*MSDN Subscriber ID
*Company name (if any)
*Phone number
*e-mail address

Thanks for using Microsoft MSDN Managed Newsgroup.

Vikrant Dalwale

Microsoft SQL Server Support Professional


Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer’s security."
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
e.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnew s1.google.com!no
t-for-mail