Completing Your Custom Report
CentreVu CMS Custom Reports
Test Design Error Messages
5-17
—309
Description: ORDER BY database item must be included
in a report field to which the row search ID is assigned.
Solution: Check that database items included in the
ORDER BY clause appear in the report and are assigned to
row search ID.
—324
Description: Ambiguous database item.
Solution: A database item in your row search criteria exists
in more than one table also cited in your row search criteria.
Prepend each database item with the appropriate table
name.
—352
Description: Database item not found.
Solution: Check the spelling of the database item.
—367
Description: Sums and averages cannot be computed for
character columns.
Solution: Check that you have not included a database
item of a string type (VDN, LOGID, etc.) in the aggregate
function statement.
—522
Description: A database item in a field/bar does not exist in
the table specified in the field’s row search ID.
Solution: Check the Select statement that has the error.
The database item that does not exist in the table will be
marked with a circumflex (^). Change or delete the
database item or change the table in the field’s row search
ID.
—809
Description: RDSQL syntax error has occurred.
Solution: Check that you have not misspelled an RDSQL
statement, placed key words out of sequence, or included
an
INFORMIX SQL reserved word in your query.
—1202
Description: An attempt was made to divide by zero.
Solution: Check that you are not attempting to divide a
numerical column type by a character column type (for
example.
16/Jones
) or that the value of the divisor does
not equal zero.
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: ......