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
Summary of Contents for CentreVu Report Designer
Page 4: ......
Page 18: ...Introduction CentreVu Report Designer Version 8 User Guide Related Documents 1 8...
Page 102: ...Edit Inputs CentreVu Report Designer Version 8 User Guide Viewing the Input Window 6 16...
Page 198: ...Format Text CentreVu Report Designer Version 8 User Guide Formatting Text on the Report 15 4...
Page 264: ...Index CentreVu CMS R3V8 Upgrades and Migration IN 10...
Page 266: ......
