Troubleshooting guide

218 Avaya CMS Supervisor Report Designer
Phase 1 error messages
This section contains information about Phase 1 error messages.
The following table lists the phase 1 error messages alphabetically, and includes a cause
and a recommended solution for each message.
Message Cause Solution
$<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.