Page History

IDERA strives to ensure our products provide quality solutions for your SQL Server needs. The following known issues are described in this section. If you need further assistance with any issue, visit the Support Portal at idera.force.com

2.1 Known issues

Upgrade

• IDERA Dashboard upgrade for users with SQL Diagnostic Manager 10.0.2 installed.

After upgrading the IDERA Dashboard with the BI 2.1 installer, SQLDM 10.0.2 installations fail to sync new users’ permissions with the web console. This issue affects only users created in the SQLDM desktop console after the upgrade.

The suggested workaround is as follows:

• • Access the Manage Users option of the IDERA Dashboard.
  • Locate the user, assign the product (SQLDM) to the user and set the user's role (Product Administrator, Product User, or Product Guest) to match the role assigned when it was created in the SQLDM desktop console.

• SQL BI Manager 2.1 installer cannot upgrade the IDERA Dashboard in DM 9.0 installations, causing the BI Manager 2.1 installation to fail.

The suggested workarounds are as follows:

• • Upgrade SQL Diagnostic Manager to version 9.1 before install.

  • Install BI Manager 2.1 on a separate dashboard.

  • Upgrade the current dashboard to version 2.1.1 before install.

Adding BI Instances

• Adding an instance fails for instances with non-default port configuration.

After adding an instance to SQL BI Manager with the required credentials for SQL Server and WMI connections, and attempting to "Test Credentials", BI Manager fails to connect with the instance and displays the following error message:

"The following error occurred while connecting to instance XXXXX: The following system error occurred: No such host is known. , with olap-connection. This prevents the collection of SSAS Cubes, Sessions & Objects"

This is caused by the application not being able to support instances with UDP (User Defined Port) configuration.

1.5 Known issues

Upgrade

• SQL BI Manager 1.0 users must upgrade to 1.1 before attempting to upgrade to 1.5.

SQL BI Manager 1.0 users first must upgrade to SQL BM Manager 1.1 before upgrading to version 1.5.

To upgrade from SQL BI Manager 1.0 to version 1.1, follow these steps:

1. Verify that you have product administration permissions.
2. In the Repository databases screen, enter the location of the existing 1.0 database (SQL Server Instance) and existing database name (BI Database Name).
3. The installer detects a 1.0 schema and executes the migration.

To upgrade from SQL BI Manager 1.1 to version 1.5, see Install SQL Business Intelligence Manager.

1.1 Known issues

Installation

• The IDERA Dashboard installer is unable to create a login on SQL Server 2005 repository databases.

The IDERA Dashboard installer is designed to create a login for the specified service account in the SQL Server Repository database. However, this installer is occasionally unable to create a login on SQL Server 2005 Repository databases.  This results in lack of access to the IDERA Dashboard Repository.  To solve this issue, create the necessary SQL Server logins outside of the installation process:

1. Start SSMS and connect to the SQL Server 2005 Repository database.
2. Create a login in the SQL Server 2005 Repository for the service account to be used during the IDERA Dashboard installation.
3. Run the IDERA Dashboard installer.
   

Upgrade

• SQL BI Manager 1.1 requires a custom upgrade procedure.

In SQL BI Manager 1.1 migration occurs as part of the installation process and requires a custom upgrade procedure.  This limitation will be corrected in an upcoming release.

To upgrade from SQL BI Manager 1.0 to our latest version follow these steps:

1. Verify that you have product administration permissions.
2. In the Repository databases screen, enter the location of the existing 1.0 database (SQL Server Instance) and existing database name (BI Database Name).
3. The installer detects a 1.0 schema and executes the migration.

1.0 Known issues

BI services monitoring

• SQL BI Manager fails to register BI services for monitoring if a local SQL Server instance is not installed in the host machine.

In SQL BI Manager 1.0, any BI service must have a local instance of SQL Server installed to be registered for monitoring.  For machines where a BI service is running without a local SQL Server instance, installing a copy of SQL Server Express on the target machine allows those services to be monitored. This limitation will be corrected in an upcoming release.

• Anchor
  DE43380 DE43380

  The Remove option in the BI Services views removes the monitored BI service instance.

Users that want to stop monitoring a specific BI service should use “Disable Monitoring” which is accessible through the “gear” icon to the right of the service instance name in the service (SSAS, SSRS, SSIS) view.  Selecting Remove will remove the service instance and any associated monitored BI services will stop collecting data and sending alerts as a result.

Adding users

• SQL BI Manager fails to add a user if he/she lacks an account on the local SQL BI Core Repository.

SQL BI Manager is designed to add users and grant access as needed. However, users that lack an account on the local SQL BI Core Repository fail to be added as new users in the Administration tab.  Please register new users with the SQL BI Core Repository before adding them to SQL BI Manager.

• Anchor
  DE43517 DE43517

  New SQL BI Manager users may experience issues when logging into SQL BI Manager console.

Some recently added users may experience issues when login in the SQL BI Manager console regardless of their Administration or Read Only privileges, or correct Windows credentials. An incorrect user name or password message displays.  This is a result of the above requirement to register new users with the SQL BI Core Repository before adding them to SQL BI Manager.

Alerts/Data

• Anchor
  DE43247 DE43247

  Some SQL Server Reporting Services performance counters are not available for SQL Server 2008.

