NetIQ Analysis Center Version 2.7.5 Hotfix 73309 January 2012 (NETIQKB73309)

This hotfix for the NetIQ Analysis Center product (Analysis Center) resolves a specific previous issue. This document outlines why you should install this hotfix and identifies files modified by the hotfix.

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.

NetIQ Analysis Center
Version 2.7.5
Hotfix 73309
Date Published: January 2012

Installing This Hotfix
 
Before you install this hotfix, ensure that there are no administrative tasks in process, such as the pending addition or deletion of data sources.

When you install this hotfix, Analysis Center re-creates and runs the ETL processing job on each Analysis Center data source. If you previously applied Hotfix 72687, the AC_OLAP database is not created again after applying this hotfix. If you did not, Analysis Center re-creates the database and runs the OLAP processing job. You will be able to view your reports when the OLAP processing job has run successfully the first time after applying this hotfix. This will take some time, depending on the amount of data to process.

Install this hotfix on all computers with the following components:

Console
Data Extension
Data Warehouse (AC_Warehouse database installed on a computer running Microsoft SQL Server)
Web Service
Data Mart computers do not require this hotfix.

Note: If you previously applied Hotfix 72687, install this hotfix on the Data Warehouse component only.

To install this hotfix:

Using an account with administrative privileges, log on to the computer where you want to install the hotfix.
Close all Analysis Center Consoles running on this computer.
Run the AC275_HF73309.exe file.
Follow the wizard instructions.
Repeat steps 1 through 4 on each computer on which Analysis Center components are installed.

Verifying the Hotfix Installation

Complete the following steps to verify that the hotfix installation was successful.

To check the installed hotfix version:

For each computer on which Analysis Center components are installed, log on with a local administrator account.
Check the value of the following Windows Registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\NetIQ\AnalysisCenter\2.0\ProductLevel
After you install this hotfix, the value of the ProductLevel key is HF73309.

Modified Files

This hotfix modifies the following stored procedure in the AC_Configuration database:

isp_GetUserID.SQL (Build Number 2.7.691.0)

If you did not previously apply Hotfix 72687 or Hotfix 73131, this hotfix also modifies the files listed in the NetIQ Knowledge Base articles NETIQKB72687 and NETIQKB73131.

If you did not previously apply Hotfix 73251, this hotfix also modifies the file template.AMExtractDimensionData.XSL, located in the installation folder.

Known Issues
 
NetIQ Corporation strives to ensure our products provide quality solutions for your enterprise software needs. The following issue is currently being researched. If you need further assistance with any issue, please contact Technical Support.

If you did not previously apply Hotfix 72687, after you apply this hotfix you may not see all the expected data in your report when Analysis Center completes the first run of the OLAP processing job successfully. (ENG304491)

To correct this, take the following steps:

Disable all ETL and Analysis Center OLAP processing jobs.
 
Manually run the Create Data Sources Data Marts job for each data source. This starts the rebuild process of the SSIS packages and ETL processing job.
 
Once each ETL job has completed successfully, temporarily disable the jobs and ensure they are not running.
 
Manually run the Analysis Center Installation job, and wait for the OLAP processing job to finish. This might take a significant amount of time, depending on the size of your environment and the volume of data stored in each Data Mart.
 
Once the OLAP Processing job has completed successfully, enable all ETL jobs again to resume scheduled processing.
 
Verify that your Analysis Center reports contain data.

Previous Releases
 
This hotfix includes enhancements added in Hotfix 73251, Hotfix 73131, and Hotfix 72687.

Hotfix 73251, with AppManager 8.0
 
This hotfix allows NetIQ Analysis Center to filter hidden views that are created when you use the ad hoc computer list in AppManager 8.0 to populate a management group. (ENG311852)

Hotfix 73131, October 2011
 
This hotfix resolves an issue where Analysis Center does not display the new metric name in the Console when you rename a metric using the Analysis Center Administrator Utility. Before you apply this hotfix, when you rename a parent metric, Analysis Center displays the new metric name in the report, but not in the Context tree in the Console. After you apply this hotfix, the new metric name is displayed correctly in the report and the Console. (ENG307808)

