x ODBC calls by default. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. Edit the "status-iserver. We tried all your suggestion but we still had the problem. KB441987. The user is the basic unit in the MicroStrategy security model. Retrieve Data from the Intelligence Server Using the JSON Data API. In reality, an . When a machine runs out of virtual memory, processes on the machine are no longer able. You should periodically reevaluate the system and update it based on actual system performance and use. 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 reduces the load on Integrity Manager and ensures that the recorded times are as accurate as possible. From the pane on the left, select Servers. type: Puppeteer exporter. Specifying Warehouse Connection Information. The following is an example of VBA code for Excel that gets the list. Both enabling and disabling logs are covered. x to be restarted in order for the changes to take effect. 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. You can find this ID by running the “ps” command. x-10. x to version 10. Select a dataset. The DNS needs to recognize the entry as a machine and be able to resolve its. 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. Within the Tomcat installation directory, navigate to the deployed MicroStrategy directory and open the WEB-INF folder within it. 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. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. xml" must either be edited, renamed, or deleted. csv file to keep a record of their settings, or import a previously save file to apply the setting to a project. Number of Views 7. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. Number of Views 5. Enterprise environments can have up to 4 clustered nodes. 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. x to be restarted in order for the changes to take effect. For an example of how to do this, see the sample code below. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. Stop Tomcat. You will be able to: - connect to MicroStrategy Server. 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. MicroStrategy Web, statistics can be used to troubleshoot issues with hanging or slow performance of certain MicroStrategy objects, such as reports or prompts. Upload FilesOr drop files MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. xml file and search for 'session. 73K KB441259: Location of the Project Source Name's Intelligence. This will generate a new certificate and key pair and start the Intelligence Server. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. The default value is 10. Launch MicroStrategy Web from the Landing Page of your environment. On Windows, all log files are stored in C:Program Files (x86)Common FilesMicroStrategyLog. Depending on the version installed (as a best practice no higher than the 25% of the available RAM in the server), the Maximum working set RAM values to are is on the following list:Before MicroStrategy 9. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. This is also tuning for issues revolving around errors with Garbage Collection overhead limits and in some cases HTTP 500 errors. 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 . trustToken and auth. trusted. Right mouse click on the project source of the Intelligence Server you wish to remove the trust relationship from. Restart the MicroStrategy Intelligence Server to. UNIX/Linux: After you deploy MicroStrategy Web Universal and log on to the mstrWebAdmin servlet using proper. Grid (1) or Graph (2) Mode. Select one of the following to determine when and how MicroStrategy Web. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. Setting this to a higher limit does not mean the memory will be set. It is noticed that the Intelligence server hosted machine can't ping each other by machine name. If False (default), this feature will be disabled. 1m running on Microsoft IIS ServerOpen a new or existing dossier. 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. properties: iserver. Project. command is one of the commands from the list below. 2. The maximum value is 99 and the minimum value is 1. Retail is leveling up with omnichannel analytics. 52K. Then from there, you can create the . In 2019 Update 2, it takes eight minutes to load the same three projects from the same metadata. Edit All Server-Level Settings. By default, it is 34952, but ask your MicroStrategy. Windows: C:Program Files (x86)MicroStrategyIntelligence ServerTLS. WORKAROUND: Disable the Cube Health Check Feature on the effected environment by adding the following key: [HKEY_LOCAL_MACHINESOFTWAREMicroStrategyDSS ServerCastor]. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. x; KB38769: MicroStrategy Certificate Server GetCertificatList call returns an empty page on the browser for MicroStrategy Mobile Server 9. 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. If the Startup type of the MicroStrategy Intelligence Server. You can use the Reports API, the Cubes API and the Dossiers API to retrieve definitions and data from the Intelligence Server. Expand Intelligent Cubes, and then select General. Editing cluster membership is an administrative action and should be performed exclusively. Only the database names listed in DBAdminConfig. (Note: On MicroStrategy Intelligence Server machine, go to Administrative Tools -> Services, open the Microsoft Services window and locate the MicroStrategy Intelligence Server service. 5. 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. 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. Run Command Prompt as an administrator and enter the following command: netsh add urlacl url=or port/api user=domainusername. 230. max_map_count be defined as 5,242,880 bytes. MicroStrategy Health Center Master Health Agent listens for incoming connections from Health Agents and the Health Center Console on TCP port 44440 by default. Follow the below steps to change your environment's Library URL. Double-click the new connection mapping in each column to select the database instance, database connection, database login, and language. 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). By default, the cluster will be re-joined automatically as long as the cluster node was not shut down normally (e. max: 1/4 of the number of CPU cores. 24. 3s. Expand Intelligent Cubes, and then select General. exe" -n "MicroStrategy Tutorial" -u Administrator -p 007007 -f C: estartserver. STEPS TO CONFIGURE: Get the path of images folder on the intelligence server machine. config. Browse to and right-click the MicroStrategy virtual folder and select Properties. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. Change the path if it is incorrect. Enter the User Name and Password for the database. 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. jks at this time via the sslClientKeystore parameter in the microstrategy. All basic statistics. Related Articles. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. Place intelligence server close to the both the data warehouse and the metadata repository. Right-click in the grid and select New to create a new connection mapping. The ability to view or edit certain settings is determined by a user's. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. Open the MicroStrategy Configuration Wizard. Select the Directory Security tab, and then under Anonymous access and authentication control, click Edit. Click on the Developer Machine Name to copy it. System Performance Trends. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. 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. 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. If the administrator would like to get the status of MicroStrategy Intelligence Server Universal 9. x. backtrace. The license check takes place anytime within the next half hour of the time specified in the setting. After upgrading from MicroStrategy 2019 Update 1 to MicroStrategy 2019 Update 2, it takes much longer to start the Intelligence Server. The Performance Analysis folder in Enterprise Manager has reports that measure such metrics as average job execution time and other job performance trends, cache analysis, longest executing reports, and so on. Drop Files. Choose the individual modules to be logged. Hover over a connected Intelligence server and click the Server Administration icon in the Properties column. You can use. MicroStrategy Telemetry Store: This service consumes all telemetry data from MicroStrategy Services layer, and do ETL process for the Platform Analytics project, also named as Platform Analytics Consumer. 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. Select “MicroStrategy SDK”. (Min 2) Maximum number of renderer processes. GetProjects. User session and project session analysis. 11. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. All MicroStrategy log files are stored in the log file lo cation. Choose the individual modules to be logged. MicroStrategy Server Activation is a licensing technology that ensures that installations of MicroStrategy server products are authentic and have been legitimately licensed. 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. There are two cases of this: The Intelligence server has never entered MCM denial state and this is the first time doing so. 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). x. It is sometimes necessary for administrators to back up the MicroStrategy Web 9. The preferences are stored in memory. xml file. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. 6. xxin omcat9w. The objective of this document is to provide an estimation of resource requirements for stable and performant operation of. 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. Property Default Value Comments; exporter. In addition, this release introduces new features across the analytics, mobility, and security platform - making it easier for users to build applications. labs. Edit the web. Welcome to Platform Analytics! The vision of MicroStrategy is Intelligence Everywhere. 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. This technique is useful till 80%. x Statistics are enabled and a dashboard is executed the MicroStrategy Intelligence Server stats are incorrectly reported as a. war file on a default MicroStrategy Windows installation. 9Performance is a combination of speed and scale. The license check takes place anytime within the next half hour of the time specified in the setting. 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. It collects real-time data (also known as telemetry) which is generated by different components of the MicroStrategy platform like the Intelligence Server. This action starts MicroStrategy Intelligence Server on 'M1. yaml. FrameProcessor. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. Right-click on User Defined and select New. 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. 2. x and 11. In the Add a server manually field, specify the DNS name of the Intelligence Server machine. Then from there, you can create the . The important functions of MicroStrategy Intelligence Server are: Managing the sharing of data and objects in a controlled and secure environment. Request a demo. Select Configure Intelligence Server, and click Next. Once MicroStrategy Web is connected to a cluster, all nodes reference the same project. This can be done using the following command: chown -hR <new user account>:<user group> <Install folder>. Request timeout to check if the Intelligence Server is alive. filename is the name of the file to read from or write to. "" -n "" -u -p -f. This feature. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. trusted. If a name is not specified,. 2 environment to 11. 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. The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. After calculating the production capacity of each product, you can calculate the factory output rate for multiple products. Increase the size of Maximum RAM for Working Set cache to a higher value. To stop the server using this command, you would need to run the following command: “kill -9 PID” PID is the process ID of the MicroStrategy Intelligence Server. If a name is not specified, the command uses the default instance name. 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. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. To forecast future needs, you can plot user load against the resource consumption graphs above. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. 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. x level and not on the cluster level. jks at this time via the sslClientKeystore parameter in the microstrategy. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. Remember to replace all child object permissions. Select data population for Intelligent Cubes. How to increase the Java Heap size in Tomcat Application Server. To increase the number of server nodes, click the 'Number of Server Instances' dropdown. Increase the size of Maximum RAM for Working Set cache to a higher value. Connect. zip file, with the. You can search, view, and edit server-level settings. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. 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. KB39915: A blank page appears when trying to generate the client certificate using a browser from MicroStrategy Mobile Certificate Server 9. x when Intelligence Server is on Linux. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. x and 10. Supported data structure and distribution on Gateway. How to increase the Java Heap size in Tomcat Application Server;Summary. Beginning in MicroStrategy 10. 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. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. In MicroStrategy Developer, log in to a project source with administrative privileges. renderer. When State displays Stopped the service is inactive. 11. Include the port, which is 9092 by default separated from the Fully Qualified Domain Name by a colon. Go to the Java tab and specify a maximum memory pool: Save the changes and startup or restart Tomcat. Change the UseUTC value to 1, as shown below: Restart the MicroStrategy Logging Client and MicroStrategy Logging Server services from Control Panel > Services for the changes to take effect. When you use the cube directly in the Dossier, the definition is applied to the cube directly and the MicroStrategy AE saves time since it doesn’t have to search and fetch an extra report definition. When the MicroStrategy Web 9. Edit All Project-Level Settings. Select Configure Intelligence Server, and click Next. 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. renderer. Crash data is automatically uploaded to microstrategy. 1. Restart MicroStrategy Web and Mobile Server. After changing the ACU settings for the cluster. 1 and aboveNote: Starting in MicroStrategy 11. In the Open drop-down list, type cmd and click OK. A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere™. Right-click an Intelligent Cube and select Delete. requestTimeout. The user. Install MicroStrategy Intelligence Server using the root account. The memory used by Intelligence Server is limited by the machine's virtual memory. Enter this value in the Server busy timeout field. The heap is a location in memory used by the Java Virtual Machine (JVM). renderer. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. The default value is 256 megabytes. instancename is the name of a server instance, where required. In the Action column in the Unconnected servers list, click Connect for the Intelligence Server to connect to. List Nodes GET /monitors/iServer/nodes Get information about nodes in the connected Intelligence Server cluster, including: Basic information Runtime state Information for the. In the Navigation pane, click Environments. Multiple "mstrexec-iserver" process instances are seen in MicroStrategy Intelligence Server 9. Change the "<Servername>" to the desired MicroStrategy Intelligence Server and save the changes. When creating the trust relationship through MIcroStrategy Office, the token for WS1 will be written into the common metadata for both Intelligence Server nodes. 4001 - runReport Executes the report specified by either the reportID or reportName argument. exe. iserver. 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. The Servers page opens. From the DSN drop-down list, select the DSN used to connect to the metadata repository. In practice, you get a cert for the server. On the other hand, some other configuration files stay as part of the configuration process and are useful to run the applications. The ability to view or edit certain settings is determined by a user's privileges. 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. /mstrctl -s IntelligenceServer stopSample URLs for exporting a Report Services document to PDF are shown below. HKEY_LOCAL_MACHINESoftwareMicrostrategyMicrostrategy Broadcast Server7. Network configuration best practices. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Note, for more information refer to tech note KB10211 . However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. ProjectSource. g. 50s. By default: -Windows: C:WindowsSystem32driversetchostsThis chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. For example, if a startup script has the following name: "mstr-root@2015-10-21T10:09:23-iserver-CastorServer", it can be changed to "mstr-root@-iserver-CastorServer", but in MSIReg. There's a reason we're at the top of the list. Users experience an issue where Intelligence Servers are getting frequently disconnected from the MicroStrategy Web 9. MDMover allows everything to be moved with one click. Remember that the memory used will decrease. x to effectively register the change. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. MicroStrategy Library Web & Mobile. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. 3. Intelligence Server ensures the scalability and fault tolerance required for sophisticated analysis of terabyte databases and deployments to millions of users. 4. disk availability is below the 80% capacity threshold. 1 and above on Windows and Linux operating systems. "rlim_fd_cur" specifies the “soft” limit on file descriptors that a single process can have open. For more details, see KB442160. The example above can be summarized by ensuring that the project loading is optimized by making the max Ram usage of object cache 10 times greater than the estimated schema size. 0. The Intelligent Cube Monitor is displayed. yaml are backed up by this tool. below. • Enterprise Manager. Go to Start > All Programs > Apache Tomcat x. To forecast future needs, you can plot user load against the resource consumption graphs above. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. x-10. 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. renderer. Knowing your production capacity gives you the chance to improve production planning and production scheduling, give more accurate lead times, and forecast your cash flow. log will depend on the Log Path specified during installation. The MicroStrategy Intelligence Server's backup frequency controls how long the server will wait to write cache and inbox files to disk. This section describes only the most basic guidelines. MicroStrategy ONE empowers companies worldwide to. 26K. MicroStrategy Web must be connecting to the MicroStrategy Intelligence Server via the name configured in the certificate. 3. You can use a linear or exponential extrapolation to plot how increase in user load will drive resource consumption. This option must be selected for any statistics to be logged. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. Find MicroStrategy’s public API in Postman and make your own copy (Fork). 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. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. The crash collection server analyzes the incoming crashes and notifies MicroStrategy technical support and production teams for the incidents. KB439951: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. x from the Command Line, run the following command: $ mstrctl -s IntelligenceServer stop. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single, unified Web interface. 10. The value provided for the entry described below would work as the service name. Locate the web. 2. Embedded is the power play — this is where the magic happens. x, users should see the Intelligence Server automatically rejoin a cluster upon restart. Select Intelligence Server > Default Properties. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. (Min 2) Maximum number of renderer processes. During a course which involved microstrategy platform i've been told that: "For MSTR 10. Speed is important because it affects the user experience. Speed is important because it affects the user experience. If only a single MicroStrategy Intelligence. 0Distributed Logging ServiceDistributedLogger. In MicroStrategy 9. When a setting is not a runtime setting, MicroStrategy Desktop prompts users to restart MicroStrategy Intelligence Server 9. You can implement iServer easily with it. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. 7, the MicroStrategy Messaging Services services can also be registered with the operating system during installation. This can be achieved via the report level VLDB property > SQL Time. This article describes one of the reason why MicroStrategy Web application could hang intermittently and works well for some time after restart of the server and how to fix it. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. When Intelligence Server is installed, the last step is to choose a user identity under which the service will run. Beginning in MicroStrategy 10. instancename is the name of a server instance, where required. Fields Disk Storage Cache file directory: The. x: Statistics logging option. A list of Web Preferences can be found in the MicroStrategy Enumeration EnumWebPreferences in the MicroStrategy Developers Library Java API Reference. Efficiently manages thousands of end-user requests (jobs. mstr suffix. filename is the name of the file to read from or write to. The higher the performance of a CPU, the faster the PC will run. ACTION: Open IIS on the MicroStrategy Web, Mobile, or Web Services 9. Project default level preferences are set at the MicroStrategy Intelligence Server 8. 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. x-10. If no project sources are defined, then the Configuration Wizard opens. In the Service drop-down list, select MicroStrategy Intelligence Server. optional): If True, utilize optimal number of threads to increase the download speed. ACTION: This tech note explains: File Relationships. Administrators can export the server settings in this tab to a .