Troubleshooting guide

222 Avaya CMS Supervisor Report Designer
300 There are too many GROUP BY
columns (maximum is eight).
Reduce to eight or fewer the number of nonaggregate
database items that are assigned the same row search
ID as that assigned to an aggregate function.
301 The total size of the GROUP BY
columns exceeds 120 characters.
The total number of characters in all columns listed in
the GROUP BY list exceeds 120 characters. Reduce
the number of nonaccredited database items that are
assigned to a row search ID that is also assigned to an
aggregate function.
303 Expression mixes columns with
aggregates.
Restructure your query so that columns and
aggregates are not included in the same expression.
309 ORDER BY database item must be
included in a report field to which
the row search ID is assigned.
Verify that database items included in the ORDER BY
clause appear in the report and are assigned to row
search ID.
324 Ambiguous database item. A database item in your row search criteria exists in
more than one table also cited in your row search
criteria. Precede each database item with the
appropriate table name.
352 Database item not found. Verify the spelling of the database item.
367 Sums and averages cannot be
computed for character columns.
Verify that you have not included a database item of a
string type (VDN, LOGID, and so on) in the aggregate
function statement.
522 A database item in a field/bar does
not exist in the table specified in the
field’s row search ID.
Verify the Select statement that has the error. The
database item that does not exist in the table will be
marked with a circumflex (^). Change or delete the
database item or change the table in the field’s row
search ID.
809 RDSQL syntax error has occurred. Verify that you have not misspelled an RDSQL
statement, placed key words out of sequence, or
included an SQL reserved word in your query.
1202 An attempt was made to divide by
zero.
Verify that you are not attempting to divide a numerical
column type by a character column type (for example,
16/Jones). Also verify that the value of the divisor does
not equal zero.
1203 Values used in a MATCH must both
be type CHARACTER.
Verify that the values included in your MATCH
condition are both CHAR types. Use an alternate
comparison condition for non CHAR types.
1204 Invalid year in date. Acceptable years are 0001 to 9999. If two digits are
used, RDSQL assumes that the year is 19xx. Verify the
value entered in the date field.
Error Description Solution