Quick Warning Reference

This topic lists schema and data issues found in warnings generated by the verification process.

General Issues

The following table lists general issues found in verification process warnings. Some issues are fixed automatically by the repair process. Other issues require that you repair them manually.

Type	Problem	Resolution	Details
Database	Database server version not supported	manual repair	General validation
Database	Schema name contains invalid characters	manual repair	General validation
Database	Table owner does not match the server connection method	manual repair	General validation
Database	Repository over database feature no longer supported	manual repair	Repository over Database Feature
Version control	Certain version control projects cannot be upgraded directly	manual repair	Version Control Validation
Database	Permissions	manual repair	General validation
Database	Configure text search	manual repair	General validation

Schema Issues

The following table lists schema issues found in verification process warnings. Some schema issues are fixed automatically by the repair process. Other schema issues require that you repair them manually.

Type	Problem	Resolution	Details
Table	Extra table	manual repair	Extra Table
Table	Missing table	repair process	Missing Table
Views	Extra view	manual repair	Data validation
Column	Extra column	manual repair	Extra Column
Column	Missing column	repair process	Missing Column
Column	Size mismatch - column size bigger than expected	manual repair	Column Size Mismatch
Column	Size mismatch - column size smaller than expected	repair process	Column Size Mismatch
Column	Type mismatch	manual repair	Column Type Mismatch
Column	Precision	repair process	Column Precision Mismatch
Column	Nullable - column can accept NULL values	repair process	Column Nullability Mismatch
Index	Uniqueness	repair process	Index Uniqueness Mismatch
Index	Clustered	repair process	Index Clustered
Index	Missing	repair process	Missing Index
Constraint	Missing	repair process	Missing Constraint
Constraint	Extra	manual repair	Missing Constraint
Index	Changed	repair process	Index Changed
Triggers	Extra	manual repair	Extra Trigger
Sequence	Missing	repair process	Missing Sequence
Sequence	Extra	manual repair	Extra Sequence
Sequence	Incorrect	repair process	Incorrect Sequences

Data Issues

The following table lists data issues found in the verification process warnings. Some data issues are fixed automatically by the repair process. Other data issues require that you repair them manually.

Type	Problem	Element	Resolution	Details
Duplicate data	Duplicate values	None	repair process	Data validation
Duplicate data	Duplicate IDs	None	repair process	Data validation
Trees	Wrong number of children	`Tables REQ/ALL_LISTS/CYCL_FOLD`	repair process	Data validation
Trees	Corrupted path	`Tables REQ/ALL_LISTS/CYCL_FOLD`	repair process	Data validation
Trees	Orphan records	`Tables REQ/ALL_LISTS/CYCL_FOLD`	repair process	Data validation
Sequences	Sequence mismatch	`Table SEQUENCES`	repair process	Sequences
Orphans	Missing parent entities	None	repair process	Data validation
Missing data	Missing entities	None	repair process	Data validation
Lists	Missing lists and values	Tables SYSTEM_FIELD / LISTS	repair process	Data validation