Alternative means for resolving the issue include using the root user to run the commands, or performing a re-install with the desired user account who should be. 40. csv file to keep a record of their settings, and import a previously saved file to apply settings to an environment. Windows from the command line, then perform the following steps: From the Windows Start menu, select Run. To install the MicroStrategy Library components, select the following features when prompted. Run the MicroStrategy installer by clicking the setup. Enter the Intelligence Server address (IP or FQDN): Enter the port that the Intelligence Server service is running on. However, after publishing,. The MicroStrategy Intelligence Server Universal on Linux operating systems can only be registered as a service by a user running with a root or privileged account. xml > <propertyname="timeout">. Unlike major releases and service packs, hotfixes and patches are differential updates of the product, meaning that only a few of the binaries are rebuilt and re-stamped with the hotfix or patch version. During startup the State will display as . You need to increase the ulimit parameters by running ulimit -n 65534. x/9. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. 2. old' or delete the file. The DUMMY_SERVER instance for example, helps for the configuration of the Intelligence. Right-click a project and choose Properties. browser cache etc is all cleared even tried with re-installing library server. Tables v10. Platform Analytics repository size may be observed increase rapidly with advanced statistics enabled. 11, 10. x from the Command Line, run the following command: $ mstrctl -s IntelligenceServer stop. If Custom Install is chosen, make sure "MicroStrategy Telemetry Server" is selected (it's auto selected when "MicroStrategy Intelligence" is selected). reg file (which is located in the Microstrategy home folder) "InstallName"="root@2015-10-21T10:09:23" needs to be changed to "InstallName"="root@" (in the HKEY_LOCAL. '. Select one: To create a new security filter, click New. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. Select “MicroStrategy SDK”. xml file and create a backup copy of it. Note: Make your configuration changes to the configuration files located under the admin folder. KB48030: Font change is not applied to the graph in MicroStrategy 9. Intelligence Server ensures the scalability and fault tolerance required for sophisticated analysis of terabyte databases and deployments to millions of users. Server Activation registers each Server Installation with MicroStrategy and locks the installation to a specific machine. All basic statistics. Verify that the token file physically exists on the machine running MicroStrategy Web Services and that the token file is named according to the Intelligence Server machine name (I-SERVER_MACHINE_NAME. yaml. This information can then help MicroStrategy Administrators monitor the health of their memory usage and determine when they should unload cubes, stop certain jobs, or adjust the memory limit setting. One of your most important jobs as a MicroStrategy system administrator is to find the balance that maximizes the use of your system's capacity to provide the best performance possible for the required number of users. You can calculate the factory output rate for one product using the values from the machine-hour capacity formula. The Web server will create a new TCP connection if it determines that only two connections are idle. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. This reduces the load on Integrity Manager and ensures that the recorded times are as accurate as possible. Create Response fileMicroStrategy Internal case number: 379474 -----Installation instructions-----This patch should be applied on top of MicroStrategy 9. 090) 1. MicroStrategy provides In-memory BI capabilities that leverage 64-bit operating systems to improve the overall performance of a BI system. To be able to connect to the Directory Server however, MicroStrategy Intelligence Server 9. The Servers page opens. Afterwards you will see Kafka log files created in the Kafka. sys-defaults. In practice, you get a cert for the server. Analyzes system performance over time using your choice of metrics. Similar to the MicroStrategy Web application, Library connects to your Intelligence Server and supports multiple different methods of. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. This can be done using the following command: chown -hR <new user account>:<user group> <Install folder>. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. This technique is useful till 80%. Platform Analytics is the new monitoring tool in MicroStrategy 11. war file to upgrade MicroStrategy Library. On the other hand, some other configuration files stay as part of the configuration process and are useful to run the applications. Retrieve Data from the Intelligence Server Using the JSON Data API. If False (default), this feature will be disabled. Specify a name and location for the new security filter and click Save. The maximum value is 99 and the minimum value is 1. This can be achieved via the report level VLDB property > SQL Time. 0. x-10. For example, when creating an initial session on WS1 using Standard authentication, a MicroStrategy session was created on Intelligence Server node 2 (I-SERVER_2). jks. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. type: Puppeteer exporter. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. exe. xml" must either be edited, renamed, or deleted. The DNS needs to recognize the entry as a machine and be able to resolve its. The following procedure describes how to ensure the web server, mobile server and intelligence server use images from the same folder in MicroStrategy 9. Port number of the server. The. Once connected to a node, the Web user runs all MicroStrategy activity on the same node. Run the file mstr-repo-ondemand-dba-operations. (Min 2) Maximum number of renderer processes. csv file to keep a record of their settings, or import a previously save file to apply the setting to a project. x level and not on the cluster level. You can implement iServer easily with it. Login information such as the user name, login ID, password, and password expiration date. This allows resources to be shared across the network. 1 and above on Windows and Linux operating systems. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. yaml. New Export Engine in MicroStrategy 2019 can deliver a high-quality PDF files with complete data, diversified widgets and various fonts, compared with the Legacy Engine in 10. Copy, paste, and execute the following XML script into the command line:Add the MicroStrategy Mobile Admin page URL with the full domain name to the list of Trusted Sites in Internet Explorer: Navigate to Tools > Internet Options > Security > Trusted Sites, like shown below: Click on the 'Sites' button. browser cache etc is all cleared even tried with re-installing library server. In MicroStrategy 11. Upload FilesOr drop files MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. xml" file contains the state information of the Intelligence Server. Theoretically, capacity is a certain. command is one of the commands from the list below. Stop MicroStrategy Intelligence Server in all cluster nodes. The below steps can be used to deploy the MicroStrategyLibrary. This is because registering MicroStrategy Intelligence Server Universal 9. Creating a User. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. exe application from the extracted zip file. /mstrcfgwiz. renderer. Using the command manager script file created in Step1, create a batch file that can be used to restart the MicroStrategy Intelligence Server. This Knowledge Base article addresses an identified defect where the Web Pool Size setting doesn’t do anything in MicroStrategy 10. The Intelligence Server on Windows, when started as a service, does not have a terminal to which it can write the output log data. xml' will be created and the MicroStrategy Intelligence Server Universal should start normally. Capacity Planning for Platform Analytics. A Processing Unit is a job-queuing and processing station with a collection of tasks, that a job will undergo after it is submitted to the MicroStrategy Intelligence Server. This example checks the preference WebPreferenceDpiConversion. To manually configure the MicroStrategy Repository, Platform Analytics, and the Collaboration Server database user, schema, and warehouse, use the steps below: Prerequisite : Ensure the mstr user, or any other non-root user used to register services, is a valid system user and able to log in. Connect. Only the database names listed in DBAdminConfig. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. The Microstrategy SQL Engine calculates the size based on two bytes per character as a standard to encompass Unicode and Double-Byte Character Set (DBCS) data. sp. When you create a new user, you need to provide some or all of the following information: Login information. 52K. The cache. max_map_count be defined as 5,242,880 bytes. Select the "exportMaxCellsPlainText" setting and modify the "Maximum" value under "Other. xml. Determining the necessary hardware requirements to support MicroStrategy is dependent on many factors including but not limited to the complexity of your MicroStrategy environment, the deployment strategy of MicroStrategy features, user community requirements, expected peak usage requirements, and response time expectations. jks file including the cert with a passphrase, e. Statistics logged. Database Instance. Select Configure Intelligence Server, and click Next. You can build real-time or near-real-time MicroStrategy applications based on it. In addition to the above setting, another major reason for a slow project load could be any additional traces or logs that have been turned on for. scpBACKGROUND: When configuring a MicroStrategy Intelligence Server cluster, special configuration must be made in order for the Intelligence Server cluster nodes to be able to access report and document caches, intelligent cubes, history list messages, and session recovery files that were created on other nodes of the cluster. Salary ranges can vary widely depending on many important factors, including education, certifications, additional skills,. In general, there are two situations in which license key updates are required: Additional named user licenses have been purchased or need to be removed. Configure Metadata Connection. x and 11. microstrategy. Place intelligence server close to the both the data warehouse and the metadata repository. 0. trusted. Excel API. Step 3. Increase the size of Maximum RAM for Working Set cache to a higher value. MicroStrategy Health Center Master Health Agent listens for incoming connections from Health Agents and the Health Center Console on TCP port 44440 by default. 1. The default Intelligence Server configuration settings, defined in the Intelligence Server Configuration Editor, are provided below. 4. System Performance Trends. The default value is 256 megabytes. You can use a linear or exponential extrapolation to plot how increase in user load will drive resource consumption. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. In a UNIX console window, browse to the "bin" folder under <HOME_PATH> where the MicroStrategy is installed. x when Intelligence Server is on Linux. Internet or Intranet specification will depend on your connection. If a name is not specified, the command uses the default instance name. in my company we are using Microstrategy 10. sp. All files under the conf folder are overwritten when you upgrade MicroStrategy. There will most likely be a direct correlation between user load and resource consumption. 0, the behavior has been changed and the Intelligence Server does not use Messaging Services by default. View the out-of-the-box Platform Analytics Project Dossier>Database Capacity Planning dossier, go to Overview This video shows how to change the user idle timeouts that affec MicroStrategy Web users. Follow the below steps to change your environment's Library URL. /mstrcfgwiz. 1 the following memory setting must be altered in the Windows Registry ( since the default setting, is not enough to some of the MSTR functions) Set the value of HeapMaxSize under the following path to at least 2048M. x ODBC calls by default. In the left pane, click All Settings. iserver. This feature. - pull data out of it. Remember to replace all child object permissions. MicroStrategy Telemetry Manager: This layer is the synchronization service between Telemetry Server(s),which is using Apache Zookeeper. Enter this value in the Server busy timeout field. The book starts by detailing the different. Click the icon next to a listed service. Choose Add Data > New Data. Property Default Value Comments; exporter. After changing the ACU settings for the cluster. You can implement iServer easily with it. This article narrates tips to retain PA repository at a. The license check takes place anytime within the next half hour of the time specified in the setting. The requests are granted or denied according to user-configured limits on the amount of. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. Introduction Integrated Authentication to the MicroStrategy Intelligence Server utilizes the Kerberos authentication protocol to provide a Single Sign-On capability for MicroStrategy users connecting from Web or Developer from a Microsoft Active Directory environment. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. In reality, an . On MicroStrategy 11. Governance of CPU clock speed when installing MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Narrowcast Server. For this point admins need to try the three options and see which one has better performance. Re-run the Configuration Wizard and enabled TLS. Increasing the 'Maximum RAM for Working Set cache' setting will increase the possible limit amount of RAM that can be used by the Microstrategy Intelligence Server. microstrategy. Select the Default option to set LDAP as the default authentication mode. log and MicroStrategy License Manager is the version of the base build installed in that machine. KB20300: After removing the Tahoma font in MicroStrategy Web 10. Helps optimize custom group banding when using the Count Banding method. Once MicroStrategy Web is connected to a cluster, all nodes reference the same project. g. Type the command of . Select Intelligence Server > Default Properties. 5 (on Linux) and 10. x Administration page although the Intelligence Servers are set to automatically connect. KB439852: In MicroStrategy 10. filename is the name of the file to read from or write to. 6 (on Windows), MicroStrategy Messaging Services uses the third-party Kafka framework to handle the DSSErrors. 2. MDMover allows everything to be moved with one click. 67. ACTION:. x server machine. To access the Intelligence Server Configuration Editor in Developer, right-click the Intelligence Server and select Configure MicroStrategy Intelligence Server. Connect to the Developer Instance. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. From the pane on the left, select Servers. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Load balancing directs new Web connections to the least loaded node, as measured by user connections. Maintain your competitive edge with a data-driven retail app designed to scale—from individual locations to global franchises. Select data population for Intelligent Cubes. Open the MicroStrategy Configuration Wizard. The preferences are stored in memory. This chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. MicroStrategy ONE empowers companies worldwide to. In MicroStrategy cluster logic, Intelligence Server uses machine name to. This technical note will explain six methods for determining which server definition is currently being used:Click on Access MicroStrategy Platform to open MicroStrategy Web. x, text in documents still default to that font. After upgrading from MicroStrategy 2019 Update 1 to MicroStrategy 2019 Update 2, it takes much longer to start the Intelligence Server. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. Enter the User Name and Password for the database. This can be confirmed using the MicroStrategy Service Manager, as shown. KB484838: Best practices for performance tuning based on Azure Synapse AnalyticsAfter an unexpected shutdown of MicroStrategy Intelligence Server, perhaps due to a power failure or a software error, services cannot be restarted from the MicroStrategy Service Manager and remain in a "starting" mode. The start time for the Intelligent Cube publication should be noted first. To start Intelligence Server service automatically (when it fails unexpectedly) using the Restarter: In the Server drop-down list, select the machine on which the MicroStrategy Intelligence Server service is installed. Right-click a connected environment and choose Properties. The value provided for the entry described below would work as the service name. Increase the size of Maximum RAM for Working Set cache to a higher value. Then this file is used for Web, Library to communicated with IServer right? Then the file microstrategy. Login using Usher or the login/password provided in the email. From the DSN drop-down list, select the DSN used to connect to the metadata repository. process. x-10. MicroStrategy Web: Web Server. All MicroStrategy log files are stored in the log file lo cation. Navigate to Configure MicroStrategy Intelligence Server > Web Single Sign-on. Once the MicroStrategy users are linked to a Windows user account, follow the steps below to setup Windows Authentication for a MicroStrategy Web, Mobile, or Web Services 9. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Crash data is automatically uploaded to microstrategy. There are three options that are available: 1. Python coding is short, minimal and easy. 8. instancename is the name of a server instance, where required. Speed is typically measured as user wait time or. You can search, view, and edit server-level settings. Significantly improves user-perceived query performance. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. The Intelligence Server moves from the list to the Connected servers list and MicroStrategy Web is connected to the Intelligence Server. 10, 10. The -h option is needed to change the owner on symbolic links as well. x. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. A new file 'status-iserver. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. Solution Deploy the 2020 MicroStrategyLibrary. Edit All Project-Level Settings. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. Then from there, you can create the . This setting limits the time, in seconds, that users can remain idle before their MicroStrategy Intelligence Server session is ended. One possible cause is that the user does not have permission to modify the sys_defaults_<IServer_name>. The MicroStrategy Intelligence Server Universal on Linux operating systems can only be registered as a service by a user running with a root or privileged account. First, the user must log in as the “mstr” user. Telemetry Server Configuration: If you want to setup messaging services cluster, tick the check box "Create a cluster of three or more Telemetry Servers", input the local machine name and remote. It's being used even in the biggest financial, telecom and manufacturing. Do not change the files under the conf folder. A Google account: This account will be used to deploy the Google instance that MicroStrategy will be deployed onto. xml file: <memory> <logging_time>DATE_AND_TIME</logging_time> A connection pool is a collection of TCP connections maintained in the Web server's memory. Step 4. In this article, the MicroStrategy team will review: Prerequisites. filename is the name of the file to read from or write to. Hover over a connected Intelligence server and click the Server Administration icon in the Properties column. Due to the highly customizable nature of how changes can be made, it is outside the scope of MicroStrategy Technical Support to troubleshoot these custom changes. Enterprise environments can have up to 4 clustered nodes. Number of Views 7. The default one is Interactive. 230. This section discusses how to analyze your users' requirements, and the ways you can configure and tune your system to meet. It takes you from setting up and configuring MicroStrategy to security and administration. The ability to view or edit certain settings is determined by a user's. Users should therefore run the "Monitor. When a machine runs out of virtual memory, processes on the machine are no longer able. Click the MicroStrategy connector. Follow these steps while connected to the MicroStrategy Intelligence Server machine to modify the processor affinity settings of an specific installation: Shutdown the MicroStrategy Intelligence Server Universal 8. Why is this happening?When users try to start or stop MicroStrategy Intelligence Server from MicroStrategy Service Manager, nothing happens. MicroStrategy Web, statistics can be used to troubleshoot issues with hanging or slow performance of certain MicroStrategy objects, such as reports or prompts. x at any time, run the following command: $ mstrctl -s. Project. MicroStrategy Library Web & Mobile. A breakdown of memory usage is logged when: The Intelligence server enters MCM denial state for the first time. The MicroStrategy Intelligence Server 9. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Enter the Fully Qualified Domain Names of all Telemetry Server machines in the cluster, or the name of sole the Telemetry Server machine that will be used if there is no clustering. Administrators can export the project settings in this tab to a . reportName. 9 How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server; KB41943: How to create a metric that calculates the distinct count of an attribute order to display total number of regist… The MicroStrategy Listener will monitor the Windows NT Application Event Log for new log entries and uses the log entry of Category 12 from the 'MSTRServer' Source as an indication that MicroStrategy Intelligence Server has been started. This command is used to terminate a process. The default Load balance factor value is 1. For more information about Enterprise Manager, see the Enterprise Manager Guide. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. Afterwards you will see Kafka log files created in the Kafka. ProjectSource. x-10. It turns data into reports for making and executing key organization decisions. This section describes only the most basic guidelines. If only a single MicroStrategy Intelligence. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. xml file and search for 'session. STEPS TO CONFIGURE: Get the path of images folder on the intelligence server machine. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. 67. MicroStrategy Developer must successfully connect to the Intelligence Server via the SSL port. Modify IE 11 Security Setting to enable Allow Font Download: Go to Internet Explorer > Internet Options. Note, for more information refer to tech note KB10211. 4 GB or higher. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. Go to Start > All Programs > Apache Tomcat x. From MicroStrategy Platform home page, scroll down to the Essentials Connections section. Tables v10. x: Statistics logging option. /mstrctl -s IntelligenceServer ssic' from the bin folder to set a new configuration for the MicroStrategy Intelligence Server performance configuration. The Master Health Agent checks for updates from MicroStrategy by connecting to TCP port 443, Enterprise Manager can help you analyze the Intelligence Server statistics data. To specify a database instance, in the Intelligence Server Configuration Editor, select the General subcategory of the Server Definition category, and, in the Database Instance drop-down list, select the database instance to use for the History List. Adding more capacity to a server product. Number of Views 5. Supported data structure and distribution on Gateway. Click on More Items > Contact Us. Type in the URL box the MicroStrategy Mobile Admin page URL with the fully qualified domain name (FQDN),. 10. The suggested number here is 65534, however, you can change the value as long as it is large. reportID. xml file. In the Login area, for LDAP Authentication, select. If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. It is sometimes necessary for administrators to back up the MicroStrategy Web 9. g. KB440719. Efficiently manages thousands of end-user requests (jobs. DisconnectProjects. Performance is a combination of speed and scale. There are various applications of MicroStrategy. By default: -Windows: C:WindowsSystem32driversetchostsThe MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Related Articles. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Then from there, you can create the . ACTION:MicroStrategy recommends that the Linux kernel setting vm. <None>. If the administrator would like to get the status of MicroStrategy Intelligence Server Universal 9. Once activated, the user loads the cube in memory. x to be restarted in order for the changes to take effect. x uses third party client libraries. The default path is C:Program FilesApache GroupTomcatwebappsMicroStrategyWEB-INF. This is also tuning for issues revolving around errors with Garbage Collection overhead limits and in some cases HTTP 500 errors. Project default level preferences are set at the MicroStrategy Intelligence Server 8. How to Start and Stop Intelligence Server Services in Microstrategy By Mohan Vamsi PentakotaHow to Access the Web Administrator Page. instancename is the name of a server instance, where required. 4. Fields Disk Storage Cache file directory: The. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. com) to the hosts file of the Library server machine to manually resolve the iserver name. To increase the number of server nodes, click the 'Number of Server Instances' dropdown. Method to. Ensure auth. When Intelligence Server is installed, the last step is to choose a user identity under which the service will run. msgID. Start Apache Tomcat. Iserver is on windows server, web server is apache tomcat. Apache Kafka is an open-source distributed event streaming platform used by thousands of companies for high-performance data pipelines, streaming analytics and data integration. Right mouse click on the project source of the Intelligence Server you wish to remove the trust relationship from. The MicroStrategy Internal Reference number is DE50391. x and 10. MicroStrategy's flexible, scalable architecture allows organizations to deliver high performance and fast response times at scale.