Windows Service First Session Requests/sec and Snapshot Updates/sec are not available for SQL Server 2008 in the SSRS performance view.

• Anchor
  DE43465 DE43465

  SQL BI Manager occasionally returns wrong CPU Usage Percent values for the SSAS, SSRS, and SSIS roll up views.

Users may find that occasionally the CPU Usage Percent values for the SSAS, SSRS, and SSIS roll up views of the main dashboard are incorrect. 

• Anchor
  DE43447 DE43447

  Cube information for SQL Server Analysis Services fails to display in the SQL Server 2008 X86 version.

SQL BI Manager is designed to display and report on database cube information for SQL Server Analysis Services. However, an issue in the SSAS Performance view results in an empty view for the x86 version of SQL Server 2008.

• The following SSAS metrics are not collected for this release:

Cache: <Inserts/sec, Evictions/sec, KB added/sec>

Processing: Rows Written/sec

Processing Aggregations: Rows Created/sec

Processing Indexes: Rows/sec

Storage Engine: Data Read from Data File

Storage Engine: Dimension Cache <lookups/sec, hits/sec>

Storage Engine: Flat Cache <lookups/sec, hits/sec>

Storage Engine: Measure Group Cache <lookups/sec, hits/sec>

Storage Engine: Calculation Cache <lookups/sec, hits/sec>

Threads: Processing Pool Job Queue Length 

• The following SSRS metrics are not collected for SQL Server 2008 in this release:

Cache Flushes/Sec

Delivers/Sec

Events/Sec

Snapshot Updates/Sec

Total App Domain Recycles

Online Help

General

• Anchor
  DE43309 DE43309

  BI Services charts in SQL BI Manager display metric data only in the 'Minutes' scale.

Charts in the SSAS, SSRS, and SSIS performance views display metric data only in the 'Minutes' scale. Scale drop down options for Hour, Day, Week, and Month are not available in this release.

• Anchor
  DE43456 DE43456

  The My Environment section of the SQL BI Manager's dashboard does not include monitored BI Service Instance information.

For this release users should be aware that the information displayed at the top right in the DASHBOARD view (UP, DOWN, CRITICAL) encompasses the total number of monitored BI Service Instances and may be different than the number of monitored servers.

• Anchor
  DE43457 DE43457

  The Disable Monitoring option in the BI Services performance views disables only a specific BI service.

For this release users should be aware that when using the option to Disable Monitoring, available in the SSAS, SSRS, and SSIS performance views, only the specific BI service is disabled. This information is reflected in MY ENVIRONMENT  under "Disabled Instances" from the DASHBOARD VIEW.

• Anchor
  DE43515 DE43515

  An option to manually refresh data is not available in all SQL BI Manager views.

SQL BI Manager is designed to collect data and set alerts every 6 minutes. Displayed data may be manually refreshed by selecting F5.

• Anchor
  DE43520 DE43520

  An option to modify the number of rows displayed is not available in the dashboard.

SQL BI Manager displays by default 10 rows in the different widget sections of the main dashboard. It is not possible to modify this value in this version.

SQL Business Intelligence Manager provides the following new features:

2.2 New features

...

2.1 New features

• Quick access to Alert details
  Alert Preview text links to the specific alert chart or information.
• Enhanced view of SSAS information
  Modified Category names in SSAS view and new metrics in SSAS categories.
• Enhanced view of SSIS information
  Drill-through capability for SSIS Activity information. SSIS Package History information added.
• Adjust columns width
  Expandable/shrinkable width of columns in lists displayed within SSAS, SSRS, and SSIS metrics.
• IDERA Dashboard 3.0
  Supports integration with IDERA Dashboard 3.0.

...

• Support for SQL Server 2008-2012 versions

IDERA SQL BI Manager 1.0 supports SQL Server versions 2008, 2008 R2, 2012, and 2014.

• Agentless BI Monitoring

IDERA SQL BI Manager 1.0 provides agentless monitoring of the health and availability of your BI environment.

• SQL Server Analysis Services Monitoring

Provides monitoring of SQL Server Analysis Services and the server they reside on including OS counters, performance counters as well as active SSAS sessions and resource utilization.  For additional information, see SSAS performance view.

• SQL Server Reporting Services Monitoring

Provides monitoring of SQL Server Reporting Services and the server they reside on including OS counters, SSRS Report Server counters, SSRS Web Server counters, and  SSRS Windows Service counters.  For additional information, see SSRS performance view.

• SQL Server Integration Services Monitoring

Provides monitoring of SQL Server Integration Services and the server they reside on including OS counters and performance counters.  For additional information, see SSIS performance view.

• Broad Visibility into SQL BI Manager

Over 140 metrics across SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Integration Services to keep you informed about the health and availability of both the service as well as the server they reside on. 

• Roll Up Dashboard

An intuitive dashboard interface allows you to quickly get a high-level overview of your BI environment and display details on BI environment issues through the drill down capability from the top level view.  For additional information, see Viewing information on the dashboard.

• Alerts View and Configurable Alerts

The Alerts view and email alerting keeps you informed on critical issues pertaining to the health and status of your BI environment. You can configure alert threshold levels according to what is suitable for your BI environment. For additional information, see Configuring alert thresholds.

• Security

...

SQL Business Intelligence Manager identifies issues within the SQL BI environment to help optimize BI service performance.  Learn more > >