How to increase the Java Heap size in Tomcat. If administrators attempt starting MicroStrategy Intelligence Server from Administrative Tools > Services, they. 11. To log to your screen, select. If a customer opts to increase the data repository and/or cube memory requirements, they will either necessitate a change order or will beIntroduction. You can find this ID by running the “ps” command. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. msgID. There are two types of TCP connections: busy and idle. log will depend on the Log Path specified during installation. max: 1/4 of the number of CPU cores. Performance degradation occurs because the MicroStrategyWhen a cluster of MicroStrategy Intelligence Servers connects to MicroStrategy Web, the following behavior can be observed in the MicroStrategy Web Administrator page: All MicroStrategy Intelligence Servers in the cluster will be added as a single unit, as shown with the example above. /mstrcmdmgr -interactive and press ENTER to open Command Manager. bat. . The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Prerequisites. csv file to keep a record of their settings, or import a previously save file to apply the setting to a project. MOIOffice. Run Command Prompt as an administrator and enter the following command: netsh add urlacl url=or port/api user=domain\username. Prerequisites for Windows Clustering. Refer to the following Community article for details on how to increase this setting: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. We need to use the same REST port number when binding to the SSL certificate. How to Perform Capacity. Tables v10. If False (default), this feature will be disabled. KB439951: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. 9Performance is a combination of speed and scale. The amount of data that the customer chooses to keep could have a corresponding cost to the customer. Launch MicroStrategy Web from the Landing Page of your environment. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. GetProjects. After installation, user may need to check those folder path to locate specific files. Select the database instance. There are two ways to register the MicroStrategy Intelligence Server as a service: From the Configuration Wizard: on the Specify a Port Number page – “Register Intelligence Server as a Service option” needs to be checked; From the command line: in ~/MicroStrategy/bin by entering: mstrctl -s IntelligenceServer rsThe MicroStrategy Intelligence Server 9. 40. 11, 10. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. KB439852: In MicroStrategy 10. 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. MicroStrategy. KB48030: Font change is not applied to the graph in MicroStrategy 9. config. 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. By default, it is C:Program Files. 2 (2020). The path to the Web server application is entered in the Web Server Application field. You can search, view, and edit server-level settings. x: Statistics logging option. x or 10. Make sure all Intelligence Server nodes are running during the life-time of Library Server. The search specifies a base location in the directory tree as specified by the user in the "Search root distinguished name (DN)" field of the MicroStrategy Intelligence Server configuration. Expand the Data Collector Sets node. The test is for a single cube (4M rows) republish executed on the MicroStrategy 2021 Update 2 release with platform as 32 CPU, 244 GB memory Amazon Linux machine. Step 4. This ensures changes are synchronized in a timely manner. 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. One possible cause is that the user does not have permission to modify the sys_defaults_<IServer_name>. Telcos using MicroStrategy can run. Memory Contract Manager (MCM) is designed to protect Intelligence Server in cases where a memory request would cause the system to approach a state of memory depletion. Element search request timeout. You can implement iServer easily with it. Property Default Value Comments; exporter. 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. exe" -n "MicroStrategy Tutorial" -u Administrator -p 007007 -f C: estartserver. For an example of how to do this, see the sample code below. KB20300: After removing the Tahoma font in MicroStrategy Web 10. 24. browser cache etc is all cleared even tried with re-installing library server. The Service Options dialog box opens. Connect to the Developer Instance. trusted. filename is the name of the file to read from or write to. It processes data and delegates commands. xml should do. Within the Tomcat installation directory, navigate to the deployed MicroStrategy directory and open the WEB-INF folder within it. We have to start the install program again Pick Modify Get to the Select Components part Check “MicroStrategy Analytics Modules” and install those components After it is installed, Start the Configuration Wizard (in MicroStrategy Tools) Select “Configure Intelligence Server” Chose “Analytics_Metadata” for the DSN Default for. However, MicroStrategy NT authentication will fail to login since IIS will not pass the user's NT login ID which comes from the MicroStrategy Login process. KB440719. '. x, the Web Pool Size setting does perform any action or hold to it’s defined value. xml file. 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. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. io through protocol. 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. 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. ACTION: Open IIS on the MicroStrategy Web, Mobile, or Web Services 9. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. The user must review the contents of any shell scripts that have been modified post installation that are used by MicroStrategy Intelligence Server Universal. To do it, hover over the icon and click Edit Connector. Queries can have a significant increase in the fetch time when there are tables containing VARCHAR without specifying a size in Snowflake. Memory mapped files (MMF) can be used for effective RAM utilization. x uses third party client libraries. If Custom Install is chosen, make sure "MicroStrategy Telemetry Server" is selected (it's auto selected when "MicroStrategy Intelligence" is selected). Intelligence Server ensures the scalability and fault tolerance required for sophisticated analysis of terabyte databases and deployments to millions of users. mstr file is a zipped file of object definition package and cube files. Choose the individual modules to be logged. 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. So even if the usage is for the regular Single-Byte Character Set (SBCS), it is calculated as two bytes per character so that there is a. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. The speed at which all programs and processes run depends on the CPU’s performance capacity. In the left pane, click Caches and Cubes. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. To forecast future needs, you can plot user load against the resource consumption graphs above. Hello, We had the same problem after upgrading our 11. g. The MicroStrategy Intelligence Server first searches for the user on the LDAP server using the login name provided. Retrieve Data from the Intelligence Server Using the JSON Data API. Re-run the Configuration Wizard and enabled TLS. Do not change the files under the conf folder. 4. Browse to and right-click the MicroStrategy virtual folder and select Properties. The Servers page opens. x and 11. Using the Memory Contract Manager. To forecast future needs, you can plot user load against the resource consumption graphs above. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. Configure Metadata Connection. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. Specify subset of cube to be Crash data is automatically uploaded to microstrategy. Step 5. Upload FilesOr drop files MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. Every time that a user does something in MicroStrategy, like. When State displays Running the service is ready. jks at this time via the sslClientKeystore parameter in the microstrategy. xml'. com) to the hosts file of the Library server machine to manually resolve the iserver name. x on Linux as a service makes changes to the scripts required to be run at the system startup. 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. The Intelligence Server is added to the Connected Servers list. . x in an interactive mode in Windows and UNIX. View and Analyze Log Files. 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. Change the owner of the files to be the new non-root user account (and non root user group. jks at this time via the sslClientKeystore parameter in the microstrategy. 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. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. If present, the report is fetched from memory and the reportID argument is ignored. When considering load balancing in MicroStrategy environment, the two most critical points. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. To run a clustered configuration, the user must be a domain account that has a trust relationship with each of the computers in the cluster. Select a dataset. The default one is Interactive. 4. x; KB38769: MicroStrategy Certificate Server GetCertificatList call returns an empty page on the browser for MicroStrategy Mobile Server 9. xA user has set up MicroStrategy Web 9. 10. 2. Configuring MicroStrategy Using Command Line Tools: MicroStrategy tools are provided in command line mode on Linux so that you can. This is working as designed. 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. In the Login area, for LDAP Authentication, select. Choose Add Data > New Data. Note: Make your configuration changes to the configuration files located under the admin folder. It turns data into reports for making and executing key organization decisions. 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). xml', for example 'status-iserver. 1 and above KB10384: How to increase the Java Heap size in Tomcat Application Server Beginning in MicroStrategy 10. This allows the Intelligence Server to utilize the system memory resources. 1. xml and open it with notepad, as shown below: Locate the project source name that should be changed. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. Select “MicroStrategy SDK”. process. If the administrator would like to get the status of MicroStrategy Intelligence Server Universal 9. Fields Disk Storage Cache file directory: The. 50s. Expand Intelligent Cubes, and then select General. The Server Properties page opens and displays the following information about the Intelligence Server: Name and connection status. The important functions of MicroStrategy Intelligence Server are: Managing the sharing of data and objects in a controlled and secure environment. Iserver is on windows server, web server is apache tomcat. 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. trusted. below. Note, for more information refer to tech note KB10211 . You can build real-time or near-real-time MicroStrategy applications based on it. 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. Enter the User Name and Password for the database. xml > isAliveRequestTimeoutMillis. In the Platform Analytics Configuration section, check the box. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. trustToken and auth. If the Startup type of the MicroStrategy Intelligence Server on 'M1' is set to 'Automatic', the available projects appear automatically. x to be restarted in order for the changes to take effect. Excel API. MicroStrategy's flexible, scalable architecture allows organizations to deliver high performance and fast response times at scale. x using the MicroStrategy Configuration Wizard 9. From the DSN drop-down list, select the DSN used to connect to the metadata repository. x in Microsoft IIS to use Anonymous authentication, but for security reasons, would want to have the MicroStrategy Web Administration page to authenticate using Windows authentication, the following steps will ensure that a user must enter the application server's administrative credentials in order. 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. What is the reason for the. The crash collection server analyzes the incoming crashes and notifies MicroStrategy technical support and production teams for the incidents. The -h option is needed to change the owner on symbolic links as well. All necessary privileges are included in the Administrator role by default. This section discusses how to analyze your users' requirements, and the ways you can configure and tune your system to meet. When the MicroStrategy Web 9. Users may find additional information related to managing and using Intelligent Cubes in. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. You can use the Reports API, the Cubes API and the Dossiers API to retrieve definitions and data from the Intelligence Server. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. Salary ranges can vary widely depending on many important factors, including education, certifications, additional skills,. renderer. From the DSN drop-down list, select the DSN used to connect to the metadata repository. The MCM settings are in the Intelligence Server Configuration Editor, in the Governing Rules: Default: Memory Settings category. Refer to the following Community article for details on how to increase this setting: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. Login using Usher or the login/password provided in the email. Increase the size of Maximum RAM for Working Set cache to a higher value. 230. Memory Contract Manager (MCM) is designed to protect Intelligence Server in cases where a memory request would cause the system to approach a state of memory depletion. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. Do not change the files under the conf folder. When you create a new user, you need to provide some or all of the following information: Login information. This Knowledge Base article addresses an identified defect where the Web Pool Size setting doesn’t do anything in MicroStrategy 10. If the Startup type of the MicroStrategy Intelligence Server. They are part of the MicroStrategy REST Server, which is shipped inside the. iserver. Selected. For example, if Initial Pool Size is two, when the first user logs in to MicroStrategy Web, a new. Step 3. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Open MicroStrategy for Office in Excel for the web or the Excel desktop application. Right-click a connected environment and choose Properties. 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. 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. Connect. . Edit the web. When we think about how to truly get the attention of users and increase analytics adoption, the answer many times is embedded analytics. Use Response file. Right-click a project and choose Properties. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). 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. Required Status to Perform Action. x, the limit is 4 TB (4194304 MB) Note : Increasing the 'Maximum RAM for Working Set cache' setting will increase the possible limit amount of RAM that. 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. This will generate a new certificate and key pair and start the Intelligence Server. Number of Views 5. 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. 5 GB. MicroStrategy ONE empowers companies worldwide to. 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. How to increase the Java Heap size in Tomcat Application Server;The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. max_map_count be defined as 5,242,880 bytes. 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. Select Intelligence Server > Default Properties. In this article, the MicroStrategy team will review: Prerequisites. Access the MicroStrategy Web Administrator page. The default value is 256 megabytes. A breakdown of memory usage is logged when: The Intelligence server enters MCM denial state for the first time. MicroStrategy is an enterprise business intelligence application. Here at MicroStrategy, we want to ensure that our users have the information they need to get their platform up and running. All files under the conf folder are overwritten when you upgrade MicroStrategy. It collects real-time data (also known as telemetry) which is generated by different components of the MicroStrategy platform like the Intelligence Server. Open the MicroStrategy Configuration Wizard. It takes you from setting up and configuring MicroStrategy to security and administration. It gives you the leverage of generating real-time reports and monitoring data. The. 52K. In MicroStrategy Developer, log in to a project source with administrative privileges. SYMPTOM. By the same token, our platform is also the source of valuable data. labs. It turns data into reports for making and executing key organization decisions. reportID. Step 4: The "status-iserver. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. ) ,. x Administration page although the Intelligence Servers are set to automatically connect. The Upgrade Analysis Dossier is a pre-built dossier that analyzes and visualizes the output data from Integrity Manager Capacity Testing Tool results. MicroStrategy OLAP Services allows users to analyze data by slicing and dicing, inserting new metrics and filters, and manipulating reports in-memory without executing queries against the data warehouse. Then this file is used for Web, Library to communicated with IServer right? Then the file microstrategy. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. Maintain your competitive edge with a data-driven retail app designed to scale—from individual locations to global franchises. In the Server drop-down list, select the name of the machine on which the service is installed. 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. 0, the behavior has been changed and the Intelligence Server does not use Messaging Services by default. 3. In IIS, once Anonymous Access is configured, any web user will take an IUSR_machine_name account first as designed in IIS, so it will work for Standard Authentication users. You need to increase the ulimit parameters by running ulimit -n 65534. 10 xxxxxxxxxx. This issue only happens on Windows. 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. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. 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. x Statistics are enabled and a dashboard is executed the MicroStrategy Intelligence Server stats are incorrectly. There are two cases of this: The Intelligence server has never entered MCM denial state and this is the first time doing so. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. Governance of CPU clock speed when installing MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Narrowcast Server. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. The architecture for HyperIntelligence for Web is similar to MicroStrategy Library. Clear the Enable anonymous access check box. 3. From the pane on the left, select Servers. Make sure that SSL is already configured and note down the REST port number used, as shown in the screenshot below. Create Response fileMicroStrategy Internal case number: 379474 -----Installation instructions-----This patch should be applied on top of MicroStrategy 9. x ODBC calls by default. A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere™. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. UNIX/Linux: After you deploy MicroStrategy Web Universal and log on to the mstrWebAdmin servlet using proper. The user is the basic unit in the MicroStrategy security model. Once MicroStrategy Web is connected to a cluster, all nodes reference the same project. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. In the Navigation pane, click Environments. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. Two different options exist for methods to deal with environments that have different supporting database servers. Disconnect. g. The Web Administrator page opens. Launch MicroStrategy Developer. Choose the individual modules to be logged. Expand Intelligent Cubes, and then select General. x, the limit is 2 TB (2097152 MB) On MicroStrategy 11. x server using Microsoft IIS 7. Select Intelligence Server > Default Properties. x, the limit is 4 TB (4194304 MB) Note: 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. In the left pane, click All Settings. Before following this KB article, the following prerequisites must have been completed: Make sure that the MicroStrategy Intelligence Server is configured correctly to use Integrated Authentication as per the following technical note KB19110Workstation for both Windows and Mac OS has a set of log files that can be found or enabled for troubleshooting purposes. 4 GB or. Together, they are often referred to as the JSON Data API. instancename is the name of a server instance, where required. The requests are granted or denied according to user-configured limits on the amount of. HKEY_LOCAL_MACHINE\Software\Microstrategy\Microstrategy Broadcast Server\7. Number of Views 79. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. In 2019 Update 1, it took one minute to load three projects. Only the database names listed in DBAdminConfig. The default value is 256 megabytes. Request a demo. After calculating the production capacity of each product, you can calculate the factory output rate for multiple products. 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. HKEY_LOCAL_MACHINESoftwareMicrostrategyMicrostrategy Broadcast Server7. Find MicroStrategy’s public API in Postman and make your own copy (Fork). Enter the User Name and Password for the database. x when Intelligence Server is on Linux. microstrategy. 1 and aboveNote: Starting in MicroStrategy 11. This video will help you get started using the MicroStrategy REST API. When users try to start and stop MicroStrategy Intelligence Server from Windows Services by going to Settings->Control Panel ->Administrative Tools ->Services, they can start and stop MicroStrategy. 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. jks. 11. Action. In the Add a server manually field, specify the DNS name of the Intelligence Server machine. In MicroStrategy cluster logic, Intelligence Server uses machine name to. jks file including the cert with a passphrase, e. Scale is important because it determines how many people can submit requests or reports to an analytics platform, how many reports can be supplied by the system, and. ) One (or more) of the above fail to start. Frame Description Access, filter, publish, and extract data from MicroStrategy in-memory cubes. This knowledge base article outlines requirements, considerations, and steps to take when enabling MicroStrategy Library and MicroStrategy Collaboration Server for secure communication and/or load balanced service. This option must be selected for any statistics to be logged. This means you can manually change the suffix to . Click Dependencies tab, the above 3 dependencies are listed. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. The preferences are stored in memory. e. 4. x and 10. We finally found our root cause : Web server need to comunicate with IS-Server on port 34962 for the Rest api, after opening this stream, the problem was solvedIncrease 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 SettingsTo 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. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. x. Change the path if it is incorrect. Note: The utility is not available on MicroStrategy 9.