Monthly Archives: December 2006

TCPView for Windows – kill Analysis Services 2000 connections

One of the annoying things about AS2000 is that there is no KILL command like there is in SQL Server. Sometimes a cube or database will lock up and the only way to clear this is to restart the service. … Continue reading

Posted in Uncategorized | Leave a comment

Error: Process Partition Failed: 5 – MdxScript(TheCubeName) (8, 6) Parser: The syntax for ; is incorrect.

While processing a partition I kept receiving the following error when the transaction attempted to commit:   Process Partition Failed: 5 – MdxScript(TheCubeName) (8, 6) Parser: The syntax for ; is incorrect     This ended up being a syntax … Continue reading

Posted in Uncategorized | Leave a comment

Backing up AS2000 databases

I’ve seen several posts on the newsgroup lately asking how to back up an Analysys Services database. Microsoft provides a utility to do so (msmdarch), however this backs up to a .cab file, and if any of your data files are greater than … Continue reading

Posted in Uncategorized | Leave a comment

“Errors in the metadata manager” while running Aggregation Design Wizard

  While running the Agg Design Wizard I kept receiving the following error: "Errors in the metadata manager". It was driving me nuts. Finally I ended up doing a search for the error string and came across this fix: 1)     … Continue reading

Posted in Uncategorized | Leave a comment

HYT00 Error – Query Timeout Expired

  For the last day I’ve been attempting to process a measure group with 180 partitions in parallel. Every single time it would fail with the error: HYT00 – Query Timeout Expired. Most of the other measure groups had sucessfully … Continue reading

Posted in Uncategorized | 7 Comments

Followup: Parent Child Dimension Processing Time

I’ve received a response from the MS Support Engineer about the issue in processing PC dimensions (see earlier post: Parent Child Dimension Processing Time).     Here it is:   "Development has been looking at the issue wherein dimensions having … Continue reading

Posted in Uncategorized | 1 Comment

Installing Analysis Manager 2000 on a 64bit server

  Two years ago when we switched to a 64bit machine there was no way to run the Analysis Manager (or any other SQL Server client tools) on the actual server. After going through a recent support case I was … Continue reading

Posted in Uncategorized | Leave a comment