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

KB217890: Error message "fail to get group-by section root node for multi-layout document" displays when using bursting to send out files for a document with more than one layout in MicroStrategy Analytics Enterprise Distribution Services


Community Admin

• Strategy


A prerequisite for bursting of multi-layout documents is the selected bursting attribute must be on all layouts.

SYMPTOM:
Error message "fail to get group-by section root node for multi-layout document" displays when using bursting to send out files for a document with more than one layout in Strategy Analytics Enterprise Distribution Services.
STEPS TO REPRODUCE:

ka04W000000OebCQAS_0EM4400000029FS.jpeg
ka04W000000OebCQAS_0EM4400000029FP.jpeg
  • Create a report with attribute “Year” and “Quarter”, and a metric “Cost”.
  • Create a document based on the report. Add a layout in the document so now it has two layouts. Add a text in Layout 2.
ka04W000000OebCQAS_0EM4400000029FR.jpeg
  • Add attribute “Year” to the group-by part in the first layout.
  • Create a file subscription and add “Year” in the bursting part. Enable the notification email.
ka04W000000OebCQAS_0EM4400000029FT.jpeg
  • After clicking “OK”, user would see the export confirmation message and an email claiming the file was delivered successfully.
  • But when checking the file folder, there is no file generated. And below can be seen from DSSErrors.log:

Spoiler (Highlight to read)
2014-10-30 01:16:08.308-08:00 [HOST:xxxxxx][PID:2596][THR:2104][Distribution Service][Error] hIsCurrentBurstElementsValid: group-by element is element all, skip slicing
2014-10-30 01:16:08.339-08:00 [HOST:xxxxxx][PID:2596][THR:2104][Distribution Service][Error] fail to get groupby section root node for multi-layout document
2014-10-30 01:16:08.355-08:00 [HOST:xxxxxx][PID:2596][THR:2104][Distribution Service][Error] fail to get groupby section root node for multi-layout document
2014-10-30 01:16:08.854-08:00 [HOST:xxxxxx][PID:2596][THR:2104][Distribution Service][Error] fail to get groupby section root node for multi-layout document
2014-10-30 01:16:08.308-08:00 [HOST:xxxxxx][PID:2596][THR:2104][Distribution Service][Error] hIsCurrentBurstElementsValid: group-by element is element all, skip slicing2014-10-30 01:16:08.339-08:00 [HOST:xxxxxx][PID:2596][THR:2104][Distribution Service][Error] fail to get groupby section root node for multi-layout document2014-10-30 01:16:08.355-08:00 [HOST:xxxxxx][PID:2596][THR:2104][Distribution Service][Error] fail to get groupby section root node for multi-layout document2014-10-30 01:16:08.854-08:00 [HOST:xxxxxx][PID:2596][THR:2104][Distribution Service][Error] fail to get groupby section root node for multi-layout document
 
CAUSE:
A prerequisite for bursting of multi-layout documents is the selected bursting attribute must be on all layouts.
ACTION:
Put the bursting attribute on all layouts. In the example above, add attribute “Year” on Layout 2.
 


Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

June 8, 2017