Lucent Technologies Centrevu Report Designer Version 8 User Guide

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 1 Error Messages16-3
Cause:
CentreVu CMS cannot test the row search criteria while 
data collection is off.
Solution:Turn data collection on and rerun test of report design.
Message: CMS system error - Too much data retrieved - try a 
more restrictive search
Cause:Too much data was retrieved with the given row search 
criteria.
Solution:Add more conditions to the row search criteria so that 
fewer rows are retrieved.
Message: CMS system...

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 1 Error Messages16-4
Solution:
Remove the keyword MIN from the row search criteria.
Message: keyword SUM invalid in where clause.
Cause:You cannot use the keyword SUM in a row search criteria.
Solution:Remove the keyword SUM from the row search criteria.
Message: keyword SYN invalid in where clause.
Cause:You cannot use the keyword SYN in a row search criteria.
Solution:Remove the keyword SYN from the row search criteria. 

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Historical Report Error Codes16-5
Phase 2 Historical Report Error Codes16
This section contains the INFORMIX* error codes most likely to appear 
for 
CentreVu CMS historical reports. Each code includes a description of 
the error and the recommended corrective action.
These errors are reported in the following format:
INFORMIX error: 
In addition, a circumflex (^) may appear in the listed Select statement(s) 
to mark the location of...

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Historical Report Error Codes16-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...

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Historical Report Error Codes16-7
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...

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Historical Report Error Codes16-8
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:...

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Historical Report Error Codes16-9
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....

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Historical Report Error Codes16-10
1206 Description: 
Invalid day in date.
Solution: Days must be represented as the number of the day 
(01 through 31). Check the value entered in the date field.
1226 Description: Decimal or money value exceeds maximum 
precision.
Solution: Increase the precision of the DECIMAL or MONEY 
field. Error Description/Solution 

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Real-Time Report Error Codes16-11
Phase 2 Real-Time Report Error Codes16
This section contains the Real-Time Database Manager error codes. 
Each code includes a description of the error and a recommended 
solution.
These errors are reported in the following format:
CMS Database Manager error: 
In addition, a circumflex (^) appears in the listed Select statement(s) to 
mark the location of an error.
Error Description/Solution
1...

  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 2 Real-Time Report Error Codes16-12
5 Description: 
A mixture of aggregates and nonaggregates 
are being selected, and this is not allowed in real-time 
reports. (This error code can also mean mismatched types in 
comparison.)
Solution: Create two identical row search conditions, and 
apply one to the aggregate columns and one to the 
nonaggregate columns.
6 Description: Bad column in the order by clause.
Solution: Check that the column...