Lucent Technologies CentreVu Report Designer, User Manual

Page: 210 / 266

Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Real-Time Report Error Codes
16-12
5 Description: 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.)
Solution: Create two identical row search conditions, and
apply one to the aggregate columns and one to the
nonaggregate columns.
6 Description: Bad column in the order by clause.
Solution: Check 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 Description: Bad index in order by clause.
Solution: Order by clause has to 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.
Error Description/Solution