This version of NetIQ Analysis Center provides enhancements and software fixes. Many of these improvements were made in direct response to suggestions from our customers. We thank you for your time and valuable input. We hope you continue to help us ensure our products meet all your needs. You can post feedback in the Analysis Center Forum on Qmunity, our community Web site that also includes product notifications, blogs, and product user groups.
For more information about this release and for the latest release notes, see the Analysis Center Documentation Web site. To download this product, see the NetIQ Analysis Center Product Support page.
The following sections outline the enhancements provided in this release:
NetIQ Analysis Center 2.9 supports the following operating systems and database:
Windows Server 2012
Windows 8
SQL Server 2012
For more information, see System Requirements
in the NetIQ Analysis Center User Guide.
NetIQ Analysis Center 2.9 provides cluster support for the following databases:
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
NetIQ Analysis Center 2.9 provides software fixes for the following issues:
Issue: When you clear archive tables in QDB, a huge amount of data is transferred from archive tables to Datamart. If there is a huge amount of unprocessed data in Datamart, AC ETL job step 16 does not work.(ENG329788)
Fix: Analysis Center now processes smaller chunks of unprocessed data.
Issue: The following error is displayed in the Analysis Center Enterprise tab: Internet Information Services [Cannot open service controller]. This error occurs when the Report Server is configured with port number in Tools>Options>Reporting Services, which makes the Report Server status “Red”.(ENG330428)
Fix: Port number is now ignored while accessing the Report Server from the console, and this shows the correct status of the Report Server.
For information about hardware requirements, supported operating systems and browsers, and other software requirements, see System Requirements
in the NetIQ Analysis Center User Guide.
To install Analysis Center 2.9, see Installing Analysis Center
in the NetIQ Analysis Center User Guide.
You can upgrade to Analysis Center 2.9 from Analysis Center 2.7.5 or later. To upgrade to Analysis Center 2.9, see Upgrading to Analysis Center 2.9
in the NetIQ Analysis Center User Guide.
NetIQ Corporation strives to ensure our products provide quality solutions for your enterprise software needs. The following issues are currently being researched. If you need further assistance with any issue, please contact Technical Support.
Analysis Center components require user credentials in the domain\user format. During installation of the Analysis Center Web Service, if you provide a fully qualified domain name for the Web service account in the domain.com\user format, installation displays an error message.
When you upgrade Analysis Center, if the SQL Analysis Services, MSSQLServerOLAPService, is running using the user@domain.com format, the upgrade program displays an error message.
To resolve these errors, provide the domain name in the domain\user format for these accounts.
The DBSizeVerification tool helps estimate disk requirements for AppManager repositories that you want to use with Analysis Center. This tool is installed with the Data Warehouse, in the Utilities\ACPreCheckUtility folder where you installed Analysis Center, and it needs to reside on the host where you are running it. To run it on a host other than the Data Warehouse host, copy the ACPreCheckUtility folder to that host.
If you install the Web Service component on Windows Server 2003 and you enable the NtfsDisable8dot3NameCreation registry setting, the setup program displays the following error: Cannot open C:\DOCUME~1\svc_dra\Local Settings\Temp\{83600-xxx-xxx-etc}\WebSites.txt. To resolve this, disable the NtfsDisable8dot3NameCreation registry setting and use the 8.3 naming convention to create the TEMP folder for the installing user's profile. To apply this change, reboot the target computer before you run the setup program.
For more information about disabling this setting, see the section “Disabling Automatic 8.3 Name Generation” in the following Microsoft TechNet article: http://technet.microsoft.com/en-us/library/cc875836.aspx.
If you install Analysis Center on Windows Server 2008, and you use a valid domain administrator user account, you still do not have permissions to manage the Analysis Center Console.
To resolve this issue:
In the location where the Analysis Center Console is installed, right click NQConsole.exe and select Run as Administrator.
Go to File > Manage Security.
Select the domain user from Accounts and click Modify.
Select Administrator and click Modify.
Close the Analysis Center Console.
Restart the Console without using the Run as Administrator option.
NOTE:You might need to use the Run as Administrator option to deploy reports to SQL Server Reporting Services.
If you upgrade your system to SQL Server Reporting Services (SSRS) 2008, and you deploy a report that you had previously created using the System Uptime Pie Chart template, SSRS displays a solid black chart in the report. To display the report correctly, create the report again using the System Uptime Pie Chart template and redeploy it.
After migrating to a system running Analysis Center 2.8, Analysis Center does not retain some links to dashboard reports. To correct this, remove the links that do not work and add the reports to the dashboard again.
To fix broken links in a dashboard:
Open the dashboard in the Analysis Center console.
In the Properties pane, go to DashItems and click Edit.
In the Configure Dashboard Members dialog box, select the report that is no longer linked in the dashboard. The Members list displays the report ID, and the Report value in the Attributes list is blank.
Click Remove to delete the report from the Members list.
Click Add to add a new item called [No Report Assigned] to the Members list.
In the Attributes list, go to Report and click Edit.
In the Pick Report dialog box, select the correct report and click OK.
In the Configure Dashboard Members dialog box, reconfigure any attributes and contexts for the newly added report and click OK.
Click Execute Report to execute the dashboard and display all its reports correctly.
Click Save.
If you have more than one Data Source and then upgrade to Analysis Center 2.9, the Create Data Mart job fails on Step 1 for one of the Data Sources, and records the error “Deadlocked on lock resources” in the log file. To correct this, run the failed Create Data Mart job manually, for each Data Source, one at a time.
Jobs that generate data streams on Logical Servers, which were loaded into AC 2.7.5 or later, need to be re-deployed in AC 2.9; else, the data will be associated with machine level objects and not Logical Servers.
After upgrading Analysis Center to 2.9, to get the correct data in SSRS, you need to redeploy reports you created and deployed in Analysis Center 2.7.5 or later for QDB 8.2 objects (servers selected from the application view).
In a generated report, if Analysis Center displays a red cross instead of a chart or table, or is unable to display a chart that it had displayed previously, restart the Analysis Center Console.
The w3wp.exe process consumes 100% CPU and high memory in the following situations:
Reports have data older than one year
You run this report after setting the interval time as Minute or Hour and select several metrics
The report takes a longer time to run than expected or finishes with an error message
Confirm that you selected valid parameters for the report, and check whether the report has to process several data points.
Analysis Center displays duplicate values in the y-axis of Analysis Center reports. To view the y-axis values correctly, perform the following steps to modify the numeric format of the report:
Log in to Analysis Center console.
In the Navigation pane, select a report in the Report folder.
In the Report Properties tab, select Display > NumericFormat.
Modify the value in the NumericFormat field to F4 or greater.
Run the report.
If you install Analysis Center in a distributed environment, Analysis Center installs the files required to export reports on the Data Warehouse computer, not on the Console computer.
To enable exporting reports, copy the following files from the bin folder on the Data Warehouse computer (typically C:\Program Files\NetIQ\Analysis Center\bin) to the console folder on the Console computer (typically in path C:\Program Files\NetIQ\Analysis Center\console):
XMLCheckIn.exe
XMLCheckIn.exe.config
XMLCheckInLib.dll
Win32Security.dll
If you install Console and Data Warehouse components on the same computer, these files are located in the correct folder.
The SortExpression property, which indicates the column name and sort direction of a column, is not effective for Date/Time-based reports, such as Server Event Over Time.
Setting y-axis labels to percentage values in the System Uptime reports can be misleading because these reports display the value 1 for up and 0 for down. In addition, changing the NumericFormat to P5 (percentages with five decimal places) causes the table to display incorrect values.
If you discover that any Drill-Down reports contain broken links, use the following instructions to restore the links manually.
To restore a link to a sub-report manually:
In the Reports tree, select the Drill-Down report that contains the broken link. Select Properties.
In the Display section, click Edit next to Column Rules.
In the Column Rules dialog box, select a column in the Members pane and click Remove.
Click Add and scroll to the Attributes section.
In the Source box, select a column name.
In the Links section, click the Edit button (...) next to Cell, and in the Pick Report dialog box select the sub-report with the broken link in the Drill-Down report.
In the Pick Report dialog box, click OK.
Repeat steps 4 through 8 for each broken link in the Drill-Down report.
In the Column Rules dialog box, click OK.
Click Report > Save Report.
The Drill Down functionality does not work for reports on Logical Server objects. It only works for reports on the Machine.
If you log in to Analysis Center Console without administrator privileges, you cannot deploy reports to SSRS or view reports in SSRS. To resolve this, follow these instructions to create a new role in SSRS that has permission to view and deploy the reports.
To add a user or group to an item role:
Start Report Manager or click Home to go to the Report Manager start page.
Select Properties>Security.
Click New Role Assignment.
In the Group or User Name field, enter a Windows domain user or group account in this format: domain\account. If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment.
Select the role definitions that describe how the user or group should access the report, and click OK. The Security page displays the newly created account in the Group or User list, along with its role. To create assignments for additional users or groups, repeat steps 4 through 6.
From the Analysis Center Console, redeploy the report and confirm that it deploys successfully in SSRS.
For more information about granting users access to Report Manager, see the Microsoft article: http://msdn.microsoft.com/en-us/library/ms156034.aspx.
For backward compatibility, Microsoft still supports an undocumented user authentication methodology called Password Pass-Through. Although it might be possible to configure Analysis Center to work in environments with this connection methodology, NetIQ Corporation cannot verify that Analysis Center will work correctly in these environments.
To prevent the corruption of data while it is being copied from an AppManager repository to a Data Mart, the collation settings of the Data Mart SQL Server must match the collation settings of the corresponding AppManager repository SQL Server.
If you installed Analysis Center and AppManager on the same computer in the following order: Analysis Center first, followed by AppManager, AppManager Control Center, or AppAnalyzer components, you need to restart the computer before removing any Analysis Center components.
If you do not restart the computer first, removing Analysis Center components deletes the registry keys for AppManager, AppManager Control Center, and AppAnalyzer, which causes those applications to be inoperable.
If you create a Data Mart on a SQL Server Failover Cluster and then select the Data Sources Node or the related individual Data Source in the Analysis Center Console, Analysis Center might display the following error: MSDTC on server 'VSQL' is unavailable. This error occurs when the Virtual SQL Server comes online before the Distributed Transaction Coordinator service has started.
To resolve this issue, use the Cluster Administrator Console to take the Virtual SQL Server group offline, and then bring it back online.
You might get an error on the SQL Server Reporting Service (SSRS) icon when you select the Enterprise node in Analysis Center if the Data Extension and SSRS are installed on a computer whose IIS server implements the Secure Sockets Layer.
Verify that the correct Reporting Services URL is configured in the Options dialog box in Analysis Center.
To verify the URL:
Open the Analysis Center Console.
Select Tools > Options and click Reporting Services.
In the Default Report Server Location field, make sure that the URL for the Report Server begins with https instead of http.
If you have multiple instances of the Analysis Center Console open, and make changes to the security settings for a node from one Console, those changes are not reflected in the other open instances of the Console. Changes take effect the next time an instance of the Console is started.
For example:
User A is logged in to Console 1. User B is logged in to Console 2. Both have permission to view the Reports node.
User A changes the security settings for the Reports node to deny visibility to User B.
The new Reports node permissions for User B do not take effect in Console 2. User B can still view the Reports node.
The next time User B logs in to the Console, the new Reports node permissions take effect. User B cannot view the Reports node.
On any Windows Server 2003 or Windows Server 2008 computer hosting an Analysis Center-related SQL Server or Analysis Services server, you must configure MSDTC for network access, or the Console freezes when you select a Data Source that references the SQL or Analysis Services server on that computer. Use the following sets of instructions to configure MSDTC for network access on Windows Server 2003 and Windows Server 2008 computers.
To configure MSDTC for network access on Windows Server 2003:
Click Start > Programs > Administrative Tools > Component Services.
Expand Component Services > Computers. Right-click My Computer and click Properties.
Click the MSDTC tab and click Security Configuration.
Select the Network DTC Access check box.
Click OK to close the Security Configuration dialog box, and click OK to close the My Computer Properties dialog box.
Reboot the computer to apply the changes.
To configure MSDTC for network access on Windows Server 2008:
Click Start > Programs > Administrative Tools > Component Services.
Expand Component Services > Computers > My Computer > Distributed Transaction Coordinator. Right-click Local DTC and click Properties.
Click the Security tab and select the Network DTC Access check box.
Click OK to close the Local DTC Properties dialog box. Changes take effect immediately.
If the account under which you are running the setup program contains a double-byte character (such as Japanese, Chinese, or Korean), you need to change the environment variable for that account to point to a Temp folder that does not contain any double-byte characters in either the folder name or in the path to the folder.
Typically, the environment variable for an account defines the Temp folder location as %USERPROFILE%\Local Settings\Temp. %USERPROFILE% contains the account user name. You can change the variable value to something like C:\ACInstallTemp for the purposes of running the setup program, and then change it back to its original value when the setup program is finished.
If you are using data from an AppManager repository installed on a computer using the Japanese locale (Windows Regional Options), the corresponding Data Mart computer must also use the Japanese locale. In addition, the system language settings for the Analysis Center Console computer must be set to include Japanese.
Our goal is to provide documentation that meets your needs. If you have suggestions for improvements, please email Documentation-Feedback@netiq.com. We value your input and look forward to hearing from you.
For detailed contact information, see the Support Contact Information Web site.
For general corporate and product information, see the NetIQ Corporate Web site.
For interactive conversations with your peers and NetIQ experts, become an active member of Qmunity, our community Web site that offers product forums, product notifications, blogs, and product user groups.
THIS DOCUMENT AND THE SOFTWARE DESCRIBED IN THIS DOCUMENT ARE FURNISHED UNDER AND ARE SUBJECT TO THE TERMS OF A LICENSE AGREEMENT OR A NON-DISCLOSURE AGREEMENT. EXCEPT AS EXPRESSLY SET FORTH IN SUCH LICENSE AGREEMENT OR NON-DISCLOSURE AGREEMENT, NETIQ CORPORATION PROVIDES THIS DOCUMENT AND THE SOFTWARE DESCRIBED IN THIS DOCUMENT "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. SOME STATES DO NOT ALLOW DISCLAIMERS OF EXPRESS OR IMPLIED WARRANTIES IN CERTAIN TRANSACTIONS; THEREFORE, THIS STATEMENT MAY NOT APPLY TO YOU.
For purposes of clarity, any module, adapter or other similar material (“Module”) is licensed under the terms and conditions of the End User License Agreement for the applicable version of the NetIQ product or software to which it relates or interoperates with, and by accessing, copying or using a Module you agree to be bound by such terms. If you do not agree to the terms of the End User License Agreement you are not authorized to use, access or copy a Module and you must destroy all copies of the Module and contact NetIQ for further instructions.
This document and the software described in this document may not be lent, sold, or given away without the prior written permission of NetIQ Corporation, except as otherwise permitted by law. Except as expressly set forth in such license agreement or non-disclosure agreement, no part of this document or the software described in this document may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, or otherwise, without the prior written consent of NetIQ Corporation. Some companies, names, and data in this document are used for illustration purposes and may not represent real companies, individuals, or data.
This document could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein. These changes may be incorporated in new editions of this document. NetIQ Corporation may make improvements in or changes to the software described in this document at any time.
U.S. Government Restricted Rights: If the software and documentation are being acquired by or on behalf of the U.S. Government or by a U.S. Government prime contractor or subcontractor (at any tier), in accordance with 48 C.F.R. 227.7202-4 (for Department of Defense (DOD) acquisitions) and 48 C.F.R. 2.101 and 12.212 (for non-DOD acquisitions), the government's rights in the software and documentation, including its rights to use, modify, reproduce, release, perform, display or disclose the software or documentation, will be subject in all respects to the commercial license rights and restrictions provided in the license agreement.
© 2013 NetIQ Corporation and its affiliates. All Rights Reserved.
For information about NetIQ trademarks, see http://www.netiq.com/company/legal/.