Record Line | Type | Reported errors | Error Values | Error fields |
1 | error | 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 used | R00, Condition |
1 | error | 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 used | R00, Condition |
1 | error | 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 used | R00, Condition |
1 | error | 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 used | R00, Condition |
1 | error | 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 used | R00, Condition |
1 | error | 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 used | R00, Condition |
38 | error | 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 |
26 | error | Cross record/field check (condition not met) | Line 26, PARAM Bile metabolites must be reported in matrix BI (bile) (WGBEC2013) | R10, Condition |
23 | error | Longitude outside valid range | -5. 4.5780 | R91.LONGI |
27 | error | Longitude outside valid range | -4. 40.758 | R91.LONGI |
38 | error | Longitude outside valid range | -4. 5.5260 | R91.LONGI |
11 | error | Too few or too many fields in this record | | 93 |
12 | error | Too few or too many fields in this record | | 93 |
13 | error | Too few or too many fields in this record | | 93 |
14 | error | Too few or too many fields in this record | | 93 |
15 | error | Too few or too many fields in this record | | 93 |
16 | error | Too few or too many fields in this record | | 93 |
17 | error | Too few or too many fields in this record | | 93 |
18 | error | Too few or too many fields in this record | | 93 |
29 | error | There is more than one relationship between records (Critical error) | Too many relations between record: 04 and record 03 | |
31 | error | There is more than one relationship between records (Critical error) | Too many relations between record: 04 and record 03 | |
-1 | warning | Sampling coordinates are not in the station dictionary defined area for this station | Syntax error is SQL rules: CheckID = 373 | 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 |
8 | error | There should be at least one relationship between records (critical error) | No relation between record: 21 and record 10 | |
33 | error | There is more than one relationship between records (Critical error) | Too many relations between record: 04 and record 03 | |
36 | error | There is more than one relationship between records (Critical error) | Too many relations between record: 04 and record 03 | |
30 | error | There is more than one relationship between records (Critical error) | Too many relations between record: 10 and record 03 | |
32 | error | There is more than one relationship between records (Critical error) | Too many relations between record: 10 and record 03 | |
34 | error | There is more than one relationship between records (Critical error) | Too many relations between record: 10 and record 03 | |
37 | error | There is more than one relationship between records (Critical error) | Too many relations between record: 10 and record 03 | |
28 | error | Entry must be unique (critical error) | Line 28, The combination of CRUIS, STNNO, and SMPNO must be unique. | R03, Condition |
22 | warning | Deprecated code | AA13 | SHIPC |
1 | Information | Cross field check (Information - condition not met) | Line 1, Implement the latest reporting format changes | R00, Condition |
-1 | warning | Station position appears to be on land | Syntax error is SQL rules: CheckID = 443 | 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 |
43 | error | Cross record/field check (condition not met) | Line 43, Parameter EROD requires reporting of parameter GOSOI | R10, Condition |
43 | error | Cross field check (condition not met) | Line 43, VALUE <= DETLI but QFLAG is not specified (See FAQs) | R10, Condition |