Lucent Technologies CentreVu Report Designer, Руководство пользователя

Страница: 200 / 266

Error Messages CentreVu Report Designer Version 8 User Guide
Phase 1 Error Messages
16-2
Phase 1 Error Messages
16
This section contains Phase 1 error messages. The following table lists
the messages alphabetically, and includes a cause and a recommended
solution for each message.
Message: $<variable name> not defined
Cause: The WHERE clause contains a variable that is not
defined.
Solution: Define the variable using the define input action or
remove the variable from the row search criteria.
Message: Cannot mix aggregates and nonaggregates in the
select
Cause: You cannot specify both aggregate columns and
nonaggregate columns in the same select for real-time
reports.
Solution: Create two identical row search conditions and apply one
to the aggregate columns and one to the nonaggregate
columns.
Message: Cannot use the SYN function for order by
Cause: You cannot use a synonym to sort the output in the query.
Solution: Remove the aggregate from the
Order by
field. Use
grid sorting to order the item.
Message: CMS system error - Check the error log
Cause: A CentreVu
®
CMS system error occurred while the select
executed. The error should be recorded in the error log.
Solution: Check the error in the error log to initiate corrective action.
If you run a report that merges data from two tables
(particularly tables with large amounts of data) into a
single field and your
Select rows where
statement is
not specific enough, you may get this error message. The
specific cause may be that the number of selected rows is
very large, and
CentreVu CMS does not have enough
space to create temporary files. If this is the case, you
should add additional “where” clauses to the row search
criteria.
Message: CMS system error - Data collection off