Troubleshooting guide

February 2006 225
5 A mixture of aggregates and
nonaggregates are being
selected, and this is not allowed
in real-time reports. (This error
code can also mean
mismatched types in
comparison.)
Create two identical row search conditions, and apply one
to the aggregate columns and one to the nonaccredited
columns.
6 Bad column in the order by
clause.
Verify that the column name in the order by clause is
spelled correctly and that it is being selected by one of the
fields included in this row search.
7 Bad index in order by clause. Verify that the order by clause has a column in the
SELECT clause or a number that indicates a position of
the column in the select clause.
8 Bad argument given to an
aggregate function. For
example, you cannot take the
SUM or AVG of a character
column.
Verify the arguments for the aggregates and be sure that
data type is appropriate.
9 In the Select of one of the fields
associated with this row search,
an action is being performed
with the wrong data types. For
example, you cannot use
arithmetic with character fields.
Verify for these types of errors in the fields associated with
the row search.
10 Error with subquery There may be a subquery in the WHERE clause that CMS
does not support. Verify the subqueries. This typically
happens with an Agent Group report (a SELECT
embedded within a SELECT).
11 Avaya CMS system error Verify the error logs.
12 Memory allocation error Verify the error logs.
13 Query cannot select more than
one table.
Verify the error logs.
Error Description Solution