Data type invalid - .* is not in conformity with ‘INTEGER’ type in content/.*.xml¶
Classification¶
Validator |
Validator version |
Error message type |
DBPTK Developer |
2.11.1-DPRES, 4.0.0-DPRES |
File format |
Version |
Specification |
Description |
Location |
application/x-siard |
2.1.1 |
|||
application/x-siard |
2.2 |
Analyses¶
Possible solutions¶
Output example¶
Validator returned error.
Validate SIARD at '/corpus/file-scraper/tests/data/application_x-siard/invalid_2.1.1_schema_errors.siard'
Start validation
Start validation of: 4.1 - Construction of the SIARD archive file
4.1 - Construction of the SIARD archive file
G_4.1-1: [OK]
G_4.1-1: [OK]
G_4.1-2: [OK]
G_4.1-2: [OK]
G_4.1-3: [OK]
G_4.1-3: [OK]
G_4.1-4: [OK]
G_4.1-4: [OK]
G_4.1-5: [OK]
G_4.1-5: [OK]
Construction of the SIARD archive file [PASSED]
Construction of the SIARD archive file [PASSED]
Start validation of: 4.2 - Structure of the SIARD archive file
4.2 - Structure of the SIARD archive file
P_4.2-1: [OK]
P_4.2-1: [OK]
P_4.2-2: [OK]
P_4.2-2: [OK]
P_4.2-3: [OK]
P_4.2-3: [OK]
P_4.2-4: [OK]
P_4.2-4: [OK]
P_4.2-5: [OK]
P_4.2-5: [OK]
P_4.2-6: [OK]
P_4.2-6: [OK]
Structure of the SIARD archive file [PASSED]
Structure of the SIARD archive file [PASSED]
Start validation of: 4.3 - Correspondence between metadata and table data
4.3 - Correspondence between metadata and table data
P_4.3-1: [OK]
P_4.3-1: [OK]
P_4.3-2: [OK]
P_4.3-2: [OK]
P_4.3-3: [ERROR]
Correspondence between metadata and table data [FAILED]
P_4.3-3: [ERROR] - The data type information on the column definitions in metadata.xml must be identical to that in the corresponding table[number].xsd file - For 'INTEGER' type expected 'xs:integer' but found 'xs:string' in c2 at content/schema1/table1/table1.xsd
Correspondence between metadata and table data [FAILED]
Start validation of: 5.0 - Requirements for metadata
5.0 - Requirements for metadata
M_5.0-1: [OK]
M_5.0-1: [OK]
Requirements for metadata [PASSED]
Requirements for metadata [PASSED]
Start validation of: 5.1 - Database level metadata
5.1 - Database level metadata
M_5.1-1-1: [OK]
M_5.1-1-1: [OK]
A_M_5.1-1-1: [OK]
A_M_5.1-1-1: [OK]
M_5.1-1-2: [OK]
M_5.1-1-2: [OK]
A_M_5.1-1-3: [OK]
A_M_5.1-1-3: [OK]
A_M_5.1-1-4: [OK]
A_M_5.1-1-4: [OK]
A_M_5.1-1-5: [OK]
A_M_5.1-1-5: [OK]
M_5.1-1-6: [OK]
M_5.1-1-6: [OK]
A_M_5.1-1-7: [OK]
A_M_5.1-1-7: [OK]
M_5.1-1-10: [OK]
M_5.1-1-10: [OK]
A_M_5.1-1-10: [OK]
A_M_5.1-1-10: [OK]
M_5.1-1-16: [OK]
M_5.1-1-16: [OK]
M_5.1-1-17: [OK]
M_5.1-1-17: [OK]
Database level metadata [PASSED]
Database level metadata [PASSED]
Start validation of: 5.2 - Schema level metadata
5.2 - Schema level metadata
M_5.2-1-1: [OK]
M_5.2-1-1: [OK]
A_M_5.2-1-1: [OK]
A_M_5.2-1-1: [OK]
M_5.2-1-2: [OK]
M_5.2-1-2: [OK]
A_M_5.2-1-2: [OK]
A_M_5.2-1-2: [OK]
A_M_5.2-1-4: [WARNING] - The description element does not exist - metadata.xml schema:PUBLIC
A_M_5.2-1-4: [OK]
A_M_5.2-1-4: [OK]
Schema level metadata [PASSED]
Schema level metadata [PASSED]
Start validation of: 5.3 - Type level metadata
5.3 - Type level metadata
M_5.3-1: [SKIPPED] - Database has no types
M_5.3-1: [SKIPPED]
Type level metadata [PASSED]
Type level metadata [PASSED]
Start validation of: 5.4 - Attribute level metadata
5.4 - Attribute level metadata
M_5.4-1: [SKIPPED] - Database has no attributes
M_5.4-1: [SKIPPED]
Attribute level metadata [PASSED]
Attribute level metadata [PASSED]
Start validation of: 5.5 - Table level metadata
5.5 - Table level metadata
M_5.5-1-1: [OK]
M_5.5-1-1: [OK]
A_M_5.5-1-1: [OK]
A_M_5.5-1-1: [OK]
M_5.5-1-2: [OK]
M_5.5-1-2: [OK]
A_M_5.5-1-3: [WARNING] - The description element does not exist - metadata.xml schema:PUBLIC/table:Persons
A_M_5.5-1-3: [OK]
A_M_5.5-1-3: [OK]
M_5.5-1-4: [OK]
M_5.5-1-4: [OK]
M_5.5-1-10: [OK]
M_5.5-1-10: [OK]
Table level metadata [PASSED]
Table level metadata [PASSED]
Start validation of: 5.6 - Column level metadata
5.6 - Column level metadata
M_5.6-1-1: [OK]
M_5.6-1-1: [OK]
A_M_5.6-1-2: [OK]
A_M_5.6-1-2: [OK]
M_5.6-1-3: [OK]
M_5.6-1-3: [OK]
[NOTICE] - Different data types used [VARCHAR, INTEGER]-
A_M_5.6-1-12: [WARNING] - The description element does not exist - metadata.xml schema:PUBLIC/table:Persons/column:ID
A_M_5.6-1-12: [WARNING] - The description element does not exist - metadata.xml schema:PUBLIC/table:Persons/column:First Name
A_M_5.6-1-12: [WARNING] - The description element does not exist - metadata.xml schema:PUBLIC/table:Persons/column:Surname
A_M_5.6-1-12: [OK]
A_M_5.6-1-12: [OK]
Column level metadata [PASSED]
Column level metadata [PASSED]
Start validation of: 5.7 - Field level metadata
5.7 - Field level metadata
M_5.7-1: [SKIPPED] - Database has no fields
M_5.7-1: [SKIPPED]
Field level metadata [PASSED]
Field level metadata [PASSED]
Start validation of: 5.8 - Primary Key level metadata
5.8 - Primary Key level metadata
M_5.8-1-1: [OK]
M_5.8-1-1: [OK]
A_M_5.8-1-1: [OK]
A_M_5.8-1-1: [OK]
M_5.8-1-2: [OK]
M_5.8-1-2: [OK]
A_M_5.8-1-2: [OK]
A_M_5.8-1-2: [OK]
A_M_5.8-1-3: [WARNING] - The description element does not exist - metadata.xml schema:PUBLIC/table:Persons/candidateKey:SYS_PK_10368
A_M_5.8-1-3: [OK]
A_M_5.8-1-3: [OK]
Primary Key level metadata [PASSED]
Primary Key level metadata [PASSED]
Start validation of: 5.9 - Foreign Key level metadata
5.9 - Foreign Key level metadata
M_5.9-1: [SKIPPED] - Database has no foreign keys
M_5.9-1: [SKIPPED]
Foreign Key level metadata [PASSED]
Foreign Key level metadata [PASSED]
Start validation of: 5.10 - Reference level metadata
5.10 - Reference level metadata
5.10: [SKIPPED] - Database has no foreign keys and references
5.10: [SKIPPED]
Reference level metadata [PASSED]
Reference level metadata [PASSED]
Start validation of: 5.11 - Candidate Key level metadata
5.11 - Candidate Key level metadata
M_5.11-1-1: [OK]
M_5.11-1-1: [OK]
A_M_5.11-1-1: [OK]
A_M_5.11-1-1: [OK]
M_5.11-1-2: [OK]
M_5.11-1-2: [OK]
A_M_5.11-1-2: [OK]
A_M_5.11-1-2: [OK]
A_M_5.11-1-3: [WARNING] - The description element does not exist - metadata.xml schema:PUBLIC/table:Persons/candidateKey:SYS_IDX_SYS_PK_10368_10369
A_M_5.11-1-3: [OK]
A_M_5.11-1-3: [OK]
Candidate Key level metadata [PASSED]
Candidate Key level metadata [PASSED]
Start validation of: 5.12 - Check constraint level metadata
5.12 - Check constraint level metadata
M_5.12-1: [SKIPPED] - Database has no check constraint
M_5.12-1: [SKIPPED]
Check constraint level metadata [PASSED]
Check constraint level metadata [PASSED]
Start validation of: 5.13 - Trigger level metadata
5.13 - Trigger level metadata
M_5.13-1: [SKIPPED] - Database has no triggers
M_5.13-1: [SKIPPED]
Trigger level metadata [PASSED]
Trigger level metadata [PASSED]
Start validation of: 5.14 - View level metadata
5.14 - View level metadata
M_5.14-1: [SKIPPED] - Database has no view
M_5.14-1: [SKIPPED]
View level metadata [PASSED]
View level metadata [PASSED]
Start validation of: 5.15 - Routine level metadata
5.15 - Routine level metadata
M_5.15-1: [SKIPPED] - Database has no routine
M_5.15-1: [SKIPPED]
Routine level metadata [PASSED]
Routine level metadata [PASSED]
Start validation of: 5.16 - Parameter level metadata
5.16 - Parameter level metadata
M_5.16-1: [SKIPPED] - Database has no parameters
M_5.16-1: [SKIPPED]
Parameter level metadata [PASSED]
Parameter level metadata [PASSED]
Start validation of: 5.17 - User level metadata
5.17 - User level metadata
M_5.17-1-1: [OK]
M_5.17-1-1: [OK]
A_M_5.17-1-1: [OK]
A_M_5.17-1-1: [OK]
A_M_5.17-1-2: [OK]
A_M_5.17-1-2: [OK]
User level metadata [PASSED]
User level metadata [PASSED]
Start validation of: 5.18 - Role level metadata
5.18 - Role level metadata
M_5.18-1: [SKIPPED] - Database has no roles
M_5.18-1: [SKIPPED]
Role level metadata [PASSED]
Role level metadata [PASSED]
Start validation of: 5.19 - Privilege level metadata
5.19 - Privilege level metadata
M_5.19-1: [SKIPPED] - Database has no privileges
M_5.19-1: [SKIPPED]
Privilege level metadata [PASSED]
Privilege level metadata [PASSED]
Start validation of: T_6.0 - Requirements for table data
Requirements for table data T_6.0-2: [START] - Validating XML against XSD
content/schema1/table1/table1.xml
Requirements for table data T_6.0-2: [FINISH] - Validating XML against XSD
T_6.0-2: [OK]
T_6.0-2: [OK]
T_6.0 - Requirements for table data
Requirements for table data T_6.0-1: [START] - Validating Primary Keys
content/schema1/table1/table1.xml
content/schema1/table1/table1.xml [OK]
Requirements for table data T_6.0-1: [FINISH] - Validating Primary Keys
Requirements for table data T_6.0-1: [START] - Validating Foreign Keys
content/schema1/table1/table1.xml
content/schema1/table1/table1.xml [OK]
Requirements for table data T_6.0-1: [FINISH] - Validating Foreign Keys
T_6.0-1: [OK]
T_6.0-1: [OK]
Requirements for table data A_T_6.0-1-1: [START] - Validating foreign key null values
Requirements for table data A_T_6.0-1-1: [FINISH] - Validating foreign key null values
A_T_6.0-1-1: [OK]
A_T_6.0-1-1: [OK]
Requirements for table data A_T_6.0-1-2: [START] - Validating data type
content/schema1/table1/table1.xml
A_T_6.0-1-2: [ERROR] - Data type invalid - John is not in conformity with 'INTEGER' type in content/schema1/table1/table1.xml
A_T_6.0-1-2: [ERROR] - Data type invalid - Jane is not in conformity with 'INTEGER' type in content/schema1/table1/table1.xml
content/schema1/table1/table1.xml [ERROR]
Requirements for table data A_T_6.0-1-2: [FINISH] - Validating data type
A_T_6.0-1-2: [ERROR]
Requirements for table data [FAILED]
A_T_6.0-1-2: [ERROR]
Requirements for table data [FAILED]
Start validation of: T_6.1 - Table schema definition
T_6.1 - Table schema definition
T_6.1-1: [OK]
T_6.1-1: [OK]
T_6.1-2: [OK]
T_6.1-2: [OK]
T_6.1-3: [OK]
T_6.1-3: [OK]
T_6.1-4: [OK]
T_6.1-4: [OK]
Table schema definition [PASSED]
Table schema definition [PASSED]
Start validation of: T_6.3 - Date and timestamp data cells
T_6.3 - Date and timestamp data cells
T_6.3-1: [OK]
T_6.3-1: [OK]
Date and timestamp data cells [PASSED]
Date and timestamp data cells [PASSED]
Start validation of: T_6.4 - Table data
T_6.4 - Table data
T_6.4-1: [OK]
T_6.4-1: [OK]
Table data T_6.4-2: [START] - Validating row elements
content/schema1/table1/table1.xml
content/schema1/table1/table1.xml [OK]
Table data T_6.4-2: [FINISH] - Validating row elements
T_6.4-2: [OK]
T_6.4-2: [OK]
T_6.4-4: [SKIPPED]
T_6.4-4: [SKIPPED] - Optional
T_6.4-5: [OK]
T_6.4-5: [OK]
Table data [PASSED]
Table data [PASSED]
Number of requirements passed [25]
Number of sub-requirements ok [65]
Number of requirements failed [2]
Number of errors [4]
Number of warnings [7]
Number of requirements skipped [13]
Validation process finished the SIARD is not valid.
A report with a listing of information about the individual validations could not be generated, please submit a bug report to help us fix this.
Validate SIARD took 0m 1s to complete.
Log files and migration reports were saved in /usr/share/java/dbptk-developer
Troubleshooting information can be found at https://github.com/keeps/dbptk-developer/wiki/Troubleshooting
Please report any problems at https://github.com/keeps/dbptk-developer/issues/new