Troubleshooting Out Of Memory error in Anlaysis Server

原创 2006年05月17日 01:21:00

This article discusses how to categorize the cause of and troubleshoot the following error in application event log of Analysis Server. For example:

Event Type:   Error
Event Source:       MSSQLServerOLAPService
Event Category:    Server
Event ID:       123
Date:             3/28/2006
Time:             9:49:33 AM
User:             N/A
Computer:      <Computer Name>
Description:
The server is out of memory.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Sometimes you also will see the additional error as below:

Event Type:   Error
Event Source:       MSSQLServerOLAPService
Event Category:    Server
Event ID:       117
Date:             2006-5-3
Time:             4:11:23
User:             N/A
Computer:      <Computer Name>
Description:
Unexpected fatal error occurred.  Attempting to restart server.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Analysis Services load all dimensions for all databases into volatile memory on startup. During processing, the server consumes additional memory to process updates to dimensions and cubes. If insufficient memory is available for these and other operations, you will receive this message. When this error occurred, it only indicates there is memory pressure at that time. Analysis Service will trigger background process to release memory generally. If this error did not induce the analysis service restart, we can simply ignore this message.

You can resolve this issue in several ways menteiond in the following article:
Error 123
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_as_errors_3s6s.asp

In Analysis Service 2005 (SSAS), we also will see similiar error like this during process operation.
Memory Error: The operation cannot be completed because the memory quota estimate (xxxMB) exceeds the available system memory (xxxMB)

Before Cube processing, SSAS will estimate the required memory size and does memory quota limit check, if the available memory is not enough, the error will occur. To resolve such issue, you can follow the suggestions in the above artile in Analysis Service 2000.

Also, there is a known issue as below
914595 FIX: Dimension processing may fail, and you may receive an error message in SQL Server 2005 Analysis Services
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914595

To work around this problem, we can override the memory quota limit check by setting MemoryLimitErrorEnabled=0 in the config file (msmdsrv.ini): MemoryLimitErrorEnabled=0. After disable the memory quota limit check, SSAS will do the memory check before process so that we will not encoutner this error again.

To troubleshoot such issue we need collect following information:

1. Confirm whether the OOF error is related to MDX query or Process operation.
2. The Anlaysis Service database size, need check the size of the database folders, which are under c:/Program Files/Microsoft Analysis Services/Data.
3. Whether SQL and Analysis Server running on the same box.
4. What is the version of the file msmdsrv.exe, which is under C:/Program Files/Microsoft Analysis Services/Bin by default.
5. Open the Regedit utility, export the values under the
“HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/OLAP Server” sub-tree into a file and get them for further analysis.
6. Collect performance log
7. If the OOF error is related to process log, we need processing log for detailed checking.
8. When the processing log and performance log is enabled, please reproduce the same error (Out of memory). Then provide the following information for research:
a. Performance log
b. processing log

Thanks and regards,
Michael

Troubleshooting Out Of Memory error in Anlaysis Server

 Troubleshooting Out Of Memory error in Anlaysis Server This article discusses how to categorize the...
  • michaelgy
  • michaelgy
  • 2007年09月10日 13:29
  • 561

编译android源码时,jack server 出现out of memory error 错误的解决方法

编译android源码时,jack server 出现out of memory error 错误的解决方法: 问题现象如下: 问题的解决方案如下,共两步: Step1:修改jack serv...
  • coder_jack
  • coder_jack
  • 2016年11月25日 09:03
  • 2816

Ubuntu14.04 Android7.0 编译 Out of memory error

1.安装openjdk 1.8 14.04的版本无法直接安装openjdk 1.8  sudo add-apt-repository ppa:openjdk-r/ppa sudo apt-get u...
  • Aaron121314
  • Aaron121314
  • 2017年05月09日 10:33
  • 527

解决:编译CM14.1 提示Jack “Out of memory error”错误

Android 7.1编译到33%时出现JDK内存溢出的错误: Out of memory error (version 1.2-rc4 'Carnac' (298900 f95d7bdecfc...
  • zhanqq2012
  • zhanqq2012
  • 2017年03月20日 02:54
  • 680

Linux Out of memory error

Out of memory error (version 1.3-b2 'Douarn' (320400 bfc75939a2e32be4feddc59d656afb274397ed65 by and...
  • dl6655
  • dl6655
  • 2017年06月06日 16:55
  • 642

Android N编译之Out of memory error

之前本地环境编译一直是正常的,后来更新代码后,出现编译不过。 提示out of memory,但是查看swap和内存都还是够的。 里面有个提示,try increasing heap size w...
  • u013398960
  • u013398960
  • 2017年07月22日 11:00
  • 1148

an out of memory error has occurred.Consult the 'running eclipse' section of the read me file for...

调一下内存,myeclipse.ini里面把 -XX:MaxPermSize=512m -XX:ReservedCodeCacheSize=128m 适当调大些。 如果是ecl...
  • Code_lr
  • Code_lr
  • 2017年05月05日 21:09
  • 1005

An out of memory error has occurred.

eclipse内存溢出错误 An out of memory error has occurred.Consult the "Running Eclipse" section of read...
  • gao_chun
  • gao_chun
  • 2014年09月02日 17:28
  • 5800

Jack-server出错:out of memory error,try increasing heap size

出现这个问题主要是因为虚拟机内存不足;下面给出两个解决方案:1.修改jack编译并行数:SERVER_NB_COMPILE; 在 根目录中的.jack文件中; 默认并行数为4,改为2;SERVER...
  • Simon_Crystin
  • Simon_Crystin
  • 2017年04月11日 22:41
  • 1369

在yolo训练的时候又去测试就会报错:cuda error: out of memory

在yolo训练的时候又去测试就会报错:cuda error: out of memory,  cuda.c  Assertion '0' failed....
  • wuzuyu365
  • wuzuyu365
  • 2016年08月31日 16:17
  • 6151
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Troubleshooting Out Of Memory error in Anlaysis Server
举报原因:
原因补充:

(最多只允许输入30个字)