Specifications

Chapter 6: Programming
Tests and Error Messages
Mitel
®
5000 Installation Manual – Issue 3.0, October 2008 Page 6-19
Referential Integrity
This test checks to make sure that the relationships between tables in the database are valid.
For a summary of possible error messages, see Table 6-9.
Table 6-9. DB Test and Repair Error Messages for Referential Integrity
Error Message Indication
Invalid table <table name> or Invalid
source table <table name>
This is only a warning. It indicates that it was
looking for a table, but could not find it in the
database. This can happen if a new table is added
in a later version of a major release. If the test is
being run on the older version, this warning will
appear. For example, if Table A was added in
version 1.1, running this test on databases previous
to version 1.1 will produce a warning that Table A
could not be found.
Invalid column <table name>:<column
name> or Invalid source column <table
name>:<column name>
This is only a warning. It indicates that it was
looking for a column, but could not find it in the
database. This can happen if a new column is
added in a later version of a major release. If the
test is being run on the older version, this warning
will appear. For example, if Column A was added in
version 1.1, running this test on databases previous
to version 1.1 will produce a warning that Column A
could not be found.
<table name>/<column_name>
contains an invalid reference to
<source table name>/<source column
name> [<invalid reference>]
The indicated value contains an invalid reference to
another table or column.
<table name>/<column name> contains
a reference to a device of the wrong
type [DevID:<device ID>, Type:<device
type>]
The indicated value contains a reference to a device
that is not the proper type. For example, if the
System Administrator Mailbox field contains a
reference to an endpoint it is invalid, because the
System Administrator Mailbox can only be a
mailbox.
<table name>/<column name> contains
a reference to a module of the wrong
type [BoardID:<module ID>,
Type:<module type>]
The indicated value contains a reference to a
module that is not the proper type. For example,
LSM-2 records are connected to a module record
for a SLM-4 module.