Trend analysis services failed to process collected data. (NETIQKB46056)

fact
Security Manager 5.x

symptom
Trend analysis services failed to process collected data.

symptom
Error: The memory conservation threshold was exceeded

symptom
Error: Attempt to delete member that is in use

symptom
Cannot analyze the trend analysis cube.

symptom
Data processing for trend analysis hangs or locks up.

symptom
Cannot open connection to Analysis server '<Server Name>'.
Timeout occurred.

symptom
Unable to open connection.
The operation requested failed due to timeout

symptom
The memory conservation threashold was exceeded by more than 12.5 percent for an extended period.

cause
Microsoft Analysis Services has a performance bottleneck.

fix

To improve Microsoft Analysis Services performance:

NOTES:  You should upgrade to Analysis Services SP4.
              The Trend Analysis Server requires a minimum 2GB of RAM.

1. Go to folder \Program Files\Microsoft Analysis Services\Bin.
2. Rename msmdvldm.exe so that Analysis Services cannot use the file.
3. On the trend analysis central computer, click Programs> Microsoft SQL Server> Analysis Services> Analysis Manager.
4. Expand Console Root > Analysis Servers.
5. Right-click on the server name.
6. Click Properties.
7. Select the Processing tab.
8. Change Process Buffer Size to 200 MB from the default value of 32 MB.
9. Select the Environment tab.
10. Change Memory Conservation Threshold to a value between a minimum of 1024 and a maximum of, physical memory on the server minus 1024 MB, but not to exceed the following:
• If the /3GB switch is NOT set in the Windows C:\boot.ini, the maximum setting should be 1650 MB.
• If the /3GB switch IS set in the Windows C:\boot.ini, the maximum setting should be 2650 MB.
11. Change Minimum Allocation Memory to be 1024 MB.
12. Click OK.
13. Change the OLAP registry setting below as referenced from Microsoft KB823357
• Click Start, and then click Run. Type regedit, and then click OK.
• Locate the following registry key:
  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion
• In the right pane, double-click HighMemoryLimit.
• In the Edit DWORD Value dialog box, click Decimal.
• In the Value data box, type a value that is the same as the value from step 10 in bytes (i.e. if you have 1024 for step 10, then you would put in 1024x1048576 or 1073741824)
• Quit Registry Editor.
14. Restart the MSSQLServerOLAPService.

For more information about getting better performance from Analysis Services
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx.

For information about How To Enable Analysis Server to Use 3 GB of RAM
http://support.microsoft.com/kb/295443/en-us

For more information about Trend Analysis problems, see:
http://support.microsoft.com/kb/823357/en-us

note

The memory conservation threshold was exceeded

This error is caused by the HighMemoryLimit registry value not being set high enough.  See http://support.microsoft.com/kb/823357/en-us to help find a higher value to set this to.

In the Application log:
The memory conservation threshold was exceeded by more than 12.5 percent for an extended period.

note

Attempt to delete member that is in use

This is caused because msmdvldm.exe has not been renamed.

3/15/2006 8:04:45 AM:Started Cube Processing with command line parameters
3/15/2006 8:22:40 AM:Error. Processing error [Attempt to delete member that is in use] 'N/A'
3/15/2006 8:22:40 AM:Error. Incremental processing of the cube failed.

Formerly known as NETIQKB46056