Most Validation errors are caused by the following issues:
•Schema does not match
•Customized Schema
•Missing Module
If receiving validation errors, try updating the Schema on both the Source and Target Databases.
Error codes that the EQuIS Migration Tool can display are summarized below.
Error Codes
Abbreviation |
Error Code |
Example |
Error Description |
|---|---|---|---|
PK |
Primary Key Error |
CHAIN_OF_CUSTODY => CHAIN_OF_CUSTODY_ID |
Primary keys must match in the Source and Target databases. There is a conflict in the primary key for [table]: Source: [source PK columns] Target: [target PK columns] |
UK |
Unique Key Error |
SAMPLE_ID, ANALYTIC_METHOD, ANALYSIS_DATE, TEST_TYPE, FRACTION, COLUMN_NUMBER, BIOLOGICAL_INTENT, TAXON => SAMPLE_ID, ANALYTIC_METHOD, ANALYSIS_DATE, TEST_TYPE, FRACTION, COLUMN_NUMBER |
Unique keys must match in the Source and Target databases. There is a conflict in a unique key for [table]: Source: [source PK columns] Target: [target PK columns] |
FK |
Foreign Key Violation |
Ø => PRESERVATIVE |
Foreign key exists on the Target database but is missing on the Source database. [table]. [column_name] should reference [parent_table]. |
Tbl-NoTrgt |
Table in source database does not exist in Target database |
[DT_PRODUCT_THICKNESS] => Ø |
Source database table [missing_source_table] does not exist in the Target database. |
Col-NoTrgt |
Field/column in source database does not exist in Target database |
[LOC_COUNTRY] => Ø |
Source database column [table].[column] does not exist in the Target database. |
Col-Req |
Required field/column in Target database not populated in Source database |
Ø => [STATUS_FLAG] |
Source is missing data in a required column of the Target database, [table].[column]. |
Col-Req-NoSrc |
Required field/column in Target database does not exist in Source database |
Ø => [ZTEST] |
Target database column [table].[required_target_column] does not exist in the Source database. |
Col-TypeSize |
Field/column data type or size mismatch (Source vs Target) |
VARCHAR(40) VARCHAR(20) NVARCHAR(255) => VARCHAR(255) DATETIME => SMALLDATETIME |
Column mismatch exists in [table].[column] between the Source and Target databases. Possible truncation of data. Source: [property_value] Target: [property_value]
|
ChkConst-Tbl |
CHECK Constraint (table) issue (generally missing field/column in Source database) |
Ø => CK__DT_LITHOLOGY__END_DEPTH__required |
Source data violates rule (CHECK constraint) on Target table [table]. Target CHECK constraint: [constraint_name] |
ChkConst-Col |
CHECK Constraint (column) issue (generally missing field/column in Source database) |
Ø => CK__DT_SAMPLE__AQS_POC |
Source violation of rule (CHECK constraint) on Target table [table].[column] Target CHECK constraint: [constraint_name] |
Error Code Example
1.The Icon indicates the level of severity, including:
a.Error (red circle with exclamation mark) – The data in its entirety cannot be transferred.
b.Warning (yellow triangle with exclamation mark) – The data will transfer but some precision may be missing.
2.Location – The table and/or column where the error is found
3.Error Description – A description of what is causing the validation error, and the relevant data to identify where the error is occurring
4.Rows Affected – The number of rows within the designated table that are affected by validation error, and all the child rows that will not be transferred (#cascading + #rows found)