Analysis Center ETL job fails on Step 3 (NETIQKB71882)

  • 7771882
  • 20-Oct-2009
  • 05-Nov-2010

Environment

NetIQ Analysis Center 2.7 SP1

Situation

ETL Processing Job Filtering Unnecessary Data

ETL Processing Job Failing in Step 3

Performance of the OLAP Processing Job

OLAP Failure in Step 9

Resolution

Hotfix 71882 for Analysis Center 2.7 SP1 has been superceded by Hotfix 72012.  Please go to the following link:

https://www.netiq.com/f/downloads/download.asp?id=D525EE56-1E89-4C9A-AF07-1EAE9F8CC177

Why Install This Hotfix?

This hotfix resolves the following issues with Analysis Center 2.7 Service Pack 1.

  • Resolves Issues With the ETL Processing Job Filtering Unnecessary Data
  • Resolves Issues With the ETL Processing Job Failing in Step 3
  • Resolves Issue With the Performance of the OLAP Processing Job
  • Resolves Issue With OLAP Failure in Step 9
  • Resolves Issue With Aggregation on Partitions
  • Resolves Issue With Rendering Values for the Time Context "Yesterday"
  • Resolves Issue With the Number of Reported Event Occurrences
  • Resolves Issue With Displaying Metrics and Knowledge Scripts in the Console
  • Resolves Issues With Drill-Down Reports
  • Resolves Issue With Grooming Data

Resolves Issue With the ETL Processing Job Filtering Unnecessary Data

Before you apply this hotfix, the ETL processing job might filter and process unnecessary data in a table. After you apply this hotfix, the ETL processing job only picks up required rows. (ENG262020, ENG263015)

Resolves Issue With the ETL Processing Job Failing in Step 3

With this hotfix, the ETL processing job no longer fails in step 3 if you delete all jobs or remove some Knowledge Scripts from the AppManager repository (QDB). (ENG275915, ENG263080)

Resolves Issue With the Performance of the OLAP Processing Job

This hotfix improves OLAP job processing efficiency by processing dimensions and cubes separately. (ENG273015)

Resolves Issue With OLAP Failure in Step 9

This hotfix corrects an issue that could cause the OLAP processing job to fail in step 9. (ENG262823)

Resolves Issue With Aggregation on Partitions

This hotfix modifies the parameters for creating partitions so that Analysis Center creates new partitions with an aggregation percentage of 65% and an estimated row count of 50 million. These settings could improve performance when running reports. To apply these aggregation settings to existing partitions, contact NetIQ Technical Support. (ENG264861, ENG264952)

Resolves Issue With Rendering Values for the Time Context "Yesterday"

Before you apply this hotfix, Analysis Center renders incorrect values for the time context "Yesterday" or for a custom time range in which the start and end dates are the same. After you apply this hotfix, Analysis Center displays these values correctly. (ENG270920)

Resolves Issue With the Number of Reported Event Occurrences

Before you apply this hotfix, event reports do not always reflect the correct number of event occurrences. After you apply this hotfix, Analysis Center calculates the correct number of occurrences from the time you apply the hotfix. Any event report whose date range begins after the date you apply the hotfix displays the correct number of event occurrences. (ENG250737)

Resolves Issue With Displaying Metrics and Knowledge Scripts in the Console

Before you apply this hotfix, you might be able to see some Metrics and Knowledge Scripts in the Report Wizard, but not in the Console. After you apply this hotfix, Analysis Center displays those Metrics and Knowledge Scripts in both the Report Wizard and the Console. (ENG265045, ENG279423)

Resolves Issues With Drill-Down Reports

Before you apply this hotfix, when using the Report Wizard to create Drill-Down reports, the link to the sub-report might not work. In addition, the links might not work after you import Drill-Down reports from Analysis Center 2.6 into Analysis Center 2.7, or if you upgrade from version 2.6 to 2.7. After you apply this hotfix, Analysis Center fixes the broken links associated with Drill-Down reports in these situations. (ENG262549, ENG246567, ENG250133)

Resolves Issue With Grooming Data

Before you apply this hotfix, Analysis Center might not delete all data objects according to the grooming value you set for the Data Mart. After you apply this hotfix, Analysis Center deletes all data objects correctly and frees the physical space. (ENG279028)

System Requirements

This hotfix requires NetIQ Analysis Center 2.7 Service Pack 1.

Installing This Hotfix

Complete the following steps to install this hotfix. Ensure that you close the Console before running the hotfix on the Console component.

To install this hotfix:

  1. Using an account with administrative privileges, log on to the computer on which you want to install the hotfix.
  2. Run the AC27SP1_HotFix71882_Setup.exe file.
  3. Follow the wizard instructions.
  4. Repeat Steps 1 through 3 on each computer on which Analysis Center components are installed.

Modified Files

This hotfix modifies the following files:

Assemblies

  • NQACLib.dll (Build Number 2.7.436.0)
  • NQOLAP.dll (Build Number 2.7.436.0)
  • NQACReport.dll (Build Number 2.7.436.0)
  • XmlCheckInLib.dll (Build Number 2.7.436.0)

AC_Configuration SQL Files

  • isp_REPGetTemplateName.sql (Build Number 2.7.436.0)
  • isp_GetCubeProcessXMLA.sql (Build Number 2.7.436.0)

AC_Warehouse SQL Files

  • isp_GetViewMetrics.sql (Build Number 2.7.436.0)
  • isp_UpdateViewFact.sql (Build Number 2.7.436.0)
  • fnc_fGetKSList.sql (Build Number 2.7.436.0)

Data Mart SQL Files

  • isp_GetNewMetricData.sql (Build Number 2.7.436.0)
  • isp_GetNewData.sql (Build Number 2.7.436.0)
  • isp_GroomFactData.sql (Build Number 2.7.436.0)

XSL Configuration Files

  • template.AMExtractFactData.XSL (Build Number 2.7.436.0)
  • template.AMExtractDimensionData.XSL (Build Number 2.7.436.0)
  • AppManager.PreCheckDataSource.XSL (Build Number 2.7.436.0)
  • AppManager.StartDataSource.XSL (Build Number 2.7.436.0)

Cause

Multiple known issues in Analysis Center 2.7 SP1

Additional Information

Formerly known as NETIQKB71882