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

KB210762: “Unable to resolve prompts on content 'null'. Either one of the prompts has no default answer and is required, or there was an error trying to resolve prompt answers.” error appears when listing VLDB properties in Command Manager 9.4.1 and 10.x.


Community Admin

• Strategy


“Unable to resolve prompts on content 'null'. Either one of the prompts has no default answer and is required, or there was an error trying to resolve prompt answers” error appears when trying to list VLDB properties of a report in Command Manager 9.4.1 and 10.x.

SYMPTOM:
When running the Command Manager script to list VLDB properties for a report the following error may occur:

ka04W000000OfXBQA0_0EM440000002CEd.jpeg


 


Unable to resolve prompts on content 'null'. Either one of the prompts has no default answer and is required, or there was an error trying to resolve prompt answers.

 
This issue is known to occur when there are one or more prompt elements in the report that are required and do not have a default prompt answer set.
 
STEPS TO REPRODUCE:
Follow the steps to reproduce in the Strategy Tutorial Project:

  • Create a required Attribute Elements List prompt on “Year” attribute without a default answer set:
ka04W000000OfXBQA0_0EM440000002CET.jpeg

 

  • Create a simple report with “Year” attribute on the template and the prompt from step 1 in the filter.
     
  • Run Command Manager script to list VLDB properties:
    
    LIST VLDBSETTINGS FOR REPORT 'XXX' IN FOLDER 'XXX' IN PROJECT ‘XXX';


ka04W000000OfXBQA0_0EM440000002CEd.jpeg

CAUSE:
This is a known issue in Strategy Command Manager 9.4.1 and 10.x.
 
ACTION:
This issue is resolved in Strategy 10.11 and above.  It is also resolved in Strategy 10.4 Hotfix 7 and above.  Upgrade to these versions to take advantage of the fix.
 
WORKAROUND:
There are three known workarounds for this issue.
 

  1. Set (a) default prompt answer(s) for the required prompt(s) in the report.
  2. Make the required prompt(s) on the report optional.
  3. Use project documentation to list the VLDB properties for this report.

KB210762


Comment

0 comments

Details

Knowledge Article

Published:

June 1, 2017

Last Updated:

January 28, 2019