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

Technote (troubleshooting)


Problem(Abstract)

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.

Symptom

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


Cause

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.

Environment

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>) :


<CalculatedMembers>
<CalculatedMemberDimensionSpec Name="Scenario">
<CalculatedMemberSpecs>

<CalculatedMemberSpec Name="Better / (Worse) to Budget">
<Formula>[Scenario].[Actual]-[Scenario].[Budget]</Formula>
</CalculatedMemberSpec>

<CalculatedMemberSpec Name="(Over) / Under Budget">
<Formula>[Scenario].[Budget]-[Scenario].[Actual]</Formula>
</CalculatedMemberSpec>

</CalculatedMemberSpecs>
</CalculatedMemberDimensionSpec>
</CalculatedMembers>

- 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

Rate this page:

(0 users)Average rating

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:

2012-11-13

Translate my page

Machine Translation

Content navigation