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

   
Result from the ICES DATa Screening Utility program for the following data:
   
Country: 74
Dataset: version 3.2 Biota, CF
FileName: ICES_Report_CF_202404261051.csv
Email: xxxx@noc.ac.uk
Monitoring Year: 2023
Submiting date: 26/04/2024 13:14:00
Time to screen: -0.13 minutes
Number of records in file: 47
Max. Errors to return: 5000

   Number of records per record type: 
record: 00 1 Row(s)
record: 03 4 Row(s)
record: 04 9 Row(s)
record: 10 9 Row(s)
record: 20 1 Row(s)
record: 21 8 Row(s)
record: 36 0 Row(s)
record: 90 1 Row(s)
record: 91 3 Row(s)
record: 92 0 Row(s)
record: 93 8 Row(s)
record: 94 3 Row(s)


 

Number of ErrorsTypeReported ErrorsError Fields
8error There is more than one relationship between records (Critical error)  
8error Too few or too many fields in this record 93
6error Cross record/field check (error preventing data import) R00, Condition
3error Longitude outside valid range R91.LONGI
2error Cross record/field check (condition not met) R10, Condition
1error Cross field check (condition not met) R10, Condition
1error Cross record/field check (condition not met) R91, Condition
1Information Cross field check (Information - condition not met) R00, Condition
1warning Deprecated code SHIPC
1warning Sampling coordinates are not in the station dictionary defined area for this station sql is: FROM R00 INNER JOIN ( SELECT CODE.Code AS SD_MATCH, CODE.Code FROM RECO.dbo.tblCode AS CODE INNER JOIN RECO.dbo.tblCodeType AS CODETYPE ON CODE.tblCodeTypeID = CODETYPE.tblCodeTypeID WHERE (CODETYPE.CodeType = 'CNTRY') UNION ALL SELECT C_1.Description AS SD_MATCH, C_1.Code AS CODE FROM RECO.dbo.tblCode AS C_1 INNER JOIN RECO.dbo.tblCodeType AS CT_1 ON C_1.tblCodeTypeID = CT_1.tblCodeTypeID WHERE (CT_1.CodeType = 'CNTRY')) AS CNTRY_MATCH ON R00.CNTRY = CNTRY_MATCH.Code INNER JOIN RECO_Publish.dbo.tblStation_RetroStyle AS SD ON CNTRY_MATCH.SD_MATCH = SD.Country INNER JOIN R91 ON ISNULL(SD.StartYear, 0) <= CAST(LEFT(R91.SDATE, 4) AS INT) AND SD.Station_Name = REPLACE(LTRIM(RTRIM(R91.STATN)), '', '''') AND ISNULL(SD.EndYear, YEAR(GETDATE())) >= CAST(LEFT(R91.SDATE, 4) AS INT) WHERE geometry::STGeomFromText(SD.[Geometry], 4326).MakeValid().STIntersects(geometry::Point( DBO.UF_32POS2DECPOS(R91.LONGI), DBO.UF_32POS2DECPOS(R91.LATIT),4326)) = 0 in the record:91
1warning Station position appears to be on land sql is: FROM R91 WHERE GDB.dbo.ufn_GEBCO_08_G_OnLand(datsu.[dbo].[UF_32Pos2DecPos](LATIT), datsu.[dbo].[UF_32Pos2DecPos](LONGI), 4) = 1 in the record:91
1error Entry must be unique (critical error) R03, Condition
1error There should be at least one relationship between records (critical error)  



Record LineTypeReported errorsError ValuesError fields
1error Cross record/field check (error preventing data import) Line 1, ERF 3.2.4 or ERF 3.2.5 is required in 00:RFVER when the accreditation fields have been usedR00, Condition
1error Cross record/field check (error preventing data import) Line 1, ERF 3.2.4 or ERF 3.2.5 is required in 00:RFVER when the accreditation fields have been usedR00, Condition
1error Cross record/field check (error preventing data import) Line 1, ERF 3.2.4 or ERF 3.2.5 is required in 00:RFVER when the accreditation fields have been usedR00, Condition
1error Cross record/field check (error preventing data import) Line 1, ERF 3.2.4 or ERF 3.2.5 is required in 00:RFVER when the accreditation fields have been usedR00, Condition
1error Cross record/field check (error preventing data import) Line 1, ERF 3.2.4 or ERF 3.2.5 is required in 00:RFVER when the accreditation fields have been usedR00, Condition
1error Cross record/field check (error preventing data import) Line 1, ERF 3.2.4 or ERF 3.2.5 is required in 00:RFVER when the accreditation fields have been usedR00, Condition
38error Cross record/field check (condition not met) Line 38, PARAMs EROD and CYP1A require the reporting of bottom temperature (BotTemp) in record 92 (WGBEC2013)R91, Condition
26error Cross record/field check (condition not met) Line 26, PARAM Bile metabolites must be reported in matrix BI (bile) (WGBEC2013)R10, Condition
23error Longitude outside valid range -5. 4.5780R91.LONGI
27error Longitude outside valid range -4. 40.758R91.LONGI
38error Longitude outside valid range -4. 5.5260R91.LONGI
11error Too few or too many fields in this record  93
12error Too few or too many fields in this record  93
13error Too few or too many fields in this record  93
14error Too few or too many fields in this record  93
15error Too few or too many fields in this record  93
16error Too few or too many fields in this record  93
17error Too few or too many fields in this record  93
18error Too few or too many fields in this record  93
29error There is more than one relationship between records (Critical error) Too many relations between record: 04 and record 03 
31error There is more than one relationship between records (Critical error) Too many relations between record: 04 and record 03 
-1warning Sampling coordinates are not in the station dictionary defined area for this station Syntax error is SQL rules: CheckID = 373sql is: FROM R00 INNER JOIN ( SELECT CODE.Code AS SD_MATCH, CODE.Code FROM RECO.dbo.tblCode AS CODE INNER JOIN RECO.dbo.tblCodeType AS CODETYPE ON CODE.tblCodeTypeID = CODETYPE.tblCodeTypeID WHERE (CODETYPE.CodeType = 'CNTRY') UNION ALL SELECT C_1.Description AS SD_MATCH, C_1.Code AS CODE FROM RECO.dbo.tblCode AS C_1 INNER JOIN RECO.dbo.tblCodeType AS CT_1 ON C_1.tblCodeTypeID = CT_1.tblCodeTypeID WHERE (CT_1.CodeType = 'CNTRY')) AS CNTRY_MATCH ON R00.CNTRY = CNTRY_MATCH.Code INNER JOIN RECO_Publish.dbo.tblStation_RetroStyle AS SD ON CNTRY_MATCH.SD_MATCH = SD.Country INNER JOIN R91 ON ISNULL(SD.StartYear, 0) <= CAST(LEFT(R91.SDATE, 4) AS INT) AND SD.Station_Name = REPLACE(LTRIM(RTRIM(R91.STATN)), '', '''') AND ISNULL(SD.EndYear, YEAR(GETDATE())) >= CAST(LEFT(R91.SDATE, 4) AS INT) WHERE geometry::STGeomFromText(SD.[Geometry], 4326).MakeValid().STIntersects(geometry::Point( DBO.UF_32POS2DECPOS(R91.LONGI), DBO.UF_32POS2DECPOS(R91.LATIT),4326)) = 0 in the record:91
8error There should be at least one relationship between records (critical error) No relation between record: 21 and record 10 
33error There is more than one relationship between records (Critical error) Too many relations between record: 04 and record 03 
36error There is more than one relationship between records (Critical error) Too many relations between record: 04 and record 03 
30error There is more than one relationship between records (Critical error) Too many relations between record: 10 and record 03 
32error There is more than one relationship between records (Critical error) Too many relations between record: 10 and record 03 
34error There is more than one relationship between records (Critical error) Too many relations between record: 10 and record 03 
37error There is more than one relationship between records (Critical error) Too many relations between record: 10 and record 03 
28error Entry must be unique (critical error) Line 28, The combination of CRUIS, STNNO, and SMPNO must be unique.R03, Condition
22warning Deprecated code AA13SHIPC
1Information Cross field check (Information - condition not met) Line 1, Implement the latest reporting format changesR00, Condition
-1warning Station position appears to be on land Syntax error is SQL rules: CheckID = 443sql is: FROM R91 WHERE GDB.dbo.ufn_GEBCO_08_G_OnLand(datsu.[dbo].[UF_32Pos2DecPos](LATIT), datsu.[dbo].[UF_32Pos2DecPos](LONGI), 4) = 1 in the record:91
43error Cross record/field check (condition not met) Line 43, Parameter EROD requires reporting of parameter GOSOIR10, Condition
43error Cross field check (condition not met) Line 43, VALUE <= DETLI but QFLAG is not specified (See FAQs)R10, Condition

  
 
 

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