Microsoft KB Archive/274206

= Commerce Server SQL Server-Based Dynamic Reports Use a Lot of Memory =

Article ID: 274206

Article Last Modified on 12/8/2003

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition
 * Microsoft Commerce Server 2000 Standard Edition
 * Microsoft BizTalk Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q274206



SYMPTOMS
When you try to run a dynamic report in Commerce Server, you may experience memory errors or blank dynamic reports.



CAUSE
When you run a SQL Server-based dynamic report, the PivotControl tries to load all data into memory before displaying the report. This could cause system resources to become depleted, especially memory. This depletion can result in system errors or the report not being displayed.



WORKAROUND
Verify that you run Commerce Server dynamic reports on a system that does not have limited system resources, particularly memory. Also, avoid running reports on computers that are running other memory-intensive programs (such as a mail server or a database server).

Additional query words: plutonium

Keywords: kbprb kbpending KB274206

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.