MicroStrategy ONE
1. Upgrade Preparation
Before you begin the upgrade to MicroStrategy ONE take care of the following items:
- Log in as
root
user. -
Backup the current configuration files for Intelligence Server, Web, Mobile, Library, and Collaboration.
List of Files:Intelligence Server
MSIReg
filesodbcinst.ini
odbc.ini
MicroStrategy Library
../webapps/MicroStrategyLibrary/images/
../webapps/MicroStrategyLibrary/plugins/
../webapps/MicroStrategyLibrary/WEB-INF/classes/auth/
../webapps/MicroStrategyLibrary/WEB-INF/classes/config/configOverride.properties
../webapps/MicroStrategyLibrary/WEB-INF/classes/logback.xml
- Any other customizations including SSL configurations
MicroStrategy Collaboration
When upgrading the Collaboration Server, the MicroStrategy Installer preserves the config.json file for the service; however, it does not back up the notification config.json file. If you have modified any notification properties, you need to backup the following and restore it once the upgrade is complete:
Backup Collaboration Server NotificationsWhen upgrading the Collaboration Server, the MicroStrategy Installer preserves the config.json file for the service; however, it does not back up the notification config.json file. If you have modified any notification properties, you need to backup the following and restore it once the upgrade is complete:
Back up the Collaboration Server notification files in the following directory:
Copy<INSTALL_PATH>\MicroStrategy\Collaboration Server\node_modules\mstr-collab-svc\pluginConfig\dossier
List of files:
- config.json
- email-Invite.template
- email-Mention.template
Backup Collaboration Store
The Collaboration Server utilizes MongoDB as its repository database. MongoDB has a built-in command for database backup, transfer, and restoration.
MicroStrategy recommends that the MongoDB database be backed up on a regular basis.
Gather the following information from the
dburl
field in theconfig.json
file from each server:- Username
- Password
- Collaboration database name
- Admin database name
- Stop the Collaboration Server and the MongoDB service.
-
Execute the following command from the destination server:
mongodump --host <source_server_name> --db <source_db_name> --username <source_username> --password <source_password> --authenticationDatabase admin --excludeCollection sessions --archive | mongorestore --username <target_username> --password<target_password> --authenticationDatabase admin --drop --archive
- Restart the Collaboration Service and the MongoDB service.
- Send an email to your users to inform that Intelligence Server and Web Server will be down during the upgrade process.
- Halt any monitoring alerts in case false alarm triggered during upgrades.
- Check the MicroStrategy Web Administration page and delete any defined Trust Relationships.
- Restart all services for the machines to be upgraded.
- Execute
service mstr stop
to stop Tomcat, MicroStrategy Listener, and Intelligence Server. -
Unmount all current mounts to any MicroStrategy deployment.
Unmounting is necessary to prevent the installer from attempting to remove other items in the mounted locations such as the image shares.
-
To view the related mounts and locations, run:
mount | grep MicroStrategy
-
To unmount each folder, run
umount /<path>/<to>/<folder>
. For example:umount /opt/mstr/MicroStrategy/install/images
-
-
Stop puppet if the service is running.
Use the following commands:
- Stop puppet:
service puppet stop
- Get process id for any additional puppet processes:
ps -ef | grep puppet
- Kill any remaining processes:
kill -9 <processID>
- Stop puppet:
-
Remove MicroStrategy directory and .war files from tomcat webapps and work folders.
cd /opt/apache/tomcat/latest/webapps/
rm -rf MicroStrategy*
cd /opt/apache/tomcat/latest/work/Catalina/localhost
rm -rf MicroStrategy*
- Use
df -h
to check that at least 5GB of disk space is available under/opt/mstr