Lucent Technologies CentreVu Report Designer, User Manual

Page: 204 / 266

Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Historical Report Error Codes
16-6
Solution: Check the spelling of the table name in your
statement.
217 Description: Column column-name not found in any table in
the query.
Solution: Correct the spelling of the database item and ensure
that the item exists in the database table. Check for the
presence of required commas and quotes.
219 Description: Wildcard matching may not be used with
noncharacter types.
Solution: Wildcards (*, ?) and characters enclosed in brackets
[ ] can be used only with CHAR data types. Check the data
type for the offending column.
220 Description: There is no ”FROM” clause in the query.
Solution: Must include a “FROM” clause in the query. Check
that you do not have an illegal character ($, #, &, and so on, or
a CONTROL character) in the line prior to the FROM keyword.
223 Description: Duplicate table name
table-name in the FROM
clause.
Solution: Remove the redundant table name from the
statement or use an alias to rename one of the tables.
228 Description: cannot have negative characters.
Solution: Check that you have not included a negative CHAR
data type (for example,
-a or -p
) in your statement.
278 Description: Too many ORDER BY columns; maximum is
eight.
Solution: Reduce the number of columns included in the
ORDER BY clause to eight or less.
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.
Error Description/Solution