Hotfix 72687, March 2011
 
This hotfix adds the following support and resolves the following issues:

Adds support for Microsoft SQL Server 2008 R2, in addition to existing support for Microsoft SQL Server 2005 and 2008.
Resolves an issue that causes an error in the Add Datasource wizard when the Data Mart is installed on Microsoft SQL Server 2008 R2. (ENG298742)
 
Resolves an issue in which Analysis Center does not collect AppManager virtual server objects as computers. Analysis Center now recognizes and loads data from virtual server objects in the Microsoft Windows OS module for AppManager. (ENG300457, ENG301891, ENG300106)
 
Optimizes account validation, which may improve the speed of working in the Analysis Center Console. (ENG294865)
 
Corrects an issue when the Analysis Center Console and the AppManager Control Center Console are installed on the same computer. If there are open Control Center Consoles on the computer, the links to those Consoles from the Analysis Center Console now work. The links are located in the Tasks pane in the Related Links section. (ENG295546)
 
Corrects an issue when using the Interval attribute of the Time context. Analysis Center now returns an interval for the Interval attribute, rather than a time range. (ENG300752)
 
Corrects an issue when you select contexts in the Analysis Center Console. The query was optimized and may increase the speed of rendering the Machine Group tree in the Console. (ENG292187)
 
Resolves an issue in which Analysis Center ignores a specified report width when you save the report and deploy it to Microsoft SQL Server Reporting Services (SSRS). In the Properties pane of the Analysis Center Console, if you specify a width value in the Comments field, and then save the report and deploy it to SSRS, Analysis Center now applies the specified width. (ENG303963)
 
Resolves an issue in which ETL Step 16 fails with the following error:
 
Exec dbo.GroomFactData @idLoad, @idETLStep failed with the following error: "Cannot drop the table 'dbo.Data_xxxxxxxx'"
Analysis Center now verifies the existence of the table, and the ETL process no longer fails on Step 16 because of this error. (ENG293888)
 
Improves the way Analysis Center recovers from ETL failures. When the ETL process is not working for more than 48 hours, Analysis Center now collects data incrementally, every 48 hours. This reduces the load for ETL Step 16 and reduces the risk of a Step 16 failure the next time you process the ETL job. This applies to new data only, not to historical data that you loaded when you set up the data source. Because data collection in this situation is incremental, you might need to allow the ETL job to run more than once to obtain all the latest data. If you need to increase or decrease the frequency of the incremental data collection, contact NetIQ Technical Support. See the Support Contact Information Web site. (ENG300768)
 
Resolves an issue in which the data table in the QDB is empty, causing Analysis Center to duplicate each data point in the table. ETL processing now handles empty data tables correctly, and no longer duplicates data points. (ENG283606)
 
Corrects an issue when scanning multiple partitions across time zones. Analysis Center now processes non-UTC partitions based on UTC time so that the data distribution is correct in the cube partitions. This also may improve performance when executing reports. (ENG282777)
 
Corrects an issue after running the Analysis Center Installation Job. Analysis Center now processes non-UTC cube partitions based on UTC time so that the OLAP processing job no longer deletes partitions unexpectedly. (ENG291634)
 
Corrects an issue that occurs if you do a manual full process of the AC_OLAP cubes. Manual processing no longer results in potential data gaps or duplicate data. (ENG283608)
 
Resolves an issue that causes the following error on OLAP Step 9:
 
Rigid relationships between attributes cannot be changed during incremental processing of a dimension.
 
Analysis Center now supports a dimension hierarchy that can be incrementally processed when it has child elements with multiple parents. (ENG286417)
 
Resolves an issue in which OLAP Step 9 fails because of invalid modification times in the QDB and aggregations. (ENG298689)

Resolves an issue in which OLAP Step 11 does not respond when there are a large number of servers and management groups. The process no longer hangs in this situation. (ENG288658)
 

Why Install This Hotfix?

This hotfix resolves an issue in which dashboard reports intermittently fail and display a deadlock error. (ENG315088)

This hotfix includes all hotfixes contained in the Previous Releases section.

Formerly known as NETIQKB73309