$< variable name> not defined

The WHERE clause contains a variable that is not defined.

Define the variable using the define input action or remove the variable from the row search criteria.

Cannot mix aggregates and nonaggregates in the select

You cannot specify both aggregate columns and nonaccredited columns in the same select for real-time reports.

Create two identical row search conditions and apply one to the aggregate columns and one to the nonaccredited columns.

Cannot use the SYN function for order by

You cannot use a synonym to sort the output in the query.

Remove the aggregate from the Order By field. Use grid sorting to order the item.

Avaya CMS system error - Check the error log

An Avaya Call Management System (CMS) system error occurred while the select executed. The error should be recorded in the error log.

Verify the error in the error log to initiate corrective action.

If you run a report that merges data from two tables (particularly tables with large amounts of data) into a single field and your Select rows where statement is not specific enough, you may get this error message. The specific cause may be that the number of selected rows is very large, and CMS does not have enough space to create temporary files. If this is the case, you should add additional WHERE clauses to the row search criteria.

Avaya CMS system error - Data collection off

CMS cannot test the row search criteria while data collection is off.

Turn data collection on and rerun test of report design.

Avaya CMS system error - Too much data retrieved - try a more restrictive search

Too much data was retrieved with the given row search criteria.

Add more conditions to the row search criteria so that fewer rows are retrieved.

Avaya CMS system error - Updating translations

CMS cannot test the row search criteria while CMS is receiving the set of configuration data from the Communication Manager system.

Wait until configuration data has been sent. Then rerun the test of report design.

keyword <variable> invalid in where clause

You cannot use the specified keyword in a row search criteria.

Remove the specified keyword from the row search criteria.