x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 5 replies
  • Subscribers 105 subscribers
  • Views 5478 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
92
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
962
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
MoiraG

Out of Memory Error Generating a Sage Intelligence Report

SOLVED
Posted By

Get an out of memory error running a Sage Intelligence report off AR History detail created in the Connector.  This would generate a Pivot Table.  I have it filtered to limit to a date range, for example one month.  While the detail would be 251,000 rows with 12 columns, the report 'chokes' and up pops the out of memory error before it completes the process.  This is being run on the server, Excel ver 2013, plenty of memory.  As suggested in MS KB articles, I cleared all data/formats from the rows below and to the left of the data set on Sheet 1, still get this error.  We haven't exceeded the Excel row/column limit.  Any ideas what to try next?

tia

Parents Reply Children
  • 0 in reply to Doc102208
    Thank you for that suggestion, however we need both regular items and miscellaneous charge items. There are no comment lines in the AR_HistoryDetail, so even eliminating that would not have an effect. Since yesterday, I have set the pivot table to options to prevent drill-down to details and hid data details on the report, hoping that would have some effect. It didn't I still get the out of memory error.
  • 0 in reply to MoiraG
    To get both the Items & Misc Charge items use the filter ItemType Is In 1,5.

    How many years of AR Invoice History to you retain?

    If you want you can export your report and email it to me and I can check it out?

    My email is: [email protected]
  • 0 in reply to Doc102208
    verified answer
    Sorry for the long wait on a reply but here is what I did to work around the out of memory issue.

    Using SI connector I created a new connection for AR Invoice History Header and Detail with a SQL join. That solved the issue as the SQL join was more efficient than a graphical join.

*Community Hub is the new name for Sage City