Start the MicroStrategy Intelligence Server. 3. 52K. . Hello, We had the same problem after upgrading our 11. Once MicroStrategy Web is connected to a cluster, all nodes reference the same project. The original method of migrating MicroStrategy Metadata database server platforms consisted of creating a new MD shell in the destination environment and migrate projects one by one into the destination shell. filename is the name of the file to read from or write to. xml" must either be edited, renamed, or deleted. instancename is the name of a server instance, where required. 1 and above KB10384: How to increase the Java Heap size in Tomcat Application Server Beginning in MicroStrategy 10. Although it is possible to use the Microsoft Access database. How to Start and Stop Intelligence Server Services. The first is the 'Web User Session Idle Time' setting located in Developer by right clicking the project source -> Configure MicroStrategy Intelligence Server -> Governing -> General, as shown in the image below. 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; KB222220: Images are not displayed in Excel documents that are delivered through Distribution Services in MicroStrategy 9. sp. token). For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. On MicroStrategy 10. System Performance Trends. The following procedure describes how to ensure the web server, mobile server and intelligence server use images from the same folder in MicroStrategy 9. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. The MicroStrategy Listener will also check to see that MicroStrategy Intelligence Server is running as a. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. x, the Web Pool Size setting does perform any action or hold to it’s defined value. Then from there, you can create the . Iserver is on windows server, web server is apache tomcat. 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. Follow the below steps to change your environment's Library URL. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. renderer. Tables v10. maxPoolSize. Open the MicroStrategy Configuration Wizard. 1 (2019) rather than 11. The default Intelligence Server configuration settings, defined in the Intelligence Server Configuration Editor, are provided below. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. For an example of how to do this, see the sample code below. Setting this to a higher limit does not mean the memory will be set. Start building with MicroStrategy to deliver exceptional product experiences. The speed at which all programs and processes run depends on the CPU’s performance capacity. x, text in documents still default to that font. xml'. Enterprise Manager consists of a MicroStrategy project, the Enterprise Manager server (service), and an interface in MicroStrategy Command Manager where administrators can control how the server. Number of Views 5. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. This will generate a new certificate and key pair and start the Intelligence Server. Click Connect. It is shared by all processes running on the machine, including the operating system. To forecast future needs, you can plot user load against the resource consumption graphs above. trusted. The governing setting 'Maximum Report Execution Time' can be defined at the Project Configuration level in MicroStrategy, as shown below: Although there is no direct equivalent to this setting at the report level, there is an alternative that should suit many scenarios. We need to use the same REST port number when binding to the SSL certificate. A breakdown of memory usage is logged when: The Intelligence server enters MCM denial state for the first time. Database specific settingsBy default MicroStrategy will still send Intelligence Server diagnostic logs to local disk. x and 11. The heap is a location in memory used by the Java Virtual Machine (JVM). To create the Enterprise Manager project, run Configuration Wizard on the MicroStrategy Intelligence Server machine that uses the Metadata where the project should be created, and select the Create Enterprise Manager project option. Speed is typically measured as user wait time or. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. Search for the files changed (below) in the target machine and create a backup of these files in all cluster nodes. In practice, you get a cert for the server. 4 GB or higher. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. For this point admins need to try the three options and see which one has better performance. log will depend on the Log Path specified during installation. 40. Dedicate a machine for the metadata repository. x/9. MicroStrategy Web must be connecting to the MicroStrategy Intelligence Server via the name configured in the certificate. Queries can have a significant increase in the fetch time when there are tables containing VARCHAR without specifying a size in Snowflake. KB441987. Once you have finished choosing your options, click Create Environment and wait for your environment to provision. Expand the Data Collector Sets node. x. Server-level settings At the server level, only a few settings from each category need a server restart. FrameProcessor. Enterprise environments can have up to 4 clustered nodes. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. The Intelligence Server selection page opens. Install MicroStrategy Intelligence Server using the root account. When the MicroStrategy Web 9. e. 10, 10. Select Automatic as the Startup Type option. x when Intelligence Server is on Linux. Click the icon next to a listed service. Specify subset of cube to be Crash data is automatically uploaded to microstrategy. Important Notes: To ensure integrity of the intelligent cubes, make sure the metadata copies on the source and target environments are exactly same. Copy the new certificate to MicroStrategyLibrary's WEB-INF folder (in the same location from step 2). mstrexec-iserver: WARNING: maximum number of open files 256 is low; please increase to 1000 or greater. . 6. In 2019 Update 2, it takes eight minutes to load the same three projects from the same metadata. Run the MicroStrategy installer by clicking the setup. 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. In MicroStrategy cluster logic, Intelligence Server uses machine name to. View and Analyze Log Files. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. Click the MicroStrategy connector. Double-click the new connection mapping in each column to select the database instance, database connection, database login, and language. max: 1/4 of the number of CPU cores. By default, the cluster will be re-joined automatically as long as the cluster node was not shut down normally (e. xml file. After watching this 3 minutes video you will be able to test mstrio library (based on REST API) yourself. The dossier includes an impact analysis where you can identify all the objects that are affected by changes in the engine behavior, manifested as differences in SQL, data or significant changes. The MCM settings are in the Intelligence Server Configuration Editor, in the Governing Rules: Default: Memory Settings category. browser cache etc is all cleared even tried with re-installing library server. 5. The MicroStrategy Intelligence Server's backup frequency controls how long the server will wait to write cache and inbox files to disk. Stop Tomcat. process. 25K. Expand Intelligent Cubes, and then select General. pd_dump and pg_restore utility can be found in folder C:\Program Files (x86)\Common Files\MicroStrategy\Repository\pgsql\bin STEPS: 1. Optionally, you can change the location or name of the Keystore file clientKey. This port is configurable when setting up the Master Health Agent. x. 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 starting and stopping. During a course which involved microstrategy platform i've been told that: "For MSTR 10. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. 3. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. If False (default), this feature will be disabled. MicroStrategy Web: Web Server. Add the IP to hostname mapping (e. /mstrcmdmgr -interactive and press ENTER to open Command Manager. msgID. MDMover allows everything to be moved with one click. Intelligence Server ensures the. Setting this to a higher number may improve performance under high job concurrency, but it increases the amount of time caches that exist in memory only (i. Platform Analytics is the new monitoring tool in MicroStrategy 11. KB48030: Font change is not applied to the graph in MicroStrategy 9. • Enterprise Manager. Specifying Warehouse Connection Information. HKEY_LOCAL_MACHINE\Software\Microstrategy\Microstrategy Broadcast Server\7. The video also presents how the data from Salesforce reports is converted to MicroStrategy attributes and metrics. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. renderer. You can see this in the diagram in Testing an Environment for the First Time, or by looking at the Intelligence Servers on your MicroStrategy Web Administrator page. Step 5. Efficiently manages thousands of end-user requests (jobs. jks file including the cert with a passphrase, e. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. MicroStrategy Library is a client application running on a desktop browser or a mobile device, whereas HyperIntelligence for Web is available as a Chrome and Microsoft Edge browser extension. With these statistic logs, administrators can observe the amount of time spent on each step of the process for a certain task in MicroStrategy Web. 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. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. In the MicroStrategy Library Configuration box, enter. Connection borrowing occurs when MicroStrategy Intelligence Server executes a Job on a lower priority connection because no connections with an equivalent priority is available for the Job at execution time. The client libraries are certified for use with the MicroStrategy Intelligence Server by operating system platform. Enable the statistics logging for the project. Select the database instance. What is load balancing? Load balancing, as it applies to MicroStrategy Intelligence Server, is a strategy aimed at achieving even distribution of MicroStrategy Web or Web. List Nodes GET /monitors/iServer/nodes Get information about nodes in the connected Intelligence Server cluster, including: Basic information Runtime state Information for the. The Java Virtual Machine has a heap that is shared among all Java Virtual Machine threads. Once the server definition has been changed, MicroStrategy Intelligence Server will start back up using the new server definition. xml file and create a backup copy of it. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. How to Perform Capacity Planning to Fine-tune your BI Project for Sub-Second Response Times MicroStrategy's flexible, scalable architecture allows organizations to deliver high performance and fast response times at scale. Server Activation registers each Server Installation with MicroStrategy and locks the installation to a specific machine. Clear the Enable anonymous access check box. In a UNIX console window, browse to the "bin" folder under <HOME_PATH> where the MicroStrategy is installed. x to version 10. Select the "exportMaxCellsPlainText" setting and modify the "Maximum" value under "Other. g. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. x interface. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. This action starts MicroStrategy Intelligence Server on 'M1. You can implement iServer easily with it. It also covers other features, such as importing data from external public data sources, blending. Navigate to Configure MicroStrategy Intelligence Server > Web Single Sign-on. Significantly improves user-perceived query performance. The ability to view or edit certain settings is determined by a user's privileges. Similar to the MicroStrategy Web application, Library connects to your Intelligence Server and supports multiple different methods of. Crash data is automatically uploaded to microstrategy. ACTION:. From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. Enterprise Manager consists of a MicroStrategy project containing a wide variety of reports and dossiers that present the statistics data in an easy-to-understand format. MOIOffice. For steps to use the Configuration Wizard to upgrade your statistics repository and other MicroStrategy components, see the Upgrade Guide. On the MicroStrategy Web server machine, access the IIS Internet Service Manager. Governance of CPU clock speed when installing MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Narrowcast Server. x; KB38769: MicroStrategy Certificate Server GetCertificatList call returns an empty page on the browser for MicroStrategy Mobile Server 9. You can calculate the factory output rate for one product using the values from the machine-hour capacity formula. KB440719. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. 4. The default value is 10. The setting described below (ServerName) is NOT ONLY for the '&SERVERNAME' macro used in the history list URL. There's a reason we're at the top of the list. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. Significantly improves user-perceived query performance. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. Currently this issue is being reviewed by MicroStrategy for a potential code fix on an upcoming MicroStrategy release. The third-party product(s) discussed in this technical note are manufactured by vendors independent of MicroStrategy. From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Enter the User Name and Password for the database. If changes are made to any objects in the Metadata from a 2-tier connection, those changes will not be reflected in any server connections unless the object cache in the server memory. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. Net_SessionId cookie is set by the JSP application server / IIS to track the user over the course of the its session and is required. To access the Intelligence Server Configuration Editor in Developer, right-click the Intelligence Server and select Configure MicroStrategy Intelligence Server. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Prerequisites for Windows Clustering. 0. d/ directory. UNIX/Linux: After you deploy MicroStrategy Web Universal and log on to the mstrWebAdmin servlet using proper. Or. The JSESSIONID or ASP. The following knowledge base article explains the process to modify the diagnostics logging for MicroStrategy components from the command line in Windows and Unix environments. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. The ODBC connection uses 3. Run Command Prompt as an administrator and enter the following command: netsh add urlacl url=or port/api user=domain\username. Include the port, which is 9092 by default separated from the Fully Qualified Domain Name by a colon. The following best practices can help ensure that users get the most accurate results from a performance test: Performance comparison tests should be run as single-project integrity tests. This allows resources to be shared across the network. This is also tuning for issues revolving around errors with Garbage Collection overhead limits and in some cases HTTP 500 errors. Turn On the Sending Log to Messaging Services Feature. How to increase the Java Heap size in Tomcat Application Server;Even without coding skills. Enter the User Name and Password for the database. For more information regarding the MicroStrategy Web architecture or the process of customizing MicroStrategy Web, please refer to MicroStrategy Developer Zone (the Server Instance tab. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. 4. Step 4. exe application from the extracted zip file. Restart the MicroStrategy Intelligence Server to. 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. Fields Disk Storage Cache file directory: The. Restart MicroStrategy Web and Mobile Server. KB439951: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. Select “MicroStrategy SDK”. SYMPTOM. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. The average salary for Systems Performance/Server Capacity Analyst at companies like MICROSTRATEGY INC in the United States is $83,900 as of November 23, 2022, but the range typically falls between $72,200 and $97,000. From the Oracle Java Virtual Machine Specification Java SE 7 Edition, the heap is described as:. x-10. Step 3. 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. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). This example checks the preference WebPreferenceDpiConversion. Select the Security Filters tab. The Intelligence Server selection page opens. How to increase the JVM Heap size for Microsoft Internet information services to allow for better performance. Performance is a combination of speed and scale. /mstrcfgwiz. xml should do. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. Interactive jobs per project:Step. The Service Options dialog box opens. KB20300: After removing the Tahoma font in MicroStrategy Web 10. x. A third party IP distribution tool such as Cisco Local Router, Microsoft Network Load Balancing, or Microsoft Windows Load Balancing Service distributes the user connections from the Web clients among Web Servers. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. Upload FilesOr drop files. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Select a dataset. KB13943: How to change the log destination for the DSSErrors. The below steps can be used to deploy the MicroStrategyLibrary. GetProjects. It gives you the leverage of generating real-time reports and monitoring data. 4 GB or. Stay up to date on inventory needs and avoid. Enter the User Name and Password for the database. backtrace. First, the user must log in as the “mstr” user. What's New in MicroStrategy 2020. The Web server will create a new TCP connection if it determines that only two connections are idle. You can connect to this server by clicking Connect. 3s. MicroStrategy Web: Web Server. x, users may notice that the "Maximum quota per user (MB)" governing setting (located in Developer under Project configuration > Governing rules > Import Data) is applied at the Intelligence Server node level instead of the Intelligence Server cluster level. 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. x, join cluster fails or doesn't work fine if two nodes don't know each other’s' machine name. Under Collections, click on the the “…” next to. If the Startup type of the MicroStrategy Intelligence Server on 'M1' is set to 'Automatic', the available projects appear automatically. 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. The amount of data that the customer chooses to keep could have a corresponding cost to the customer. xml" file but changing the value between the <state> and </state> tags to read "Stopped" 2. 11, 10. This ensures changes are synchronized in a timely manner. Right mouse click on the project source of the Intelligence Server you wish to remove the trust relationship from. 7, the MicroStrategy Messaging Services services can also be registered with the operating system during installation. optional): If True, utilize optimal number of threads to increase the download speed. 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. Use Response file. Connect. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Related Articles. 5 (on Linux) and 10. Doing so avoids issues where a busy database can't scale up to a capacity with enough memory for the features that are turned on in your cluster and the database workload. Required Status to Perform Action. Selected. The path to the Web server application is entered in the Web Server Application field. If a name is not specified,. browser cache etc is all cleared even tried with re-installing library server. Once you have finished choosing your options, click Create Environment and wait for. Maintain your competitive edge with a data-driven retail app designed to scale—from individual locations to global franchises. 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. x information regarding the connected servers or to make changes manually to the connection properties of a MicroStrategy Intelligence Servers without using the MicroStrategy Web 9. In the Open drop-down list, type cmd and click OK. From the DSN drop-down list, select the DSN used to connect to the metadata repository. 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. Using the Memory Contract Manager. In the Navigation pane, click Environments. Make sure all Intelligence Server nodes are running during the life-time of Library Server. io through protocol. Enter your API Server and select your authentication mode and enter your credentials. In MicroStrategy 10. CAUSE: This is working as designed. process. Select Configure Intelligence Server, and click Next. In MicroStrategy 2020, four additional lines will appear in the status-iserver. x, the limit is 2 TB (2097152 MB) On MicroStrategy 11. Ensure auth. Users experience an issue where Intelligence Servers are getting frequently disconnected from the MicroStrategy Web 9. Users should therefore run the "Monitor. . To log to your screen, select. When installing MicroStrategy Intelligence Server Universal in Unix environment, user needs to specify the path for Home, Install and Log directory as below: As default, the Install and Log folders are under Home folder. In other words, this name needs to be recognizable as a network machine. For example, if the RAM swap multiplier setting is 2 and the requested cache is 80 Kilobytes, 160 Kilobytes are swapped from memory to disk. Increase Maximum RAM for working set cache setting from Server Configuration > Governing Settings > Default > Memory Settings Disable “Web User Session Recovery on Logout” setting from Intelligence Server configuration > Governing Rules > Temporary Storage Settings To increase the limit of number of cells that MicroStrategy Web will allow to export to plain text follow the following steps: Create a new plugin the Web Customization Editor. Microstrategy Intelligence Server status information is stored in the file system under a file called 'status-iserver. iserver_version The current I-Server version. When the job monitor depicts the status as 'executing,' the executing status can apply to the execution of the job within any Processing Unit (PU). A new file 'status-iserver. xxin omcat9w. Tables v9. command is one of the commands from the list below. 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. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. The . When Intelligence Server is installed, the last step is to choose a user identity under which the service will run. To set up MicroStrategy Intelligence Server. Click on More Items > Contact Us. Do not change the files under the conf folder. Increase the Maximum RAM Usage (MBytes) governing setting for caches for the project to something greater than the size of the report that was sent to the History List. Each segment executing in the MicroStrategy Narrowcast Server establishes one session or connection to the MicroStrategy Intelligence Server. Efficiently manages thousands of end-user requests (jobs. With the 10. Request timeout to check if the Intelligence Server is alive. The higher the performance of a CPU, the faster the PC will run. If the administrator would like to get the status of MicroStrategy Intelligence Server Universal 9. All files under the conf folder are overwritten when you upgrade MicroStrategy. Statistics logged. Failover is a key feature in a. This is because registering MicroStrategy Intelligence Server Universal 9. browser cache etc is all cleared even tried with re-installing library server. MicroStrategy ONE empowers companies worldwide to. mstr file is a zipped file of object definition package and cube files. Method to.