CONSIDERATIONS/GUIDELINES:
- This Uninstallation Cleanup Utility is designed to remove the obsolete or leftover services, files and registries after uninstalling Strategy products.
- The goal of this cleanup utility is to remove the leftover files and registries after uninstallation to make the machine "cleaner" for a second time installation (it can solve some known downgrade installation issues).
- The basic assumption for removing files is that the user installed Strategy in a path that contains the string "Strategy". If not, the files and certain registry keys will not be removed.
- Using the cleanup utility incorrectly can cause system-wide problems that may require re-installation of the Operating System. This utility should always be tested in a test environment before being run in a production environment.
How to use this Tool
- Uninstall all the Strategy and related products from Control Panel:
- Any MSTR Hotfixes applied
- MSTR Secure Enterprise
- MSTR Health Center (if it's not uninstalled)
- MSTR Office (if installed)
- DHTML Editing Component (if installed)
- Restart the machine.
- Copy cleanup.exe to this machine.
- Right click and "Run as Administrator" to execute. (***)
When prompted "Do you want to import applyCleanup.reg to registry now? (y/n):"
- Enter "n", the registry entries won't be removed. Users can always review applyCleanup.reg later and manually apply it by double clicking on it
- Enter "y", the registry entries in applyCleanup.reg will be removed from system registry
*** The entire Strategy folders will be renamed as backup. If the user wants to delete the entire Strategy folders instead of renaming it, the user can run "cleanup.exe -f" in the Windows Command prompt.
If you do not receive the prompt, this means the tool did not execute. Re-Run the tool in Powershell (Admin) to get a detailed message as to why the tool could not populate the prompt.
5. Restart the machine after all is done.
What is done by cleanup.exe:
This will do the following things:
- Back up the entire registry to "reg_backup_<timestamp>.reg" file (this file will get created in the same folder where the executable resides)
- Stop and remove Strategy services (if they exist)
- Strategy Distribution Manager
- MAEMETLS
- Strategy Execution Engine
- Strategy Intelligence Server
- Strategy Logging Client
- Strategy Logging Consumer
- Strategy Logging Server
- MAPing
- EMService
- Strategy SMTP Service
- Strategy NC PDF Formatter
- SubscriptionAdministrator
- SubscriptionServer
- SubscriptionEngine
- SubscriptionLogger
- SubscriptionRMIRegistry
- Strategy System Monitor
- TransactorAdministrator
- TransactorCommunicationServer
- TransactorTransactionEngine
- TransactorLogger
- TransactorLookup
- MHealthAgent
- HealthAgent
- Tomcat8
- MySQL
- usherIDM
- usherGW
- Apache2.4
- memcached
- Stop Strategy related services
- RemoteRegistry
- Spooler
- W3SVC
- Generate a list of registries to be cleaned from the system "applyCleanup.reg" (this file will get created in the same folder where the cleanup executable resides)
- Rename the leftover folder C:\Program Files (x86)\Strategy to C:\Program Files (x86)\Strategy_<timestamp>
- Rename the leftover folder C:\Program Files (x86)\Common Files\Strategy to C:\Program Files (x86)\Common Files\Strategy_<timestamp>
- Prompt "Do you want to import applyCleanup.reg to registry now? (y/n):"
- Enter "y", the registry entries in applyCleanup.reg will be removed from system registry
- Enter "n", the registry entries won't be removed. Users can always review applyCleanup.reg later and manually apply it by double clicking on it
Usage in Windows Command Prompt
cleanup.exe [-h] [-f]
optional arguments:
1 Byte
WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUTF8MDUTF8UTF8WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUFT8MDUTF8UTF8Quarter_IDMonth_IDFact20061200601102006120060220200612006033020062200604402006220060550BIRDS OF A FEATHER
Join industry-specific leaders and product experts to discuss common goals, challenges, and success stories.
BRING YOUR OWN LAPTOP
Engage in hands-on workshops from the convenience of your own laptop.
INDUSTRY TRENDS
Gain a deeper understanding of the latest technologies and AI+BI trends, and why they matter.
CUSTOMER SUCCESS
Learn directly from industry experts as they share the art of the possible.
Strategy
Dive deep into the Strategy platform with our product experts to level-up your skills.
PARTNER
Hear our partners share how they can transform your business with the latest technologies.
ConstantObject TypeObject DescriptionDssTypeUnknown-1Type of object is not specifiedDssTypeReserved0Never used, and all functions should check that zero(0) never pass for a type.DssTypeFilter1A restriction on the data in the warehouse (Filters)DssTypeTemplate2The layout of a report (Templates)DssTypeReportDefinition3Describes a report that can be executed (Reports)DssTypeMetric4A formula to be evaluated at a specific dimensionality (Metrics)Unused5NoneDssTypeAutostyles6A custom or predefined formatted layout for a report (Autostyle)DssTypeAggMetric7A formula to be evaluated at any dimensionality (Base Formulas)DssTypeFolder8A collection of objects (Folders)Unused9NoneDssTypePrompt10A method to prompt the user for information (Prompts)DssTypeFunction11A function that can be used to build expressions (Functions)DssTypeAttribute12A natural grouping of data (Attributes)DssTypeFact13A value that can be read directly from the warehouse (Facts)DssTypeDimension14A grouping of related attributes (Hierarchies)DssTypeTable15A logical table (Logical Table)Unused16NoneDssTypeFactGroup17A collection of related facts (Fact groups)DssTypeShortcut18Contains a reference to another DSS Object (Shortcuts)DssTypeResolution19A collection of answers to prompts (Prompt answers)Unused20NoneDssTypeAttributeForm21Represents a value on elements of an attribute (Attribute forms)DssTypeSchema22Collection of objects that define the warehouse structure (Schema)DssTypeFindObject23(Deprecated) Describes a simple search (Search definition)DssTypeCatalog24List of (relevant) tables in a database (Catalogs)DssTypeCatalogDefn25Describes how to construct a catalog (Catalog definitions)DssTypeColumn26The properties needed to define a column of a DB table (Columns)DssTypePropertyGroup27Used to cache lists of property sets (Internal Object)DssTypePropertySet28Holds the definition of a property set (Properties)DssTypeDBRole29Represents a logical database (Database Instance)DssTypeDBLogin30Describes how to login to a database (Database Login)DssTypeDBConnection31Describes how to connect to a database (Database Connection)DssTypeProject32A environment in which to perform OLAP analysis (Projects)DssTypeServerDef33A description of a configuration of a DSS Server (Server Definitions)DssTypeUser34Represents a user or group of users of the system (Groups / Users)Unused35NoneDssTypeConfiguration36Top level object - represents a Castor installation (Castor Server Config.)DssTypeRequest37Describes a DSS Server request (Scheduled requests)Unused38NoneDssTypeSearch39Describes criteria that specify a search for objects (Searches)DssTypeSearchFolder40Folder-like object used to store result of a search (Search Folders)Unused41NoneDssTypeFunctionPackageDefinition42Describes a package of functions (Functions Definitions)DssTypeRole43Placeholder to describe way of extending an attribute (Transformations)DssTypeSecurityRole44Holds privileges of a user that plays a certain role (Security Roles)DssTypeInBox45Shortcut to a folder (Shortcuts to folders)DssTypeInBoxMsg46Describes an uncollected report on a DSS Server (DSS Server Reports)DssTypeConsolidation47Collection of consolidation elements (Consolidations)DssTypeConsolidationElement48Arithmetic expression over elements (Consolidation elements)DssTypeScheduleEvent49An event that can trigger a scheduled report (Scheduled events)DssTypeScheduleObject50Something that can be triggered (Scheduled objects)DssTypeScheduleTrigger51Binding between schedule event and object (Scheduled triggers)DssTypeLink52Holder of a property that spans objects (Links)DssTypeDBTable53A physical table in a database (Physical tables)DssTypeTableSource54Physical tables with same suffix and prefix (Same suffix and prefix tables)DssTypeDocumentDefinition55An document built from reports and HTML text (Report Services Documents)DssTypeDrillMap56Describes a set of possible drill paths (Drill Maps)DssTypeDBMS57Holds information about a type of physical database (DBMS definition)DssTypeMDSecurityFilter58Holds filter restrictions that can be applied to a user (Security Filters)DssTypePromptAnswer59Holds single prompt answer informationDssTypePromptAnswers60Holds multiple prompt answer informationDssTypeGraphStyle61Holds grapth style information for report templatesDssTypeChangeJournalSearch62Holds information about Change Journal search objectsDssTypeBlob63Holds information about Blob imagesDssTypeDashboardTemplate64Describes templates used in dashboardsDssTypeFlag65Used to flag certain objects. The flag itself doesn't store the relationship, which is stored in link item insteadDssTypeChangeJournal66Holds a list of Change Journal entriesDssTypeExternalShortcut67A shortcut object whose target is ExternalShortcutTarget (rather than regular object)DssTypeExternalShortcutTarget68A transient object which is used to refer to external resource like web server fileDssTypeReconciliation69Identifies equivilent objects in two environments. Mainly used for dataset replacement.DssTypeLayer70Holds a collection of tables and attributes with their position infoDssTypePalette71Holds a collection of colorsDssTypeThresholds72Standalone thresholds object which holds a collection of tranditional thresholds structuresDssTypePersonalView73Holds user's manipulation on RWD and dashboard. (Personal View)DssTypeFeatureFlag74Holds the on/off/default state of a feature SQL syntax:TABLE_NAME COLUMN_NAME VLDB place holder syntax: #0 #1-h, --help
| show this help message and exit
-f remove directories instead of renaming |
show this help message and exit
-f remove directories instead of renaming | show this help message and exit
-f remove directories instead of renaming |
Disclaimers and Limitation of Liabilities
Disclaimer:The utility application is provided "as is" and without warranty of any kind. Strategy Expressly disclaims all warranties, express, implied or statutory, including, without limitation, the implied warranties of merchantability, fitness for a particular purpose, satisfactory quality and non-infringement.
Limitation of Liability: Strategy shall have no liability to licensee for any damages of any kind, including, but not limited to, liability for direct, indirect, special, incidental or consequential, damages (which shall include, but not be limited to, loss of data or information, loss of revenue or anticipated profits or lost business).
KB307710 KB307710
