SQL, VB, MicroStrategy & Other Topics

"This machine is currently being used by delivery engine system as MicroStrategy logging server... can free this machine either by destroying it or removing the distribution manager ,execution engine and logging server references " After a brand new installation of MSTR 9.3.1, I was setting up Distribution Manager via Narrowcast Administrator. System wouldn't let me and I kept on receiving above error message. Fix: This fix involves changing registry. Please do so at your own risk. I always backup my registry prior to making any changes. Go to Start > Run > regedit and hit Enter. In the Registry Editor window, open Find and search for MicroStrategy Broadcast Server. Expand that and go to 7.0. Expand 7.0 and select Setup. Delete the SystemName, SystemGUID and UsedAs entries entirely (Select entry > right click > Delete). Hope this helps. UPDATE: This is logged in MSTR  TN6200-72X-0976 ( https://resource.microstrategy.com/support/Authori...

Came across an issue where after upgrading from MicroStrategy 7 to MicroStrategy 9.3, we were seeing extra spaces after attribute element values. We were able to verify this only because these elements were set as hyperlinks and therefore we saw extended underlines (screenshot below). An easy way to fix this is in MicroStrategy Web, go to Preferences > Project Defaults > General. Scroll down half way until you see Data Display property. Make sure the checkbox "Trim leading and trailing white space for warehouse element data" is selected. Now, having pointed you to this quick fix, I will say that I would still prefer to fix this in the underlying data. Why apply superficial patches when you can address the issue at the source!

Go to VLDB properties from Report > Data. Within VLDB properties window, go to Tools > Create VLDB Settings Report. Select 'Show Descriptions of Setting Values' and 'Do not show settings with default values' options. Resulting report is a list of all non-default VLDB properties.