OLAP job failing at Step -[060] Execute Regular Cube Process DTS Package (NETIQKB46160)

  • 7746160
  • 02-Feb-2007
  • 28-Feb-2011

Environment

NetIQ Analysis Center 2.x
Microsoft SQL Analysis Center (OLAP Processing) Job

Situation

Error [NetIQETL] ETL FAILED Interface [{10020207-EB1C-11CF-AE6E-00AA004A34D5}] Error Code [8004006b] Source [Microsoft Data Transformation Services (DTS) Package]

Error [NetIQETL] ETL FAILED Interface [{10020207-EB1C-11CF-AE6E-00AA004A34D5}] Error Code [8004006b] Source [Microsoft Data Transformation Services (DTS) Package] Error Message [Invalid aspect(s)(AMGeneric3_20041001 (80004005): The aggregations of partition 'AMGeneric3_20041001' have been changed (the aggregations are different).)]

Error [NetIQETL] FAILED Step [STEP_41_1_CUBEPARTITION] Execution Time [13.39] Process [AMGeneric3_20041001] Partition: Process [AMGeneric3_20041001] Partition

Resolution

You can attempt to manually process your Analysis Center partitions and\or Analysis Center Cubes through the SQL Analysis Manager.

  1. Go to Start | Programs | Microsoft SQL Server | Analysis Services | Analysis Manager
  2. Expand through the AC_OLAP| Cubes
  3. Right-click the Cubes folder and select Process All Cubes
  4. If this process fails, please capture a screenshot of the resulting error and forward the information to Technical Support with this KB article number

Another cause of this issue is an Access database size limitation of 1 gig.  Please contact NetIQ Technical Support and reference this KB or NETIQKB46284 for more details.

Cause

These errors are the result of a failed partition which is preventing OLAP Processing.

Additional Information

Formerly known as NETIQKB46160