Visual Analytics - No item selected error

[phopkinson]

Hi all,

I have a SAS Visual Analytics report - however when I export to a PDF I am getting a issue with one page saying that no item has been selected and it doesn't display the data at all with the object being blank. This is despite it being in the appendix tables, and the correct parameter having been set.

[Madelyn_SAS]

I'd like to gather a bit more information. Which version of SAS Visual Analytics are you using? I assume that the object is not blank at the time that you select to print. Can you please confirm that? Are there any other messages in the PDF? Can you send a screen shot of what you see for the object? What type of object is it? 

[phopkinson]

The object is not blank when I select to print, the object is a text box and bar chart - when i go to print the text says no item selected and the bar chart is blank. I can't share any screenshot I'm afraid.

[Madelyn_SAS]

With a limited amount of detail, all I can say is that this issue can occur with report objects that display data items that are calculated from a parameter. Sometimes Visual Analytics fails to query the server for the results of the indirect calculation. If you are using any release of Visual Analytics on SAS 9.4, then you can look in the SASVisualAnalyticsTransport log, typically located at 

• /SAS-configuration-directory/Lev1/Web/Logs/SASServer12_1/SASVisualAnalyticsTransport7.x.log

If it contains an error similar to the following...

Error getting QueryRunner - java.lang.Exception: Missing expression parameter value while parsing :#{pr28} (Reason : InvalidInternalState)

Then, as a workaround, you can add a data source filter that references the parameter directly. For example, if your parameter is named Region Parameter, the expression might look like this:

( 'Region Parameter'p NotMissing ) OR ( 'Region Parameter'p Missing )

This filter does not limit the number of rows returned from the query because the condition is always true. 

[phopkinson]

I'm afraid that I have already applied a data filter using this exact method and it hasn't resolved this issue at all. 

[phopkinson]

The parameter is definitely what is causing the issue here as once it is removed - the text and bar chart both display on the output.