Completing Your Custom Report
CentreVu CMS Custom Reports
Running Custom Reports
5-20
Running Custom Reports
5
You run custom reports using steps similar to steps you use to run standard
reports. However, you run custom reports from the
Custom Reports
Main
Menu option. Also, the Report Input window shows input fields you defined
on the Define Input window for the report. For real-time reports, the Report
Input window also automatically shows a
Refresh rate in seconds
—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.
—12
Description: Memory allocation error.
Solution: Check the error logs.
—13
Description: Query cannot select more than one table.
Solution: Check the error logs.
Table 5-3: Phase 2 Real-Time Error Codes —
Continued
Summary of Contents for CentreVu
Page 16: ...Preface CentreVu CMS R3V5 Custom Reports Related Documents P 10 ...
Page 44: ...Getting Started CentreVu CMS Custom Reports Deleting a Custom Report 2 10 ...
Page 140: ...Completing Your Custom Report CentreVu CMS Custom Reports Running Custom Reports 5 22 ...
Page 178: ...Database Items and Calculations CentreVu CMS Custom Reports General Information A 2 ...
Page 188: ...Glossary CentreVu CMS Custom Reports GL 10 ...
Page 198: ......