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
2Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
3Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
4Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
5Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
6Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
7Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
8Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
9Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
10Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
11Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
12Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
13Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
14Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
15Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
16Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
17Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
18Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
19Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
20Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
21Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
22Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
23Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
24Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
25Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
26Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
27Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
28Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
29Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
30Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
31Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
32Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
33Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
34Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
35Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
36Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
37Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
38Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
39Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
40Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
41Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
42Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
43Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
44Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
45Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
46Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1
47Information Testing Only Item cannot be found in the collection corresponding to the requested name or ordinal. ADODB.Parameters-1

  
 
 

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