Lucent Technologies CentreVu Call Management System Custom Reports Manual

  Completing Your Custom Report CentreVu CMS Custom Reports
Test Design Error Messages5-13
Table 5-1: Phase 1 Error Messages (Contd)
Message:keyword AVG invalid in where clause
Cause:You cannot use the keyword AVG in row search criteria.
Solution:Remove the keyword AVG from the row search criteria.
Message:keyword BETWEEN invalid for real-time
Cause:You cannot use the keyword BETWEEN in row search 
criteria for a real-time report.
Solution:Remove the keyword BETWEEN from the row search 
criteria....

  Completing Your Custom Report CentreVu CMS Custom Reports
Test Design Error Messages5-14
Phase 2 
Historical 
Error Codes
5
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 an error.
*INFORMIX...

  Completing Your Custom Report CentreVu CMS Custom Reports
Test Design Error Messages5-15
—206 Description: The specified table name is not in the 
database.
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...

  Completing Your Custom Report CentreVu CMS Custom Reports
Test Design Error Messages5-16
—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.
Solution: Check that all quoted strings are properly 
terminated with a quote....

  Completing Your Custom Report CentreVu CMS Custom Reports
Test Design Error Messages5-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....

  Completing Your Custom Report CentreVu CMS Custom Reports
Test Design Error Messages5-18
—1203 Description: Values used in a MATCH must both be type 
CHARACTER.
Solution: Check that the values included in your MATCH 
condition are both CHAR types. Use an alternate 
comparison condition for nonCHAR types.
—1204 Description: Invalid year in date.
Solution: Acceptable years are 0001 to 9999. If two digits 
are used, RDSQL assumes the year is 19xx. Check the 
value entered in the date field.
—1205...

  Completing Your Custom Report CentreVu CMS Custom Reports
Test Design Error Messages5-19
Phase 2 Real-
Time Error 
Codes
5
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.
Table 5-3:  Phase 2 Real-Time Error Codes 
—1...

  Completing Your Custom Report CentreVu CMS Custom Reports
Running Custom Reports5-20
Running Custom Reports5
You run custom reports using steps similar to steps you use to run standard 
reports. However, you run custom reports from the Custom Reports Main 
Menu option. Also, the Report Input window shows input fields you defined 
on the Define Input window for the report. For real-time reports, the Report 
Input window also automatically shows a Refresh rate in seconds  —7 Description: Bad index in...

  Completing Your Custom Report CentreVu CMS Custom Reports
Running Custom Reports5-21
field. For historical reports, the Report Input window automatically shows 
report destination fields.
1.Select the Custom Reports 
Main Menu option.®
The Custom Reports submenu 
appears.
2.Select either the Real-time or 
Historical submenu option.®A submenu of custom reports, 
either real-time or historical, 
appears. The list includes all 
existing global reports and your 
private reports.
3.Select the desired...

  Completing Your Custom Report CentreVu CMS Custom Reports
Running Custom Reports5-22