My company has a centralized Data Center complete with a set of Help Desk
Brain Surgeons. We have recently transitions 2 applications to the centralized Data Center.
I am currently having 2 issues with Analysis Services Hot Fix #909:
#1:
It appears that the client software on the servers do not have the same version installed as the MSAS Server and as a result a calculated member error is being encountered.
#2:
The MSAS has crashed(shutdown and restarted) 20+ times in the last 2 weeks. It appears that MSAS is not handling the incremental processing of the dimensions very well and we need to configure the server to allow for a full MSAS dump when the server crashes. Then send the dump file to MS.
So the Help Desk folks closed issue #2 related to #1. Then indicated that MSAS Hot Fix #909 was added on the server a few months ago and closed #1.
Both help desk tickets are closed and I still have production issues.
Now, I don't have the ability to reopen the tickets and since they are on another time zone, they have gone home for the day. Yikes???
Questions going through my mind:
Did the Help Desk Brain Surgeons think I created these Help Desk Tickets just because I felt like it?
Do they know what MSAS is? Or how to spell OLAP?
On paper, the Help Desk stats look pretty good, 2 tickets created, 2 closed. They are just churning out tickets.... Whoa!!!
Did they even take a look at the event log on the MSAS? Did they think I was dreaming this up???
Can anyone say "Calgone take me away"???