Completing your custom report
128 Avaya CMS Custom Reports
—7
Description: Bad index in order by clause.
Solution: Order by clause must have a column in the “select”
clause or a number that indicates a position of the column in the
“select” clause.
—8
Description: Bad argument given to an aggregate function. For
example, you cannot take the SUM or AVG of a character column.
Solution: Check the arguments for the aggregates and be sure
that data type is appropriate.
—9
Description: 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.
Solution: Check for these types of errors in the fields associated
with the row search.
—10
Description: Error with subquery.
Solution: There may be a subquery in the “where” clause that
CMS does not support. Check the subqueries. This typically
happens with an Agent Group report (a “select” embedded within
a “select”).
—11
Description: CMS system error.
Solution: Check the error logs.
—12
Description: Memory allocation error.
Solution: Check the error logs.
—13
Description: Query cannot select more than one table.
Solution: Check the error logs.
