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

   
Result from the ICES DATa Screening Utility program for the following data:
   
Country: 77
Dataset: version 3.2 Phytoplankton, PP
FileName: ICES-ERF32_SMHI_Phytoplankton_2022_version_2023-03-13.xml
Email: xxxx@smhi.se
Monitoring Year: 2022
Submiting date: 14/03/2023 09:26:00
Time to screen: 347.13 minutes
Number of records in file: 11426
Max. Errors to return: 100000

   Number of records per record type: 
record: 00 2 Row(s)
record: 20 4 Row(s)
record: 21 4 Row(s)
record: 34 132 Row(s)
record: 38 22530 Row(s)
record: 90 48 Row(s)
record: 91 132 Row(s)
record: 92 0 Row(s)
record: 94 0 Row(s)
record: 36 0 Row(s)


 

Number of ErrorsTypeReported ErrorsError Fields
22662error There is more than one relationship between records (Critical error)  
11265error Duplicate value in record constraint R38, Condition
11265error More fields required or aggregate values R38, Condition
132error Entry must be unique (critical error) R91, Condition
132warning Station information may not be duplicate for file R91, Condition
120error SIZCL cannot be verified in Size Class Reference list - SIZRF (critical error) R38.SPECI, R38.SIZCL
60error SIZCL is no longer valid for this species. See the latest PEG_BVOL R38.SPECI,R38.SIZCL
48error Entry must be unique (critical error) R90, Condition
27error Species cannot be identified in the species code list (RLIST) (critical error) R38.SPECI,R38.RLIST
4error Entry must be unique (critical error) R20, Condition
4error Duplicate value in record constraint R21, Condition
2warning Cross field warning check (condition not met) R20, Condition
1error Cross record/field check (condition not met) in the record:91
1error Cross record/field check (error preventing data import) in the record:91



Record LineTypeReported errorsError ValuesError fields
-1error Cross record/field check (condition not met) Syntax error is SQL rules: CheckID = 360in the record:91
-1error Cross record/field check (error preventing data import) Syntax error is SQL rules: CheckID = 387in the record:91
7error Entry must be unique (critical error) Line 7, The combination of CRUIS and SHIPC must be uniqueR90, Condition
7error Entry must be unique (critical error) Line 7, The combination of CRUIS and SHIPC must be uniqueR90, Condition
12warning Station information may not be duplicate for file Line 12, Station information may not be duplicate for fileR91, Condition
12warning Station information may not be duplicate for file Line 12, Station information may not be duplicate for fileR91, Condition
12error Entry must be unique (critical error) Line 12, The combination of CRUIS and STNNO needs to be unique.R91, Condition
12error Entry must be unique (critical error) Line 12, The combination of CRUIS and STNNO needs to be unique.R91, Condition
31error More fields required or aggregate values Line 31, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
31error Duplicate value in record constraint Line 31, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
12error There is more than one relationship between records (Critical error) Too many relations between record: 91 and record 90 
26error There is more than one relationship between records (Critical error) Too many relations between record: 34 and record 91 
31error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
31error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
45error More fields required or aggregate values Line 45, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
59error More fields required or aggregate values Line 59, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
73error More fields required or aggregate values Line 73, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
87error More fields required or aggregate values Line 87, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
45error Duplicate value in record constraint Line 45, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
59error Duplicate value in record constraint Line 59, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
73error Duplicate value in record constraint Line 73, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
87error Duplicate value in record constraint Line 87, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
45error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
59error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
73error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
87error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
45error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
59error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
73error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
87error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
157error More fields required or aggregate values Line 157, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
199error More fields required or aggregate values Line 199, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
171error More fields required or aggregate values Line 171, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
185error More fields required or aggregate values Line 185, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
101error More fields required or aggregate values Line 101, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
115error More fields required or aggregate values Line 115, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
129error More fields required or aggregate values Line 129, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
143error More fields required or aggregate values Line 143, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
101error Duplicate value in record constraint Line 101, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
115error Duplicate value in record constraint Line 115, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
129error Duplicate value in record constraint Line 129, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
143error Duplicate value in record constraint Line 143, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
157error Duplicate value in record constraint Line 157, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
171error Duplicate value in record constraint Line 171, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
185error Duplicate value in record constraint Line 185, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
199error Duplicate value in record constraint Line 199, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
101error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
115error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
129error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
143error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
157error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
171error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
185error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
199error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
101error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
115error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
129error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
143error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
157error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
171error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
185error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
199error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 91 
409error More fields required or aggregate values Line 409, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
423error More fields required or aggregate values Line 423, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
213error More fields required or aggregate values Line 213, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
227error More fields required or aggregate values Line 227, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
241error More fields required or aggregate values Line 241, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
255error More fields required or aggregate values Line 255, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
269error More fields required or aggregate values Line 269, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
283error More fields required or aggregate values Line 283, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
297error More fields required or aggregate values Line 297, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
311error More fields required or aggregate values Line 311, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
325error More fields required or aggregate values Line 325, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
339error More fields required or aggregate values Line 339, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
353error More fields required or aggregate values Line 353, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
367error More fields required or aggregate values Line 367, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
381error More fields required or aggregate values Line 381, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
395error More fields required or aggregate values Line 395, Multiple occurences of a parameter under one sample record requires more information. See FAQ documentR38, Condition
213error Duplicate value in record constraint Line 213, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
227error Duplicate value in record constraint Line 227, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
241error Duplicate value in record constraint Line 241, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
255error Duplicate value in record constraint Line 255, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
269error Duplicate value in record constraint Line 269, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
283error Duplicate value in record constraint Line 283, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
297error Duplicate value in record constraint Line 297, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
311error Duplicate value in record constraint Line 311, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
325error Duplicate value in record constraint Line 325, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
339error Duplicate value in record constraint Line 339, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
353error Duplicate value in record constraint Line 353, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
367error Duplicate value in record constraint Line 367, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
381error Duplicate value in record constraint Line 381, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
395error Duplicate value in record constraint Line 395, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
409error Duplicate value in record constraint Line 409, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
423error Duplicate value in record constraint Line 423, Duplicate reporting is detected. Please contact ICES if this is not true (Critical error)R38, Condition
213error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
227error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
241error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
255error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
269error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
283error There is more than one relationship between records (Critical error) Too many relations between record: 38 and record 34 
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