Error during loading Epicor 10 DEMO database

Yahoo Archive
1
Well, this is a memory issue! LOL and you knew that much! 

So here's the deal. When you get this error you need to increase the "Resource Governor Settings" on you server. i would check to see the % you're using, in most cases it's 25%. If it is I would increase that amount to 50%. 

You run into this issue a lot with SQL servers. 

If you upgrade to SQL 2012 or 14 you won't have this issue. I would also consider putting the E10 on an 2012 Server instead of 2008 as well. I just say that because you get less hassles and things tend to work better, not that it can't be done. Just my 2 cents worth.

I hope that helps you!
 
Jonathan Lang
I.T Manager
Database Engineer



On Thursday, February 11, 2016 4:46 PM, "sanfranc415@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-1747904036yiv0367838543ygrp-text">
  
  
  <div></div><div><span>Hello, Group:&nbsp;</span></div><div><span><br clear="none"></span></div><div><span>This isn&#39;t the first time loading the DEMO database, and most other times it has been successful, but during the dump n load an error is generated:&nbsp;</span></div><div><span><br clear="none"></span></div><div><span>Exception thrown loading table: A timeout occurred while waiting for memory resources to execute the query in resource pool &#39;default&#39; (2). Rerun the query.</span></div><div><span><br clear="none"></span></div><div><span>Could not get the memory grant of 78432 KB because it exceeds the maximum configuration limit in workload group &#39;default&#39; (2).</span></div><div><span><br clear="none"></span></div><div><span>My configuration:&nbsp;</span></div><div><span><br clear="none"></span></div><div><span>Windows 2008 R2</span></div><div><span>SQL Server 2008 R2 (10)</span></div><div><span><br clear="none"></span></div><div><span>This error happens about 3 hours into the ImportDemoDatabase</span></div><div><span><br clear="none"></span></div><div><span>Thanks!</span></div>

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543 -- #ygrps-yiv-1747904036yiv0367838543ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mkp #ygrps-yiv-1747904036yiv0367838543hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mkp #ygrps-yiv-1747904036yiv0367838543ads {
margin-bottom:10px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mkp .ygrps-yiv-1747904036yiv0367838543ad {
padding:0 0;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mkp .ygrps-yiv-1747904036yiv0367838543ad p {
margin:0;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mkp .ygrps-yiv-1747904036yiv0367838543ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-sponsor #ygrps-yiv-1747904036yiv0367838543ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-sponsor #ygrps-yiv-1747904036yiv0367838543ygrp-lc #ygrps-yiv-1747904036yiv0367838543hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-sponsor #ygrps-yiv-1747904036yiv0367838543ygrp-lc .ygrps-yiv-1747904036yiv0367838543ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543activity span {
font-weight:700;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543activity span span {
color:#ff7900;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543activity span .ygrps-yiv-1747904036yiv0367838543underline {
text-decoration:underline;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 .ygrps-yiv-1747904036yiv0367838543attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 .ygrps-yiv-1747904036yiv0367838543attach div a {
text-decoration:none;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 .ygrps-yiv-1747904036yiv0367838543attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 .ygrps-yiv-1747904036yiv0367838543attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 .ygrps-yiv-1747904036yiv0367838543attach label a {
text-decoration:none;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 .ygrps-yiv-1747904036yiv0367838543bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 .ygrps-yiv-1747904036yiv0367838543bold a {
text-decoration:none;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 dd.ygrps-yiv-1747904036yiv0367838543last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 dd.ygrps-yiv-1747904036yiv0367838543last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 dd.ygrps-yiv-1747904036yiv0367838543last p span.ygrps-yiv-1747904036yiv0367838543yshortcuts {
margin-right:0;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 div.ygrps-yiv-1747904036yiv0367838543attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 div.ygrps-yiv-1747904036yiv0367838543attach-table {
width:400px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 div.ygrps-yiv-1747904036yiv0367838543file-title a, #ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 div.ygrps-yiv-1747904036yiv0367838543file-title a:active, #ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 div.ygrps-yiv-1747904036yiv0367838543file-title a:hover, #ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 div.ygrps-yiv-1747904036yiv0367838543file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 div.ygrps-yiv-1747904036yiv0367838543photo-title a, #ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 div.ygrps-yiv-1747904036yiv0367838543photo-title a:active, #ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 div.ygrps-yiv-1747904036yiv0367838543photo-title a:hover, #ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 div.ygrps-yiv-1747904036yiv0367838543photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 div#ygrps-yiv-1747904036yiv0367838543ygrp-mlmsg #ygrps-yiv-1747904036yiv0367838543ygrp-msg p a span.ygrps-yiv-1747904036yiv0367838543yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 .ygrps-yiv-1747904036yiv0367838543green {
color:#628c2a;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 .ygrps-yiv-1747904036yiv0367838543MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 o {
font-size:0;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543photos div {
float:left;width:72px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543reco-category {
font-size:77%;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543reco-desc {
font-size:77%;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 .ygrps-yiv-1747904036yiv0367838543replbq {
margin:4px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mlmsg select, #ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 input, #ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mlmsg pre, #ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 code {
font:115% monospace;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-mlmsg #ygrps-yiv-1747904036yiv0367838543logo {
padding-bottom:10px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-msg p#ygrps-yiv-1747904036yiv0367838543attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-reco #ygrps-yiv-1747904036yiv0367838543reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-sponsor #ygrps-yiv-1747904036yiv0367838543ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-sponsor #ygrps-yiv-1747904036yiv0367838543ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-sponsor #ygrps-yiv-1747904036yiv0367838543ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1747904036 #ygrps-yiv-1747904036yiv0367838543 #ygrps-yiv-1747904036yiv0367838543ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1747904036



2

Hello, Group: 


This isn't the first time loading the DEMO database, and most other times it has been successful, but during the dump n load an error is generated: 


Exception thrown loading table: A timeout occurred while waiting for memory resources to execute the query in resource pool 'default' (2). Rerun the query.


Could not get the memory grant of 78432 KB because it exceeds the maximum configuration limit in workload group 'default' (2).


My configuration: 


Windows 2008 R2

SQL Server 2008 R2 (10)


This error happens about 3 hours into the ImportDemoDatabase


Thanks!