Varicent Sales Performance Management Documentation

Saved import from SQL query with comments in body throws causes error.

00192212, 00192218, 00192221, 00192223, 00192224, 00192227, 00192226, 00192230

Fixed: When running or previewing a saved import, SQL queries with comments in the body result in an error. The error message is: Incorrect syntax near ','.

Reproduction steps

  • Run an SQL query that includes comments. Example:

    select Name, Comment
--comment
from Calculation

Result: error occurs.

In this section: