IBM Support

Visualizer report Query Parser error when a Clarity user is trying to run it in Clarity or open it with Visualizer Builder

Technote (troubleshooting)


When a Clarity user is trying to open a particular report either in Clarity or in Visualizer Builder, the following error appears : "Query (11,1) Parser: The syntax for 'Select' is incorrect." This error does not allow the Clarity user to run or edit the report.


When running a particular visualizer report in Clarity or Visualizer Builder, the following error appears : Piped error : System.Exception: The control Clarity.Viz.WinForms.ControlImplementaions.NevronChartForWin has thrown and unhandled exception in the designer and has been disabled. Exception : Server was unable to process request --> Query (11,1) Parser: The syntax for 'Select' is incorrect


This issue may be caused if the user created a calculated member in Visualizer Builder but does not manage to finish it and saves the report.


Clarity 7.x, Visualizer Server and Builder 7.x

Diagnosing the problem

- log into Clarity or open Visualizer Builder

- load or open a visualizer report

- observe if the error mentioned above is displayed

Resolving the problem

- log into the Clarity application Server

- go to Clarity Systems/ClarityServer/Web/Reports

- backup and edit (using notepad) the visualizer report xml file (.cpmviz)

- check the Calculated Members tag integrity as per the example below (<CalculatedMembers>) :

<CalculatedMemberDimensionSpec Name="Scenario">

<CalculatedMemberSpec Name="Better / (Worse) to Budget">

<CalculatedMemberSpec Name="(Over) / Under Budget">


- correct the tags if needed (if they do not have all the elements above)

- save the report

- re-open the modified visualizer report in Clarity and Visualizer Builder

- observe if it is working properly

Document information

More support for: Clarity 7
Clarity Visualizer

Software version: 7.0, 7.2, 7.2.1

Operating system(s): Windows

Reference #: 1609892

Modified date: 13 November 2012