Error Handling

The ingestion process for load profiles will perform error validation on the incoming data. It will create two error validation files and one timing file, which will be located in a subdirectory of the project configurable data location directory:

1. Invalid transformers (LP_Invalid_Transformers_YYYYMMDD_HHMMSS.log)

This file will contain a list of the transformer/feeder combinations that cannot be located within the NMS model.

2. Invalid data (LP_Data_Errors_YYYYMMDD_HHMMSS.log)

This file will contain any invalid data rows along with an error code from the table below.

3. Timing (LP_Timing_YYYYMMDD_HHMMSS.log)

This file will provide timing information related to different processes occurring during the load of profile data. For example, how long it takes to read the CSV files, how long it takes to write profiles to the database, and so on.

Error Code	Error Description	Notes
LP-001	Too many fields	Expect 8 fields, 7 commas
LP-002	Too few fields	Expect 8 fields, 7 commas
LP-003	Invalid day type	The day type specified is not valid
LP-004	Invalid hour value	Should be integer type
LP-005	Invalid hour value	Should be 0 through 23
LP-006	Invalid KW value	Should be floating type
LP-007	Invalid KVAR value	Should be floating type
LP-008	Duplicate Record	Duplicated hourly record found
LP-009	Invalid KVA rating or utilization factor	These values should be present in table pf_loads
LP-010	Transformer loading exceeds the rating based on specified threshold.	The threshold can be configured in the SRS rules, currently set to 200%
LP-011	Invalid Weather Zone	The weather zone associated to the load could not be located in the configuration. Please validate table PF_WEATHER_ZONE to ensure this zone is added properly.
LP-012	Invalid temperature value should be floating type.	Should be floating type.
LP-013	Load is mapped to a zone but the zone does not appear to be a valid weather zone.	A zone was configured for the load but this zone does not appear to be configured as a weather zone. It is instead setup for something else like an individual DER forecast or Demand Response Group.
LP-014	A Null Weather Zone value was provided.	The load was configured with a null weather zone value. Validate the zone associated to the load is present in table PF_WEATHER_ZONE and forecast date is present in table PF_WEATHER_ZONE_FORECAST.
LP-015	A Null kW value was provided	The CSV file contained a record that had a null value for kW. This data will not be processed and the sample counts will not be increased. This data will be thrown away and not loaded.
LP-016	Negative Load after DER adustment	The net meter adjustment was attempting to add back load from any DER contributions. The resultant kW value is still showing negative, which is not possible.
LP--017	Overloaded Transformer	When comparing the kVA rating of the device with the metering information for transformer is shown to be significantly overloaded. This overloaded threshold is configured with SRS rule PA_OverloadThreshold.
LP-018	Negative kVAr value	The kVAr contribution from the load was found to be negative.
LP-019	Invalid Date Format	The date format provided in the CSV file was found to be invalid.
NM-001	Dist Gen data could not be located	Dist Gen information could not be located for a dist gen associated with a net metered profile.
NM-002	Dist Gen has an invalid power source	Power source is invalid for a dist gen associated with a net metered profile.
NM-003	Dist Gen Invalid Weather Zone	Weather zone is invalid for a dist gen associated with a net metered profile.
NM-004	Dist Gen Profile is invalid	The profile associated to the dist gen could not be located. This is needed to perform net metered profile processing.
NM-005	Dist Gen output exceeds the connected transformers rating based on a specified threshold.	This rule uses the same SRS rule as used for LP-010 and can be configured in the SRS rules. The NM-005 error is looking purely at Dist Gen output in comparison to the rating of the transformer - excluding any loading information.
NM-006	Dist Gen is configured with a default dist gen factor	A specific profile factor could not be determined for the designated Dist Gen unit during the net meter processing. As a result, a default factor was applied instead. For example, if weather data for December 9, 2025, at 9:00 AM was unavailable to estimate the performance of a solar unit, a default value from the distGenDefault SRS Rule configuration would be used.
NM-007	Dist Gen output is not large enough to compensate for negative load	During the net metered profile analysis, a negative value was identified. Even after accounting for the output of the associated Distributed Energy Resources (DERs), the resulting value remained negative. For example, if a net metered load shows -4kW and a solar installation behind the same transformer is generating 3kW at that time, the resulting load would be -1kW. This typically raises concerns, as it may indicate issues such as incorrect DER sizing, faulty load metering, or errors in load mapping.
NM-008	Negative Metered load with no DER	A negative net metered load was found, but no DERs were found to be present below the load point. This would generally indicate a metering issue or DER association issue.
MA-001	Invalid meter to xfmr mapping	While forming the meter to transformer mapping, an invalid relationship was found.
MA-002	Too few fields	Based on the column configuration, the meter csv file had too few fields.
MA-003	Too many fields	Based on the column configuration, the meter csv file had too many fields.
MA-004	Could not find a valid mapping to an associated transformer	The meter to transformer mapping was found to be present but the transformer is invalid or does not exist within the model.
MA-005	Invalid hour value	Should be between 0 and 23.
MA-006	Invalid hour value	Should be integer type.
MA-007	Invalid day type	The day type specified is not valid (for example, 0 = Weekday, 1 = Weekend, and so on).
MA-008	Invalid kW value	Should be floating type.
MA-009	Invalid kVAr value	Should be floating type.
MA-010	Invalid date format