EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB10973: “Error while retrieving the Registry Value \HKEY_LOCAL_MACHINE\SOFTWARE\MicroStrategy\MicroStrategy Broadcast Server\7.0\ExecutionEngine\QRAChunkSize.” appears when the ISM Level Trace is enabled in MicroStrategy Narrowcast Server 8.x.


Community Admin

• Strategy


SYMPTOM:
The following message appears in the DELog/System Messages when the Information Source Module (ISM) Level Trace is enabled:
CAUSE:
This message is not a service execution error, but a message indicating that the QRAChunkSize has not been defined. The QRAChunkSize setting controls the size of the XML sent to the Document Formatting Module (DFM). If the QRAChunkSize has not been defined, then Strategy Narrowcast Server defaults to 1000 rows.
Defining the QRAChunkSize setting is not required in most scenarios and should be changed only when appropriate. An example of a scenario of when and why the QRAChunkSize setting should be enabled is discussed in the following Strategy Knowledge Base document:

  • KB6200-751-1107
    - After 2,000 rows, the formatting of data types in cells from a Strategy Narrowcast Server 8.0.0 document switches from an integer number form to a percentage.

ACTION:
To enable the QRAChunkSize setting so the message no longer appears, users should follow the steps below:
Note: There may be a cost with regards to performance when using larger sizes. On clustered Execution Engines, the change should be made on each Execution Engine machine.

  • Open the Registry (regedit).
  • Navigate to the following location:
  • Add DWord QRAChunkSize.
  • Set the chunksize value to the default value of 1000 rows. Ensure that the value is set as a decimal:
ka04W000000OgovQAC_0EM440000002BnF.jpeg
  • Ensure that the Information Source is set to 'Refresh immediately' for this to take effect.

Registry Modification:
Modifying registry values incorrectly may cause serious, system-wide problems that may require the re-installation of Microsoft Windows NT. Any edit of the registry is done at the user's own risk. Since these are user-initiated changes, they are not covered by any Strategy warranty. If using Microsoft Windows NT, the user should backup the registry and/or update an Emergency Repair Disk (ERD) prior to alterations.


Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

June 8, 2017