kranthi.kumar040 - Sunday, June 25, 2017 12:17 PMHello Pals,SQL server analysis service (services) getting stopped once partitions are processed with PROCESS FULL using XMLA script calling in "Analysis service DDL Task " in ETL package. After verifying Event Viewer log we observed that failure of msmdsrv.exe application is leading to services stop.
Would like to know possible reasons and fix for the service stop.Regards,
Kranthi
Hi Sue_H, bmg002
Thanks for your reply.. below are the answers to your questions.
1.Yes..Dump file was created SQLDmpr0054.mdmp and SQLDUMPER_ERRORLOG text file was also created.
2. We are using sql 2012 version
3. And have gone through msmdsrv text file under SSAS log folder. But i didn't get much information about crash report. Would like to know any keywords/how to read the log information to find the exact error.
I'm attaching the screenshots below for your reference.
