9.05.702 - BAQ Report to Crystal - 'System.OutOfMemoryExcept

But that doesn't explain why I can run it in developer and not the viewer. It just means the 64 bit viewer can work. I did work around the issues by changing my BAQ to do more filtering which reduced the XML file size, so now the 32 bit crystal viewer can handle it.  

Patrick 

On Dec 2, 2013, at 3:01 AM, "ross.hughes3@..." <ross.hughes3@...> wrote:

 

<div id="ygrps-yiv-803373698ygrp-text">
  
  
  <p></p><p>Hi Patrick,</p><p>&nbsp;</p><p>I am not sure it is a&nbsp;Crystal viewer issue.&nbsp; I had the&nbsp;same issue getting details from the Journal Tracker.&nbsp; </p><p>&nbsp;</p><p>The only way I can get the thing to&nbsp;return the records was to call the mfgsys64.exe file instead of&nbsp;the mfgsys.exe file.&nbsp; Of course, you have to run it in a 64-bit environment.</p><p>&nbsp;</p><p>This solved the immediate problem but I am&nbsp;sure this will impact external assemblies in customizations if they do not support 64-bit.</p><p>&nbsp;</p><p>Ross<var id="ygrps-yiv-803373698yui-ie-cursor"></var></p><p>&nbsp;</p> <div class="ygrps-yiv-803373698ygroups-quoted"><br><br>---In <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>, &lt;vic.drecchio@...&gt; wrote:<br><br><div id="ygrps-yiv-803373698ygrps-yiv-171714001"><div class="ygrps-yiv-803373698ygrps-yiv-171714001WordSection1"><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;">Ah, well yes, that does seem like a PITA.&nbsp; Have you tried another runtime version?&nbsp; Perhaps give that a shot on your test PC.</span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;"> &nbsp;</span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;">I think most runtime releases are here:</span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;"> &nbsp;</span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;"><a rel="nofollow" target="_blank" href="http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=56787567">http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=56787567</a></span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;"> &nbsp;</span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;"> &nbsp;</span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;"> &nbsp;</span></p><div><div style="border-width:1pt medium medium;border-style:solid none none;border-color:rgb(181, 196, 223) currentColor currentColor;"><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><b><span style="font-size:10pt;">From:</span></b><span style="font-size:10pt;"> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> [<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">mailto:vantage@yahoogroups.com</a>] <b>On Behalf Of </b>Winter, Patrick<br><b>Sent:</b> Tuesday, October 01, 2013 3:14 PM<br><b>To:</b> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a><br><b>Subject:</b> RE: [Vantage] 9.05.702 - BAQ Report to Crystal - &#39;System.OutOfMemoryException&#39;</span></p></div></div><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"> &nbsp;</p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal">&nbsp; </p><div id="ygrps-yiv-803373698ygrps-yiv-171714001ygrp-mlmsg"><div id="ygrps-yiv-803373698ygrps-yiv-171714001ygrp-msg"><div id="ygrps-yiv-803373698ygrps-yiv-171714001ygrp-text"><div><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:rgb(31, 73, 125);font-size:11pt;">It’s a Crystal Viewer thing, I have Crystal Runtime 2010 SP3, Crystal Developer 2008 SP4. </span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:rgb(31, 73, 125);font-size:11pt;">Can’t print and view I get the “System.OutOfMemeoryException” do to parsing I’m told by support.</span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:rgb(31, 73, 125);font-size:11pt;">If I print from Crystal Developer it works Great. </span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:rgb(31, 73, 125);font-size:11pt;">&nbsp;</span></p><div><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><b><span style="color:rgb(31, 73, 125);font-size:11pt;">Patrick Winter</span></b></p></div><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:rgb(31, 73, 125);font-size:11pt;">&nbsp;</span></p><div><div style="border-width:1pt medium medium;border-style:solid none none;border-color:rgb(181, 196, 223) currentColor currentColor;"><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><b><span style="font-size:10pt;">From:</span></b><span style="font-size:10pt;"> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> [<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">mailto:vantage@yahoogroups.com</a>] <b>On Behalf Of </b>Vic Drecchio<br><b>Sent:</b> Tuesday, October 01, 2013 13:55<br><b>To:</b> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a><br><b>Subject:</b> RE: [Vantage] 9.05.702 - BAQ Report to Crystal - &#39;System.OutOfMemoryException&#39;</span></p></div></div><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal">&nbsp;</p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal">&nbsp; </p><div id="ygrps-yiv-803373698ygrps-yiv-171714001ygrp-mlmsg"><div id="ygrps-yiv-803373698ygrps-yiv-171714001ygrp-msg"><div id="ygrps-yiv-803373698ygrps-yiv-171714001ygrp-text"><div><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;">Is this a report that you could dump the results to XML via the BAQ Export Process?&nbsp; I have many reports in excess of that record-count that I do the same thing that you’re doing.&nbsp; I may dump the data nightly as these historical trend/analysis reports are fine with a static dataset from last night.&nbsp; </span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;">&nbsp;</span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;">Or, if you have SQL, go SQL ODBC for this report.</span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;">&nbsp;</span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;">Is this bug a E9 thing?&nbsp; I’m also very certain I have BAQ--&gt; Crystal reports exceeding a simple 41,000 records……&nbsp; I’m on 8.03.4xx.</span></p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:blue;">&nbsp;</span></p><div><div style="border-width:1pt medium medium;border-style:solid none none;border-color:rgb(181, 196, 223) currentColor currentColor;"><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><b><span style="font-size:10pt;">From:</span></b><span style="font-size:10pt;"> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> [<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">mailto:vantage@yahoogroups.com</a>] <b>On Behalf Of </b>Winter, Patrick<br><b>Sent:</b> Tuesday, October 01, 2013 2:15 PM<br><b>To:</b> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a><br><b>Subject:</b> [Vantage] 9.05.702 - BAQ Report to Crystal - &#39;System.OutOfMemoryException&#39;</span></p></div></div><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal">&nbsp;</p><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal">&nbsp; </p><div id="ygrps-yiv-803373698ygrps-yiv-171714001ygrp-mlmsg"><div id="ygrps-yiv-803373698ygrps-yiv-171714001ygrp-msg"><div id="ygrps-yiv-803373698ygrps-yiv-171714001ygrp-text"><p>All,</p><p>Simple request a 3 column sales analysis report, three years of invoices, 41000 records.</p><p>(One of the oldest reports known to Data Processing)</p><p><b>Since Epicor 9 has a (Crystal Viewer / .net / XML) allocation memory block limitation</b></p><p><b>in parsing data a BAQ to XML to Crystal doesn’t work.</b></p><p>Any workaround, fixes, ideas, etc…</p><p>Tech Support says&nbsp; it’s a known limitation, you will have to process less data as in not run it </p><p>for 3 years. (They are funny guys….)</p><p>I have stripped the BAQ as much as possible, no character description fields X(1000), etc…</p><p>What is the best alternative to creating reports where you actually have </p><p>to process 40,000 or more records of records with multiple subtotals etc…?</p><p><b>Patrick Winter</b></p></div></div></div></div></div></div></div></div></div><div><p class="ygrps-yiv-803373698ygrps-yiv-171714001MsoNormal"><span style="color:white;"></span></p></div></div></div></div></div></div><p></p>

</div>
9.05.702 - BAQ Report to Crystal - 'System.OutOfMemoryException'

All,

Simple request a 3 column sales analysis report, three years of invoices, 41000 records.

(One of the oldest reports known to Data Processing)

Since Epicor 9 has a (Crystal Viewer / .net / XML) allocation memory block limitation

in parsing data a BAQ to XML to Crystal doesn’t work.

Any workaround, fixes, ideas, etc…

Tech Support says  it’s a known limitation, you will have to process less data as in not run it

for 3 years. (They are funny guys….)

I have stripped the BAQ as much as possible, no character description fields X(1000), etc…

What is the best alternative to creating reports where you actually have

to process 40,000 or more records of records with multiple subtotals etc…?

Patrick Winter

Is this a report that you could dump the results to XML via the BAQ Export Process?  I have many reports in excess of that record-count that I do the same thing that you’re doing.  I may dump the data nightly as these historical trend/analysis reports are fine with a static dataset from last night. 

 

Or, if you have SQL, go SQL ODBC for this report.

 

Is this bug a E9 thing?  I’m also very certain I have BAQ--> Crystal reports exceeding a simple 41,000 records……  I’m on 8.03.4xx.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, October 01, 2013 2:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 9.05.702 - BAQ Report to Crystal - 'System.OutOfMemoryException'

 

 

All,

Simple request a 3 column sales analysis report, three years of invoices, 41000 records.

(One of the oldest reports known to Data Processing)

Since Epicor 9 has a (Crystal Viewer / .net / XML) allocation memory block limitation

in parsing data a BAQ to XML to Crystal doesn’t work.

Any workaround, fixes, ideas, etc…

Tech Support says  it’s a known limitation, you will have to process less data as in not run it

for 3 years. (They are funny guys….)

I have stripped the BAQ as much as possible, no character description fields X(1000), etc…

What is the best alternative to creating reports where you actually have

to process 40,000 or more records of records with multiple subtotals etc…?

Patrick Winter

It’s a Crystal Viewer thing, I have Crystal Runtime 2010 SP3, Crystal Developer 2008 SP4.

Can’t print and view I get the “System.OutOfMemeoryException” do to parsing I’m told by support.

If I print from Crystal Developer it works Great.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Tuesday, October 01, 2013 13:55
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 9.05.702 - BAQ Report to Crystal - 'System.OutOfMemoryException'

 

 

Is this a report that you could dump the results to XML via the BAQ Export Process?  I have many reports in excess of that record-count that I do the same thing that you’re doing.  I may dump the data nightly as these historical trend/analysis reports are fine with a static dataset from last night. 

 

Or, if you have SQL, go SQL ODBC for this report.

 

Is this bug a E9 thing?  I’m also very certain I have BAQ--> Crystal reports exceeding a simple 41,000 records……  I’m on 8.03.4xx.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, October 01, 2013 2:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 9.05.702 - BAQ Report to Crystal - 'System.OutOfMemoryException'

 

 

All,

Simple request a 3 column sales analysis report, three years of invoices, 41000 records.

(One of the oldest reports known to Data Processing)

Since Epicor 9 has a (Crystal Viewer / .net / XML) allocation memory block limitation

in parsing data a BAQ to XML to Crystal doesn’t work.

Any workaround, fixes, ideas, etc…

Tech Support says  it’s a known limitation, you will have to process less data as in not run it

for 3 years. (They are funny guys….)

I have stripped the BAQ as much as possible, no character description fields X(1000), etc…

What is the best alternative to creating reports where you actually have

to process 40,000 or more records of records with multiple subtotals etc…?

Patrick Winter

Ah, well yes, that does seem like a PITA.  Have you tried another runtime version?  Perhaps give that a shot on your test PC.

 

I think most runtime releases are here:

 

http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=56787567

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, October 01, 2013 3:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 9.05.702 - BAQ Report to Crystal - 'System.OutOfMemoryException'

 

 

It’s a Crystal Viewer thing, I have Crystal Runtime 2010 SP3, Crystal Developer 2008 SP4.

Can’t print and view I get the “System.OutOfMemeoryException” do to parsing I’m told by support.

If I print from Crystal Developer it works Great.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Tuesday, October 01, 2013 13:55
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 9.05.702 - BAQ Report to Crystal - 'System.OutOfMemoryException'

 

 

Is this a report that you could dump the results to XML via the BAQ Export Process?  I have many reports in excess of that record-count that I do the same thing that you’re doing.  I may dump the data nightly as these historical trend/analysis reports are fine with a static dataset from last night. 

 

Or, if you have SQL, go SQL ODBC for this report.

 

Is this bug a E9 thing?  I’m also very certain I have BAQ--> Crystal reports exceeding a simple 41,000 records……  I’m on 8.03.4xx.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, October 01, 2013 2:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 9.05.702 - BAQ Report to Crystal - 'System.OutOfMemoryException'

 

 

All,

Simple request a 3 column sales analysis report, three years of invoices, 41000 records.

(One of the oldest reports known to Data Processing)

Since Epicor 9 has a (Crystal Viewer / .net / XML) allocation memory block limitation

in parsing data a BAQ to XML to Crystal doesn’t work.

Any workaround, fixes, ideas, etc…

Tech Support says  it’s a known limitation, you will have to process less data as in not run it

for 3 years. (They are funny guys….)

I have stripped the BAQ as much as possible, no character description fields X(1000), etc…

What is the best alternative to creating reports where you actually have

to process 40,000 or more records of records with multiple subtotals etc…?

Patrick Winter

Hi Patrick,

 

I am not sure it is a Crystal viewer issue.  I had the same issue getting details from the Journal Tracker. 

 

The only way I can get the thing to return the records was to call the mfgsys64.exe file instead of the mfgsys.exe file.  Of course, you have to run it in a 64-bit environment.

 

This solved the immediate problem but I am sure this will impact external assemblies in customizations if they do not support 64-bit.

 

Ross

 



---In vantage@yahoogroups.com, <vic.drecchio@...> wrote:

Ah, well yes, that does seem like a PITA.  Have you tried another runtime version?  Perhaps give that a shot on your test PC.

 

I think most runtime releases are here:

 

http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=56787567

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, October 01, 2013 3:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 9.05.702 - BAQ Report to Crystal - 'System.OutOfMemoryException'

 

 

It’s a Crystal Viewer thing, I have Crystal Runtime 2010 SP3, Crystal Developer 2008 SP4.

Can’t print and view I get the “System.OutOfMemeoryException” do to parsing I’m told by support.

If I print from Crystal Developer it works Great.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Tuesday, October 01, 2013 13:55
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 9.05.702 - BAQ Report to Crystal - 'System.OutOfMemoryException'

 

 

Is this a report that you could dump the results to XML via the BAQ Export Process?  I have many reports in excess of that record-count that I do the same thing that you’re doing.  I may dump the data nightly as these historical trend/analysis reports are fine with a static dataset from last night. 

 

Or, if you have SQL, go SQL ODBC for this report.

 

Is this bug a E9 thing?  I’m also very certain I have BAQ--> Crystal reports exceeding a simple 41,000 records……  I’m on 8.03.4xx.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Tuesday, October 01, 2013 2:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 9.05.702 - BAQ Report to Crystal - 'System.OutOfMemoryException'

 

 

All,

Simple request a 3 column sales analysis report, three years of invoices, 41000 records.

(One of the oldest reports known to Data Processing)

Since Epicor 9 has a (Crystal Viewer / .net / XML) allocation memory block limitation

in parsing data a BAQ to XML to Crystal doesn’t work.

Any workaround, fixes, ideas, etc…

Tech Support says  it’s a known limitation, you will have to process less data as in not run it

for 3 years. (They are funny guys….)

I have stripped the BAQ as much as possible, no character description fields X(1000), etc…

What is the best alternative to creating reports where you actually have

to process 40,000 or more records of records with multiple subtotals etc…?

Patrick Winter