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

KB38411: "Out of string space" error message appears when delivering a large report in CSV or Text format in MicroStrategy Narrowcast Server 9.2.1


Community Admin

• Strategy


When delivering a large report in CSV or Text format in MicroStrategy Narrowcast Server 9.x - 10.x, an error message "Out of string space" may appear n the Delivery Engine log:

SYMPTOM:
When delivering a large report in CSV or Text format in Strategy Narrowcast Server 9.x - 10.x, the following error message appears in the Delivery Engine log:


JobType[...] ServiceID[...] ExecutionID[...] SegmentID[...] InfoObjectIndex[...] LocaleIndex[...] ObjectID[...] CastorISMLib_cRIResultManager_RetrieveResults got error: Out of string space
Finished retrieving XML for report instance in blocks. Total Number of Rows = 197027 JobLoggingID = JobType[...] ServiceID[...] ExecutionID[...] SegmentID[...] InfoObjectIndex[...] LocaleIndex[...] ObjectID[...] 
JobType[...] ServiceID[...] ExecutionID[...] SegmentID[...] InfoObjectIndex[...] LocaleIndex[...] ObjectID[...] Information source got results for Personalization[1] with MSTR7 JobID 878 with error: Out of string space

 
STEPS TO REPRODUCE:
Follow these steps to reproduce this issue with Strategy Tutorial project 10.4:

  1. Create a report with attribute Day and Item on the row, and add any 14 metrics under Sales Metrics folder on the column.
  2. Create a report filter on attribute year in list of 2014 and 2015.
  3. Run the report and notice that the row count is around 197K with 14 columns.
  4. Create a Narrowcast service with this report sending as plaintext attachment, choosing MSTR7ToText-CSV as the XSL stylesheet from Document Element.
  5. Run the service and notice that "Out of string space" error is encountered. The delivery is not successful due to the error.
  6. Copy the same report and filter on Month for only January through March 2015.
  7. Run the report and notice that there are around 24K row count with 14 columns.
  8. Create a service based on this new report and run it.
  9. Notice that there are no errors shown up and the report is saved to file successfully. 

 
CAUSE:
This issue occurs due to a Visual Basic limitation.
 
WORKAROUND:
One workaround would be to use Distribution Services to deliver the large report.
 


Comment

0 comments

Details

Knowledge Article

Published:

April 4, 2017

Last Updated:

April 4, 2017