Re: msmdpump.dll calls lockup during cube processing

Tech-Archive recommends: Fix windows errors by optimizing your registry


""Charles Wang [MSFT]"" <changliw@xxxxxxxxxxxxxxxxxxxx> wrote in message news:rS1HVCspIHA.5740@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Kevin,
Your other post was monitored by Microsoft. However based on Microsoft MSDN
managed newsgroup support policy and the time difference, our initial
response is guareented within 24 hours. Appreciate your understanding on
this. You may also want to know some information of our MSDN Managed
Newsgroup Support services at here:
MSDN Managed Newsgroup Support Service Introduction
http://blogs.msdn.com/msdnts/archive/2006/11/08/msdn-service-introduction.as
px

Regarding the time hang issue, I need to collect more information from you
for further response:
1. How long can you finishing process your cube in Business Intelligence
Development Studio without using msmdpump.dll?

3 minutes

If there are huge data and many dimensions in your cube, a long time
processing is normally required.

2. Are there any error information in your event logs?

none


3. What is the result if you process a small cube like AdventureWorksDW?

same - as soon as i click the "OK" button to begin processing the window locks up indefinitely (24hrs +) until SSMS is forced quit.


4. Could you please run Process Monitor to monitor your SSMS process
(sqlwb.exe) and mail me (changliw_at_microsoft_dot_com) the trace log?
Since the log may be large, you may also mail me an email response, after
that I can create a workspace for your uploading the files. You can
download the process monitor from this link:
Process Monitor v1.32
http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx



I sent the trace file. When I attempt to process the cube through the msmdpump.dll there is nothing written I submit the process request via the msmdpump.dll. However when i process through the normal connection method (without using msmdpump) there is much written in the trace. I'll email that to you now.


This last time I ran the process via msmdpump.dll I used fiddler http debugging proxy to see what traffic is being sent. The last message sent from the SSMS client to the msmdpump.dll was :

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/";>
<Header>
<XA:Session soap:mustUnderstand="1" SessionId="5E311A2C-C3FF-41B7-9C34-935592E8F900" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:XA="urn:schemas-microsoft-com:xml-analysis" />
</Header>
<Body>
<Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
<Command>
<Subscribe xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"; />
</Command>
<Properties>
<PropertyList>
<Timeout>0</Timeout>
<SspropInitAppName>Microsoft SQL Server Management Studio</SspropInitAppName>
<LocaleIdentifier>1033</LocaleIdentifier>
<ClientProcessID>5340</ClientProcessID>
</PropertyList>
</Properties>
</Execute>
</Body>
</Envelope>

To which the msmdpump.dll never returns a response.

Thanks!
Kevin




Also I appreciate your understanding that since this issue is regarding
performance issue in a production environment, some advanced
troubleshooting skills such as debugging or dump analysis may be required
and need your contacting Microsoft Customer Support Services (CSS) for
effective assistance. We will try to assist you and provide some
suggestions here, however if they are not helpful, effectively and
immediately I recommend that you contact CSS via telephone so that a
dedicated Support Professional can assist you in a more efficient manner.
Please be advised that contacting phone support will be a charged call.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.


Please feel free to let me know if you have any other questions or concerns.


Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================




.

Quantcast