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
0error Data screening is not completed. Contact ICES to resolve the problem. Microsoft SQL Server Native Client 11.0Sub DATRAScheck: upSU_Chk_HL_CA_rec,HL Invalid column name 'haulno'.
0error Data screening is not completed. Contact ICES to resolve the problem. Microsoft SQL Server Native Client 11.0Sub DATRAScheck: upSU_Chk_HL_CA_rec,CA Invalid column name 'haulno'.
2error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
2warning Not in the range specified 10HaulDur
2warning Not in the range specified 40CodendMesh
2error Field value is invalid (Rel) - prevents entry to database BT6 Gear
3error Duplicate value in record constraint 3 NL BT6 2020Quarter, Country, Gear, Year
3warning Not in the range specified 10HaulDur
3warning Not in the range specified 40CodendMesh
3error Field value is invalid (Rel) - prevents entry to database BT6 Gear
2warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 39F8;Reported : 603 StatRec; RepStatRec
3warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 38F8;Reported : 603 StatRec; RepStatRec
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
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
4warning Not in the range specified 40CodendMesh
5warning Not in the range specified 40CodendMesh
6warning Not in the range specified 40CodendMesh
4error Field value is invalid (Rel) - prevents entry to database BT6 Gear
5error Field value is invalid (Rel) - prevents entry to database BT6 Gear
6error Field value is invalid (Rel) - prevents entry to database BT6 Gear
4warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 37F7;Reported : 602 StatRec; RepStatRec
5warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 37F7;Reported : 602 StatRec; RepStatRec
6warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 37F7;Reported : 602 StatRec; RepStatRec
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
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
7warning Not in the range specified 40CodendMesh
8warning Not in the range specified 40CodendMesh
9warning Not in the range specified 40CodendMesh
10warning Not in the range specified 40CodendMesh
11warning Not in the range specified 40CodendMesh
12warning Not in the range specified 40CodendMesh
13warning Not in the range specified 40CodendMesh
7error Field value is invalid (Rel) - prevents entry to database BT6 Gear
8error Field value is invalid (Rel) - prevents entry to database BT6 Gear
9error Field value is invalid (Rel) - prevents entry to database BT6 Gear
10error Field value is invalid (Rel) - prevents entry to database BT6 Gear
11error Field value is invalid (Rel) - prevents entry to database BT6 Gear
12error Field value is invalid (Rel) - prevents entry to database BT6 Gear
13error Field value is invalid (Rel) - prevents entry to database BT6 Gear
9warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F7;Reported : 608 StatRec; RepStatRec
8warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F7;Reported : 608 StatRec; RepStatRec
10warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F7;Reported : 608 StatRec; RepStatRec
11warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 36F7;Reported : 608 StatRec; RepStatRec
12warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 34F4;Reported : 660 StatRec; RepStatRec
7warning The Shooting Position is not within the reported Statistical Rectangle Calculated : 37F7;Reported : 602 StatRec; RepStatRec
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
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
14warning Not in the range specified 11HaulDur
15warning Not in the range specified 8HaulDur
20warning Not in the range specified 14HaulDur
14warning Not in the range specified 40CodendMesh
15warning Not in the range specified 40CodendMesh
16warning Not in the range specified 40CodendMesh
17warning Not in the range specified 40CodendMesh
18warning Not in the range specified 40CodendMesh
19warning Not in the range specified 40CodendMesh
20warning Not in the range specified 40CodendMesh
21warning Not in the range specified 40CodendMesh
22warning Not in the range specified 40CodendMesh
23warning Not in the range specified 40CodendMesh
24warning Not in the range specified 40CodendMesh
25warning Not in the range specified 40CodendMesh
14error Field value is invalid (Rel) - prevents entry to database BT6 Gear
15error Field value is invalid (Rel) - prevents entry to database BT6 Gear
16error Field value is invalid (Rel) - prevents entry to database BT6 Gear
17error Field value is invalid (Rel) - prevents entry to database BT6 Gear
18error Field value is invalid (Rel) - prevents entry to database BT6 Gear
19error Field value is invalid (Rel) - prevents entry to database BT6 Gear
20error Field value is invalid (Rel) - prevents entry to database BT6 Gear
21error Field value is invalid (Rel) - prevents entry to database BT6 Gear
22error Field value is invalid (Rel) - prevents entry to database BT6 Gear
23error Field value is invalid (Rel) - prevents entry to database BT6 Gear
24error Field value is invalid (Rel) - prevents entry to database BT6 Gear
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