Completing Your Custom Report
CentreVu CMS Custom Reports
Test Design Error Messages
5-16
—280
Description: Total size of ORDER BY columns exceeds
120 bytes.
Solution: Reduce the number of columns included in the
ORDER BY clause so that the total number of characters is
less than or equal to 120 (perhaps delete a CHAR column
of 30 or more characters).
—282
Description: Found a quote for which there is no matching
quote.
Solution: Check that all quoted strings are properly
terminated with a quote.
—284
Description: A subquery has not returned exactly one
value.
Solution: Check data for the subquery. Restructure the
subquery by adding more components in the WHERE
clause so that only one value is returned.
—297
Description: The SELECT list may not contain a subquery.
Solution: Remove the subquery from the SELECT list in
the statement.
—300
Description: There are too many GROUP BY columns
(maximum is eight).
Solution: Reduce to eight or less the number of
nonaggregate database items that are assigned the same
row search ID as that assigned to an aggregate function.
—301
Description: The total size of the GROUP BY columns
exceeds 120 characters.
Solution: The total number of characters in all columns
listed in the GROUP BY list exceeds 120 characters.
Reduce the number of nonaggregate database items that
are assigned to a row search ID that is also assigned to an
aggregate function.
—303
Description: Expression mixes columns with aggregates.
Solution: Restructure your query so that columns and
aggregates are not included in the same expression.
Table 5-2: Phase 2 Historical 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: ......