ICES Marine Data
DATSU
 
DATSU > List of operations > Screen a file
 

   
Result from the ICES DATa Screening Utility program for the following data:
   
Country: NL
Dataset: Test of unified format of NS-IBTS
FileName: 23-04-2024-03-00Testfile_headers-SNS_2020_3_64SS.csv
Email: xxxx@ices.dk
Monitoring Year: 2020
Submiting date: 23/04/2024 15:00:00
Time to screen: 2.58 minutes
Number of records in file: 4871
Max. Errors to return: 30000

   Number of records per record type: 
record: CA 0 Row(s)
record: HH 0 Row(s)
record: HL 0 Row(s)


Number of ErrorsTypeReported ErrorsError Fields
4871error Field value is invalid (Rel) - prevents entry to database Gear
2671error Duplicate value in record constraint Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
1376error Field value is invalid (Rel) - prevents entry to database MaturityScale
1376error Field value is invalid (Rel) - prevents entry to database AreaType
46warning The Shooting Position is not within the reported Statistical Rectangle StatRec; RepStatRec
46error Duplicate value in record constraint Quarter, Country, Gear, Year
46Information Testing Only -1
46warning Not in the range specified CodendMesh
7warning Not in the range specified HaulDur
2warning Not in the range specified TotalNo
1warning Missing values in mandatory field LngtClass; NoOfMissingValues
1warning Missing values in mandatory field LngtCode; NoOfMissingValues
1warning Missing values in mandatory field Maturity; NoOfMissingValues
1warning Missing values in mandatory field MaturityScale; NoOfMissingValues
1warning Missing values in mandatory field NoMeas; NoOfMissingValues
1warning Missing values in mandatory field PlusGr; NoOfMissingValues
1warning Missing values in mandatory field AgeRings; NoOfMissingValues
1warning Missing values in mandatory field CatCatchWgt; NoOfMissingValues
1warning Missing values in mandatory field CatIdentifier; NoOfMissingValues
1error Data screening is not completed. Contact ICES to resolve the problem. Sub DATRAScheck: upSU_Chk_HL_CA_rec,CA Invalid column name 'haulno'.
1error Data screening is not completed. Contact ICES to resolve the problem. Sub DATRAScheck: upSU_Chk_HL_CA_rec,HL Invalid column name 'haulno'.



