Itron Analytics entity errors
|
Entity type ID |
Error number |
Msg |
Condition |
Error severity |
ValidationDataColumns |
|---|---|---|---|---|---|
|
CEF_Device |
0 |
No Errors |
NULL |
0 |
NULL |
|
CEF_Device |
1 |
Invalid Device Id |
NULL |
1 |
DeviceId |
|
CEF_Device |
4 |
Associated meter is in invalid meters table |
NULL |
1 |
NULL |
|
CEF_DeviceEvent |
0 |
No Errors |
NULL |
0 |
NULL |
|
CEF_DeviceEvent |
1 |
Invalid Event ID |
NULL |
1 |
EventId |
|
CEF_DeviceEvent |
2 |
Duplicate Tamper Event in File |
NULL |
1 |
convert(nvarchar,EventDateTime,120) + ' ' + EventId |
|
CEF_EventData |
0 |
No Errors |
NULL |
0 |
NULL |
|
CEF_File |
0 |
No Errors |
NULL |
0 |
NULL |
|
CP_Voltage |
0 |
No Errors |
NULL |
0 |
NULL |
|
CP_Voltage |
1 |
Invalid Device Id |
NULL |
1 |
DeviceId+':'+convert(nvarchar, DeviceId) |
|
CRF_Channel |
0 |
No Errors |
NULL |
0 |
NULL |
|
CRF_Channel |
1 |
Invalid Channel ID |
NULL |
1 |
IsNULL(ChannelID, '['+ChannelID_Part1+'] ['+ChannelID_Part2+']') |
|
CRF_Channel |
2 |
Multiple matching channels for EndPointChannelID addressing type without MarketType provided |
NULL |
1 |
NULL |
|
CRF_Channel |
4 |
Associated meter is in invalid meters table |
NULL |
1 |
NULL |
|
CRF_ContiguousIntervalSet |
0 |
No Errors |
NULL |
0 |
NULL |
|
CRF_ContiguousIntervalSet |
1 |
Duplicate ContiguousIntervalSet in file |
NULL |
1 |
convert(nvarchar,StartTime,120) + ' - ' + convert(nvarchar,EndTime,120) |
|
CRF_ContiguousIntervalSet |
2 |
Invalid Interval Length |
NULL |
1 |
convert(nvarchar, t.IntervalLength) |
|
CRF_Register_Reading |
0 |
No Errors |
NULL |
0 |
NULL |
|
CRF_Register_Reading |
1 |
Duplicate Reading in file |
NULL |
1 |
convert(nvarchar,ReadingTime,120) + ' - ' + convert(nvarchar,Value) |
|
DEH_Address |
0 |
No Errors |
NULL |
0 |
NULL |
|
DEH_BankAttributes |
0 |
No Errors |
NULL |
0 |
NULL |
|
DEH_BankAttributes |
1 |
Not a Bank |
NOT EXISTS (select 1 from stg.DEH_DistributionEquipment e where e.DistributionEquipmentType = 'SubstationBank' and e.ID = stg.DEH_BankAttributes.ParentID and e.FileInventoryKey = stg.DEH_BankAttributes.FileInventoryKey) |
1 |
NULL |
|
DEH_BankAttributes |
2 |
Invalid EffectiveTimeRange |
stg.fn_IsValidXmlDate(LinkStartDate)=0 OR stg.fn_IsValidXmlDate(LinkEndDate)=0 OR (stg.fn_XmlDateToSqlDate (LinkStartDate) > stg.fn_XmlDateToSqlDate (LinkEndDate)) |
1 |
LinkStartDate + ' - ' + LinkEndDate |
|
DEH_Channel |
0 |
No Errors |
NULL |
0 |
NULL |
|
DEH_Channel |
1 |
Invalid Channel Number |
NULL |
1 |
convert(nvarchar,ChannelNumber) |
|
DEH_Channel |
2 |
Invalid Unit |
(IsNew=1 and Unit is NULL) OR ((Unit is not NULL) and Unit not in (select UnitID from mstr.Unit)) |
1 |
Unit |
|
DEH_Channel |
4 |
Invalid PowerFlowDirection |
(PowerFlowDirection is NOT NULL) and PowerFlowDirection not in ('Delivered','Received') |
1 |
PowerFlowDirection |
|
DEH_Channel |
8 |
More than one channels with the same Channel Number |
NULL |
1 |
ChannelNumber |
|
DEH_Channel |
16 |
More than one channels with the same UOM |
NULL |
1 |
Unit + ' - ' + PowerFlowDirection + ' - ' + PhaseConfig + ' - ' + UtilizationType |
|
DEH_Device |
0 |
No Errors |
NULL |
0 |
NULL |
|
DEH_Device |
1 |
Invalid DeviceId |
NULL |
1 |
DeviceId |
|
DEH_DistributionEquipment |
0 |
No Errors |
NULL |
0 |
NULL |
|
DEH_DistributionEquipment |
1 |
Invalid DistributionEquipmentId |
NULL |
1 |
DistributionEquipmentID |
|
DEH_DistributionEquipment |
2 |
Invalid ServicePointId |
DistributionEquipmentType='ServicePoint' and NOT EXISTS (select 1 from mstr.ServicePoint sp where sp.ServicePointID=stg.DEH_DistributionEquipment.DistributionEquipmentID) |
1 |
DistributionEquipmentID |
|
DEH_DistributionEquipment |
4 |
Invalid TimeZone |
(IsNew=1 and (TimeZone is NULL)) OR ((TimeZone is not null) AND TimeZone not in (select TimeZoneID from mstr.TimeZone)) |
1 |
TimeZone |
|
DEH_DistributionEquipment |
8 |
Missing or Invalid CommodityType |
(IsNew=1 and (CommodityType is NULL)) OR ((CommodityType is not NULL) AND CommodityType not in ('Electric')) |
1 |
CommodityType |
|
DEH_DistributionEquipment |
16 |
Missing or Invalid Distribution Equipment Type |
DistributionEquipmentType not in (select DistributionEquipmentType from mstr.DistributionEquipmentType) |
1 |
DistributionEquipmentType |
|
DEH_DistributionEquipment |
32 |
Duplicated DistributionEquipmentID |
NULL |
1 |
DistributionEquipmentID + ' / ' + DistributionEquipmentType |
|
DEH_FeederAttributes |
0 |
No Errors |
NULL |
0 |
NULL |
|
DEH_FeederAttributes |
1 |
Not a Feeder |
NOT EXISTS (select 1 from stg.DEH_DistributionEquipment e where e.DistributionEquipmentType = 'Feeder' and e.ID = stg.DEH_FeederAttributes.ParentID and e.FileInventoryKey = stg.DEH_FeederAttributes.FileInventoryKey) |
1 |
NULL |
|
DEH_FeederAttributes |
2 |
Invalid EffectiveTimeRange |
stg.fn_IsValidXmlDate(LinkStartDate)=0 OR stg.fn_IsValidXmlDate(LinkEndDate)=0 OR (stg.fn_XmlDateToSqlDate (LinkStartDate) > stg.fn_XmlDateToSqlDate (LinkEndDate)) |
1 |
LinkStartDate + ' - ' + LinkEndDate |
|
DEH_Meter |
0 |
No Errors |
NULL |
0 |
NULL |
|
DEH_Meter |
1 |
Invalid MeterID |
NULL |
1 |
MeterID |
|
DEH_Meter |
2 |
Missing District data for a District Meter |
NULL |
1 |
NULL |
|
DEH_Meter |
4 |
Invalid MeterLinkRange |
stg.fn_IsValidXmlDate(LinkStartDate)=0 OR stg.fn_IsValidXmlDate(LinkEndDate)=0 OR (stg.fn_XmlDateToSqlDate (LinkStartDate) > stg.fn_XmlDateToSqlDate (LinkEndDate)) |
1 |
LinkStartDate + ' - ' + LinkEndDate |
|
DEH_Meter |
8 |
MeterSetMemberType is mandatory for Compound meters |
(MeterSetMemberType is NULL) and IsNULL(MeterSetType,'Single')<>'Single' |
1 |
NULL |
|
DEH_Meter |
16 |
Invalid MeterSetMemberType |
(MeterSetType='CompoundMeter') and (MeterSetMemberType not in ('Large','Small' )) |
1 |
MeterSetMemberType |
|
DEH_ParentEquipment |
0 |
No Errors |
NULL |
0 |
NULL |
|
DEH_ParentEquipment |
1 |
Invalid ParentEquipmentID |
NULL |
1 |
ParentEquipmentID |
|
DEH_ParentEquipment |
2 |
Invalid ParentLinkRange |
stg.fn_IsValidXmlDate(LinkStartDate)=0 OR stg.fn_IsValidXmlDate(LinkEndDate)=0 OR (stg.fn_XmlDateToSqlDate (LinkStartDate) > stg.fn_XmlDateToSqlDate (LinkEndDate)) |
1 |
LinkStartDate + ' - ' + LinkEndDate |
|
DEH_ParentEquipment |
4 |
Invalid Parent Equipment Type |
NULL |
1 |
ParentEquipmentType |
|
DEH_SubstationAttributes |
0 |
No Errors |
NULL |
0 |
NULL |
|
DEH_SubstationAttributes |
1 |
Not a Substation |
NOT EXISTS (select 1 from stg.DEH_DistributionEquipment e where e.DistributionEquipmentType = 'Substation' and e.ID = stg.DEH_SubstationAttributes.ParentID and e.FileInventoryKey = stg.DEH_SubstationAttributes.FileInventoryKey) |
1 |
NULL |
|
DEH_TransformerAttributes |
0 |
No Errors |
NULL |
0 |
NULL |
|
DEH_TransformerAttributes |
1 |
Not a Transformer |
NOT EXISTS (select 1 from stg.DEH_DistributionEquipment e where e.DistributionEquipmentType = 'Transformer' and e.ID = stg.DEH_TransformerAttributes.ParentID and e.FileInventoryKey = stg.DEH_TransformerAttributes.FileInventoryKey) |
1 |
NULL |
|
DEH_TransformerAttributes |
2 |
Invalid EffectiveTimeRange |
stg.fn_IsValidXmlDate(LinkStartDate)=0 OR stg.fn_IsValidXmlDate(LinkEndDate)=0 OR (stg.fn_XmlDateToSqlDate (LinkStartDate) > stg.fn_XmlDateToSqlDate (LinkEndDate)) |
1 |
LinkStartDate + ' - ' + LinkEndDate |
|
MDI_Account |
0 |
No Errors |
NULL |
0 |
NULL |
|
MDI_Account |
1 |
Invalid AccountId |
NULL |
1 |
AccountID |
|
MDI_Account |
2 |
Invalid AccountLinkRange |
stg.fn_IsValidXmlDate(LinkStartDate)=0 OR stg.fn_IsValidXmlDate(LinkEndDate)=0 OR (stg.fn_XmlDateToSqlDate (LinkStartDate) > stg.fn_XmlDateToSqlDate (LinkEndDate)) |
1 |
LinkStartDate + ' - ' + LinkEndDate |
|
MDI_Account |
4 |
Invalid Account Analytical Status |
((StatusCode is not null) AND StatusCode not in (select StatusCode from mstr.AnalyticalStatusAccount)) |
1 |
StatusCode |
|
MDI_Account |
8 |
Invalid Account Analytical Status Commodity Type |
((StatusCommodityType is not NULL) AND StatusCommodityType not in ('Water', 'Gas', 'Electric')) |
1 |
StatusCommodityType |
|
MDI_Account |
16 |
Invalid Account Status Start Date |
stg.fn_IsValidXmlDate(StatusStartDate)=0 |
1 |
StatusStartDate |
|
MDI_Address |
0 |
No Errors |
NULL |
0 |
NULL |
|
MDI_Channel |
0 |
No Errors |
NULL |
0 |
NULL |
|
MDI_Channel |
1 |
Invalid Channel Number |
NULL |
1 |
convert(nvarchar,ChannelNumber) |
|
MDI_Channel |
2 |
Invalid Unit |
(IsNew=1 and Unit is NULL) OR ((Unit is not NULL) and Unit not in (select UnitID from mstr.Unit)) |
1 |
Unit |
|
MDI_Channel |
4 |
Invalid PowerFlowDirection |
(PowerFlowDirection is NOT NULL) and PowerFlowDirection not in ('Delivered','Received') |
1 |
PowerFlowDirection |
|
MDI_Channel |
8 |
Invalid PhaseConfig |
(PhaseConfig is NOT NULL) and PhaseConfig not in ('Unknown','A','B','C','AB','BC','AC','ABC') |
1 |
PhaseConfig |
|
MDI_Channel |
16 |
Invalid UtilizationType |
(UtilizationType is NOT NULL) and UtilizationType not in ('CoGen','General','Losses','Net','Outage','SiteContrib','SiteTotal','SubMeter','Undefined') |
1 |
UtilizationType |
|
MDI_Channel |
32 |
Invalid ReadingType |
(ReadingType is NOT NULL) and ReadingType not in ('Accumulating','CumulativeDemand','Undefined') |
1 |
ReadingType |
|
MDI_Channel |
64 |
More than one channels with the same Channel Number |
NULL |
1 |
ChannelNumber |
|
MDI_Channel |
128 |
More than one channels with the same UOM |
NULL |
1 |
Unit + ' - ' + PowerFlowDirection + ' - ' + PhaseConfig + ' - ' + UtilizationType |
|
MDI_Device |
0 |
No Errors |
NULL |
0 |
NULL |
|
MDI_Device |
1 |
Invalid DeviceId |
NULL |
1 |
DeviceId |
|
MDI_District |
0 |
No Errors |
NULL |
0 |
NULL |
|
MDI_District |
1 |
Invalid DistrictId |
NULL |
1 |
DistrictId |
|
MDI_District |
2 |
Invalid FlowDirection |
FlowDirection not in ('InFlow', 'OutFlow') |
1 |
FlowDirection |
|
MDI_Meter |
0 |
No Errors |
NULL |
0 |
NULL |
|
MDI_Meter |
1 |
Invalid MeterID |
NULL |
1 |
MeterID |
|
MDI_Meter |
2 |
Missing District data for a District Meter |
NULL |
1 |
NULL |
|
MDI_Meter |
4 |
Invalid MeterLinkRange |
stg.fn_IsValidXmlDate(LinkStartDate)=0 OR stg.fn_IsValidXmlDate(LinkEndDate)=0 OR (stg.fn_XmlDateToSqlDate (LinkStartDate) > stg.fn_XmlDateToSqlDate (LinkEndDate)) |
1 |
LinkStartDate + ' - ' + LinkEndDate |
|
MDI_Meter |
8 |
MeterSetMemberType is mandatory for Compound meters |
(MeterSetMemberType is NULL) and IsNULL(MeterSetType,'Single')<>'Single' |
1 |
NULL |
|
MDI_Meter |
16 |
Invalid MeterSetMemberType |
(MeterSetType='CompoundMeter') and (MeterSetMemberType not in ('Large','Small' )) |
1 |
MeterSetMemberType |
|
MDI_ParentTransformer |
0 |
No Errors |
NULL |
0 |
NULL |
|
MDI_ParentTransformer |
1 |
Invalid TransformerID |
NULL |
0 |
TransformerID |
|
MDI_ParentTransformer |
2 |
Invalid TransformerLinkRange |
stg.fn_IsValidXmlDate(LinkStartDate)=0 OR stg.fn_IsValidXmlDate(LinkEndDate)=0 OR (stg.fn_XmlDateToSqlDate (LinkStartDate) > stg.fn_XmlDateToSqlDate (LinkEndDate)) |
1 |
LinkStartDate + ' - ' + LinkEndDate |
|
MDI_ServicePoint |
0 |
No Errors |
NULL |
0 |
NULL |
|
MDI_ServicePoint |
1 |
Invalid ServicePointId |
NULL |
1 |
ServicePointId |
|
MDI_ServicePoint |
2 |
Invalid TimeZone |
(IsNew=1 and (TimeZone is NULL)) OR ((TimeZone is not null) AND TimeZone not in (select TimeZoneID from mstr.TimeZone)) |
1 |
TimeZone |
|
MDI_ServicePoint |
4 |
Missing or Invalid CommodityType |
(IsNew=1 and (CommodityType is NULL)) OR ((CommodityType is not NULL) AND CommodityType not in ('Water', 'Gas', 'Electric')) |
1 |
CommodityType |
|
MDI_ServicePoint |
8 |
Invalid Cathodic Protection Station |
|
1 |
NULL |
|
MDI_SPGroup |
0 |
No Errors |
NULL |
0 |
NULL |
|
MDI_UDA |
0 |
No Errors |
NULL |
0 |
NULL |
|
PBC_AccountProgram |
8 |
Duplicate Account Program in same File |
NULL |
1 |
AccountProgramID |
|
PBC_AccountVersion |
0 |
No Errors |
NULL |
0 |
NULL |
|
PBC_AccountVersion |
1 |
Invalid ProgramID |
NULL |
1 |
AccountProgramID |
|
PBC_MeterProgram |
0 |
No Errors |
NULL |
0 |
NULL |
|
PBC_MeterProgram |
8 |
Duplicate Meter Program in same File |
NULL |
1 |
MeterProgramID |
|
PBC_MeterProgram_IntervalChannel |
0 |
No Errors |
NULL |
0 |
NULL |
|
PBC_MeterProgram_IntervalChannel |
1 |
Invalid Channel Number |
NULL |
1 |
convert(nvarchar,ChannelNumber) |
|
PBC_MeterProgram_Register |
0 |
No Errors |
NULL |
0 |
NULL |
|
PBC_MeterProgram_Register |
1 |
Invalid Channel Number |
NULL |
1 |
convert(nvarchar,RegisterNumber) |
|
PBC_MeterProgram_Register |
2 |
Invalid Unit |
(IsNew=1 and UOM is NULL) OR ((UOM is not NULL) and (CASE WHEN charindex('_',UOM,0) = 0 THEN UOM ELSE substring(UOM,0,charindex('_',UOM,0)) END not in (select UnitID from mstr.Unit))) |
1 |
UOM |
|
PBC_MeterVersion |
0 |
No Errors |
NULL |
0 |
NULL |
|
PBC_MeterVersion |
1 |
Invalid ProgramID |
NULL |
1 |
MeterProgramID |
|
PBC_ServicePoint |
0 |
No Errors |
NULL |
0 |
NULL |
|
PBC_ServicePoint |
1 |
Invalid ServicePointId |
NULL |
1 |
ServicePointId |
|
PBC_ServicePoint |
2 |
Invalid TimeZone |
(IsNew=1 and (TimeZone is NULL)) OR ((TimeZone is not null) AND TimeZone not in (select TimeZoneID from mstr.TimeZone)) |
1 |
TimeZone |
|
PBC_ServicePoint |
4 |
Ignore PBC Adds is set - new ServicePoint is Ignored |
NULL |
1 |
NULL |
|
PBC_ServicePointProgram |
0 |
No Errors |
NULL |
0 |
NULL |
|
PBC_ServicePointProgram |
1 |
Invalid ServicePointProgramId |
NULL |
1 |
ServicePointProgramId |
|
PBC_ServicePointProgram |
2 |
Invalid TimeZone |
(IsNew=1 and (TimeZone is NULL)) OR ((TimeZone is not null) AND TimeZone not in (select TimeZoneID from mstr.TimeZone)) |
1 |
TimeZone |
|
PBC_ServicePointProgram |
4 |
Missing or Invalid CommodityType |
(IsNew=1 and (CommodityType is NULL)) OR ((CommodityType is not NULL) AND CommodityType not in ('Water', 'Gas', 'Electric')) |
1 |
CommodityType |
|
PBC_ServicePointProgram |
8 |
Duplicate ServicePoint Program in same File |
NULL |
1 |
ServicePointProgramID |
|
PBC_ServicePointVersion |
0 |
No Errors |
NULL |
0 |
NULL |
|
PBC_ServicePointVersion |
1 |
Invalid ProgramID |
NULL |
1 |
ServicePointProgramID |
|
WeatherReading |
0 |
No Errors |
NULL |
0 |
NULL |
|
WeatherReading |
1 |
Invalid Channel Id |
NULL |
1 |
WeatherStationId+':'+convert(nvarchar, ChannelNumber) |