MicroStrategy ONE

Troubleshooting HyperIntelligence Authoring in Workstation

While creating cards in Workstation, you may encounter the following errors. Use the guidance below to troubleshoot these errors.

Error: Cannot create or edit the card based on "X" cube

This error appears when creating or editing a card based on an unpublished cube. To publish your cube, see the In-Memory Analytics Help.

Error: Environment is not available to create a card

This error message appears when creating or editing a card. Typically, this error is a result of a networking issue where HyperIntelligence cannot connect to your environment. To resolve the error, its recommended that you modify your machine's host file to include your server IP address and server host name. For more information, see KB482957.

Error: Cannot create or edit the card

There are two situations when you may see this error: when a port is closed or when an unknown error has appeared.

Issue: Closed Port

This error may appear because the port on the Intelligence Server machine cannot be reached. To resolve this error, modify your machine's host file to include your server IP address and server host name. Ensure that both port 34962 and port 34952 are open on the Intelligence Server machine.

The client uses port 34962 to connect to the REST Server running on the Intelligence Server. You can confirm that the closed port is the root of your problem by entering the following URL into a browser on a different machine than where the Intelligence Server is hosted: http://[intelligence server ip address]:34962/api. If a page opens with the text {“message”: “Error message: User has not logged in”}, then port 34962 is open. If you receive an error or notification, then the port is closed. It's recommended that you verify the port rule has been created on the Intelligence Server machine and that there are no network firewalls or rules that prevent traffic from communicating with port 34962. For more information, see Using MicroStrategy with Firewalls.

Alternatively, this error can also appear when SSL is not properly configured on the Intelligence Server. Incorrectly configured SSL can create a false closed port error in Workstation. For more information, see Secure Communication in MicroStrategy.

Issue: Unknown

You may also see this error message with a different description under the title. Instead of a port error description, the error will ask you to check your error logs for the TicketID. This is a result of an unknown error.

The best way to determine the root of the problem is to read through the Workstation or Library error logs. To locate your logs, go to MicroStrategyLibrary/WEB-INF/classes/ and open the logback.xml file in a text editor. Locate the line <property name="LOG_HOME" value="logs" />. The value parameter is the path where the Library Logs are located. If the Intelligence Server is running on a different machine then this path is referring to that machine and not the machine running the Library Server.

Generally the Library logs appear in a logs folder wherever the Library Server was started from. Open this log and look for an error with a corresponding TicketID to determine the issue. If you cannot locate the logs folder, replace logs with a hard path on your machine (e.g. C:/Users/example/Desktop/logs) and restart the Tomcat Server. The error appears again to produce a new log in your log folder. Contact MicroStrategy Technical Support for more complex errors.

Issue: Fail to Fetch Data

When creating or editing a card, this error may appear because the data cannot be fetched. It's likely a certificate is missing from the firewall or load balancer. To resolve this error, add a root certificate to the trust store on the firewall or load balancer. For instructions, see Certificate Store Integration with MicroStrategy Library.

Another possible cause is a firewall blocking key Workstation processes or subprocesses. Ensure the firewall is allowing both CefSharp.BrowserSubprocess.exe and MicroStrategyServices-win.exe.

Error: Cannot create a card in "X" environment

This error appears when an older version of the metadata is used with your environment. To resolve the error, ensure you are connected to an upgraded version of the metadata or upgrade your metadata to 2019 or above. For steps to update your metadata, see the Upgrade Guide.

Error: Cannot continue editing the card

This error appears when the number of rows on the card exceeds the report limit. By default, the maximum report limit is 100,000 for a project. You can resolve this error by using a smaller dataset or by increasing the maximum report limit to support your large dataset.

To increase the maximum report limit, perform the following steps:

  1. Open MicroStrategy Developer.
  2. Right-click your project and select Project Configuration.
  3. Go to Governing Rules > Default > Result Sets.
  4. Change the value for All other reports to -1. The value -1 indicates no limit.
  5. Click OK.

Warning: Unable to fetch cards from following environment(s)

This warning appears in the Cards section of Workstation when you try to connect a 2019 Library Server to an older Intelligence Server version. You must connect the Library Server to a 2019 or newer Intelligence Server.