Record LineTypeReported errorsError ValuesError fields
2error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
3error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
4error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
5error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
6error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
7error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
8error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
9error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
10error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
11error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
12error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
13error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
14error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
15error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
16error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
17error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
18error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
19error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
20error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
21error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
22error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
23error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
24error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
25error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
26error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
27error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
28error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
29error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
30error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
31error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
32error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
33error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
34error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
35error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
36error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
37error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
38error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
39error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
40error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
41error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
42error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
43error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
44error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
45error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
46error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
47error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
2564error Duplicate value in record constraint 3 NL BT6 2020 W 125999 U 1 4.0000 1 5Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2565error Duplicate value in record constraint 3 NL BT6 2020 W 125999 U 1 4.0000 1 6Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2566error Duplicate value in record constraint 3 NL BT6 2020 W 125999 U 1 4.0000 1 7Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2576error Duplicate value in record constraint 3 NL BT6 2020 W 123776 U 1 16.0000 -9 -9Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2578error Duplicate value in record constraint 3 NL BT6 2020 W 107232 U 1 16.0000 -9 -9Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2579error Duplicate value in record constraint 3 NL BT6 2020 W 123867 U 1 16.0000 -9 -9Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2580error Duplicate value in record constraint 3 NL BT6 2020 W 107552 U 1 128.0000 -9 -9Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2582error Duplicate value in record constraint 3 NL BT6 2020 W 124929 U 1 128.0000 -9 -9Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2583error Duplicate value in record constraint 3 NL BT6 2020 W 127262 U 1 1.0000 1 24Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2584error Duplicate value in record constraint 3 NL BT6 2020 W 127262 U 1 1.0000 1 12Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2585error Duplicate value in record constraint 3 NL BT6 2020 W 127262 U 1 1.0000 1 16Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2586error Duplicate value in record constraint 3 NL BT6 2020 W 127262 U 1 1.0000 1 14Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2587error Duplicate value in record constraint 3 NL BT6 2020 W 127126 U 1 1.0000 1 10Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2588error Duplicate value in record constraint 3 NL BT6 2020 W 127126 U 1 1.0000 1 11Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2589error Duplicate value in record constraint 3 NL BT6 2020 W 127126 U 1 1.0000 1 12Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2590error Duplicate value in record constraint 3 NL BT6 2020 W 127126 U 1 1.0000 1 13Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2591error Duplicate value in record constraint 3 NL BT6 2020 W 127126 U 1 1.0000 1 14Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2592error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 9Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2593error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 10Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2594error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 11Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2595error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 12Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2596error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 13Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2597error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 14Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2598error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 15Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2599error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 16Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2600error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 17Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2601error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 18Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2602error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 19Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2603error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 20Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2604error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 21Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2605error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 23Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2606error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 24Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2607error Duplicate value in record constraint 3 NL BT6 2020 W 127143 U 1 1.0000 1 27Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2609error Duplicate value in record constraint 3 NL BT6 2020 W 125999 U 1 1.0000 1 4Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2610error Duplicate value in record constraint 3 NL BT6 2020 W 125999 U 1 1.0000 1 6Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2611error Duplicate value in record constraint 3 NL BT6 2020 W 125999 U 1 1.0000 1 7Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2612error Duplicate value in record constraint 3 NL BT6 2020 W 127160 U 1 1.0000 1 12Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2613error Duplicate value in record constraint 3 NL BT6 2020 W 127160 U 1 1.0000 1 14Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2614error Duplicate value in record constraint 3 NL BT6 2020 W 127160 U 1 1.0000 1 16Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2615error Duplicate value in record constraint 3 NL BT6 2020 W 127160 U 1 1.0000 1 17Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2616error Duplicate value in record constraint 3 NL BT6 2020 W 127160 U 1 1.0000 1 18Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2617error Duplicate value in record constraint 3 NL BT6 2020 W 127160 U 1 1.0000 1 19Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2618error Duplicate value in record constraint 3 NL BT6 2020 W 127160 U 1 1.0000 1 20Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2619error Duplicate value in record constraint 3 NL BT6 2020 W 127160 U 1 1.0000 1 21Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2620error Duplicate value in record constraint 3 NL BT6 2020 W 127160 U 1 1.0000 1 23Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2621error Duplicate value in record constraint 3 NL BT6 2020 W 127160 U 1 1.0000 1 26Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2622error Duplicate value in record constraint 3 NL BT6 2020 W 127139 U 1 1.0000 1 5Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2623error Duplicate value in record constraint 3 NL BT6 2020 W 127139 U 1 1.0000 1 6Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2624error Duplicate value in record constraint 3 NL BT6 2020 W 127139 U 1 1.0000 1 7Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2625error Duplicate value in record constraint 3 NL BT6 2020 W 127139 U 1 1.0000 1 8Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2626error Duplicate value in record constraint 3 NL BT6 2020 W 127139 U 1 1.0000 1 12Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2627error Duplicate value in record constraint 3 NL BT6 2020 W 127139 U 1 1.0000 1 13Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2628error Duplicate value in record constraint 3 NL BT6 2020 W 127139 U 1 1.0000 1 14Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
2629error Duplicate value in record constraint 3 NL BT6 2020 W 127139 U 1 1.0000 1 15Quarter, Country, Gear, Year, SpecCodeType, SpecCode, Sex, CatIdentifier, SubFactor, LngtCode, LngtClass
12345678910...

  
 
 

International Council for the Exploration of the Sea (ICES) · Conseil International pour l'Exploration de la Mer (CIEM)
ICES Secretariat · H. C. Andersens Boulevard 44-46, DK 1553, Copenhagen Denmark · Tel: +45 3338 6700 · Fax: +45 3393 4215 · info@ices.dk
Disclaimer © ICES - All Rights Reserved