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: 26-04-2024-11-17Testfile_headers-SNS_2020_3_64SS.csv
Email: xxxx@ices.dk
Monitoring Year: 2020
Submiting date: 26/04/2024 11:17:00
Time to screen: 1.45 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
9warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F7;Reported : 608 StatRec; RepStatRec
17warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F7;Reported : 605 StatRec; RepStatRec
25warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 35F3;Reported : 660 StatRec; RepStatRec
33warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F5;Reported : 607 StatRec; RepStatRec
41warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 33F3;Reported : 640 StatRec; RepStatRec
7warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 37F7;Reported : 602 StatRec; RepStatRec
15warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F6;Reported : 605 StatRec; RepStatRec
23warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F3;Reported : 606 StatRec; RepStatRec
31warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 35F5;Reported : 607 StatRec; RepStatRec
39warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 33F3;Reported : 630 StatRec; RepStatRec
47warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 39F8;Reported : 603 StatRec; RepStatRec
4warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 37F7;Reported : 602 StatRec; RepStatRec
12warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 34F4;Reported : 660 StatRec; RepStatRec
20warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 33F4;Reported : 640 StatRec; RepStatRec
28warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 35F4;Reported : 607 StatRec; RepStatRec
36warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 34F4;Reported : 630 StatRec; RepStatRec
44warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 39F7;Reported : 601 StatRec; RepStatRec
8warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F7;Reported : 608 StatRec; RepStatRec
16warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F6;Reported : 605 StatRec; RepStatRec
24warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 35F3;Reported : 606 StatRec; RepStatRec
32warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F5;Reported : 607 StatRec; RepStatRec
40warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 33F3;Reported : 630 StatRec; RepStatRec
3warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 38F8;Reported : 603 StatRec; RepStatRec
11warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F7;Reported : 608 StatRec; RepStatRec
19warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 33F4;Reported : 640 StatRec; RepStatRec
27warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 35F4;Reported : 607 StatRec; RepStatRec
35warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 34F4;Reported : 630 StatRec; RepStatRec
43warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 39F6;Reported : 601 StatRec; RepStatRec
6warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 37F7;Reported : 602 StatRec; RepStatRec
14warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F6;Reported : 605 StatRec; RepStatRec
22warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F3;Reported : 606 StatRec; RepStatRec
30warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 35F5;Reported : 607 StatRec; RepStatRec
38warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 34F4;Reported : 630 StatRec; RepStatRec
46warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 39F8;Reported : 601 StatRec; RepStatRec
5warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 37F7;Reported : 602 StatRec; RepStatRec
13warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 34F4;Reported : 660 StatRec; RepStatRec
21warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F3;Reported : 606 StatRec; RepStatRec
29warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 35F4;Reported : 607 StatRec; RepStatRec
37warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 34F4;Reported : 630 StatRec; RepStatRec
45warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 39F7;Reported : 601 StatRec; RepStatRec
2warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 39F8;Reported : 603 StatRec; RepStatRec
10warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F7;Reported : 608 StatRec; RepStatRec
18warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 33F4;Reported : 640 StatRec; RepStatRec
26warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 34F4;Reported : 660 StatRec; RepStatRec
34warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F6;Reported : 607 StatRec; RepStatRec
42warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 34F4;Reported : 660 StatRec; RepStatRec

  
 
 

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