SAP Knowledge Base Article - Public

1218195 - Connecting to large memo fields in ADO recordsets uses all computer's memory

Symptom

A Crystal Report is connected to an ADO recordset that contains a very large memo field. Refreshing a report with such a large memo field causes the computer to run out of memory.

Cause

The issue has been identified and logged under Problem Report ID ADAPT00353670.

Resolution

Hot Fixes or Service Packs address this issue as indicated below. With the update(s), a registry subkey has been introduced to limit the number of pages kept in memory. This resolves the issue. This subkey must be edited to take advantage of the hot fix. Instructions for editing the subkey are found below.

Unless indicated otherwise, Weekly Hot Fix updates from the FTP site have only been tested with English versions of our products.

====================

CAUTION:

Hot Fixes and Service Packs are not designed for OEM versions. Do not apply these updates if you are using an OEM version. To determine if you are using an OEM version, refer to the OEM Product Warning.

====================

Crystal Enterprise 10 for Windows

---------------------------------------

For Crystal Enterprise 10 for Windows, the latest update for this issue is available on the Downloads area of our website.

This issue is addressed in the following components (and later versions):

  • crpe32.dll, version 10.0.5.870, dated 11/18/2004
  • crpe32.pdb, dated 11/18/2004
  • crpe32_res_en.dll, version 10.0.5.870, dated 11/18/2004

Crystal Reports 10

---------------------

For Crystal Reports 10 for Windows, the latest update for this issue is available on the Downloads area of our website.

This issue is addressed in the following components (and later versions):

  • crpe32.dll, version 10.0.5.870, dated 11/18/2004
  • crpe32.pdb, dated 11/18/2004
  • crpe32_res_en.dll, version 10.0.5.870, dated 11/18/2004
  • crw32.exe, version 10.0.5.870, dated 11/18/2004
  • crw32_res_en.dll, version 10.0.5.870, dated 11/18/2004

Edit the Subkey

----------------

1. Click Start > Run. Type "regedit" in the Run dialog box. Click OK.

2. Browse to the following registry subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\10.0\Crystal Reports\FormatOptions

3. Right-click the ThinningOutPageStartInfo String Value. Click Modify.

4. Change the value in the 'Value Data' text box to "Yes". Click OK.

====================

IMPORTANT:

This registry subkey value should be set to "Yes" only if the your reports have the issue detailed above, otherwise the value must be kept as "No".

====================

Monthly Hot Fixes and Service Packs

------------------------------------------

To determine if this issue is also addressed in a Monthly Hot Fix or Service Pack for your Crystal product, search the readme file for the Track ID number (that is, ADAPTXXXXXXXX) in the latest Monthly Hot Fix or Service Pack.

Monthly Hot Fix and Service Pack readmes for Crystal products are found on the Downloads area of our website.

====================

NOTE:

Issues addressed on one operating system platform at the Weekly Hot Fix level may be addressed later on multiple operating system platforms (if applicable) at the Monthly Hot Fix and Service Packs level. For example, an issue only resolved on the Windows platform in a Weekly Hot Fix may be resolved later on UNIX platforms such as IBM AIX and Sun Solaris in future Monthly Hot Fixes or Service Packs for these platforms.

To determine if these issues are resolved in a Monthly Hot Fix or Service Pack on another platform, search for the Track ID number in the readme at the locations indicated above.

See Also

For more information on the issues addressed in the Hot Fix or Service Pack, view the readme PDF or text file included in the ZIP or TAR file.

For more information on the different update types, refer to our Hot Fix and Service Pack FAQ.

Keywords

CR CE WHF 353670 ADO RECORD SET SETS MEMO FIELD LARGE HUGE OUT OF MEMORY Crystal Reports ADO recordsets Large memo fields , c2016978 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports 10.0