ETL (Extract Transform Load) Engine is not importing data into ION EEM.



Goals and Symptoms

This error appears in the Windows ETL Event Log:
2009-11-17 09:33:15,758 FATAL ETL Engine (ETL Job Name) - Thread ID (5) - Job Execution Failed - State will not be saved.
System.ApplicationException: Task Execution Failed ---> System.ApplicationException: Task EEM Load Task failed ---> System.ApplicationException: Error in Source Quantity thread ---> System.ApplicationException: Source validation for Insert failed: source name is missing;
at PowerMeasurement.Classification.Data.SourceDAO.ValidateSourceForInsert(Source source, Boolean throwOnFailure)
at PowerMeasurement.Classification.Data.SourceDAO.ValidateSourceForInsert(Source source)
at PowerMeasurement.Classification.Data.SourceDAO.InsertSource(Source source, SqlConnection connection, SqlTransaction transaction)
at PowerMeasurement.Classification.Data.SourceDAO.Save(Source source, SqlConnection connection, SqlTransaction transaction)
at PowerMeasurement.Tactical.Common.IONEEMUtilities.SourceMeasurementUtilities.CreateIONEEMSource(String databaseConnectionString, String namespaceUri, String sourceName, String timezoneName, String sourceType)
at SchneiderElectric.ETL.EEM.EEMLoadTask.LoadSourceQuantity(SQData pair)
at SchneiderElectric.ETL.Core.SQThreadExecuter.ProcessinglePair(Object threadData)
--- End of inner exception stack trace ---
at SchneiderElectric.ETL.Core.SQThreadExecuter.ProcessAll()
at SchneiderElectric.ETL.Core.SQThreadLoadTask.Load(TaskData data)
at SchneiderElectric.ETL.Core.LoadTask.DoWork()
at SchneiderElectric.ETL.Core.Task.Execute()
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at SchneiderElectric.ETL.Core.Job.Execute()
at SchneiderElectric.ETL.Engine.JobController.Execute(String jobName, Boolean sleep)

This same ETL error message appears in the ETL Log file if the ETL is enabled to log to a file. In the ETL trace log this error appears:

2009-11-17 11:15:46, 295 DEBUG ETL Engine (ETL Job Name) - Thread ID (18) - EEM Load Task: Could not find source () with namespace (e8c954b1-ecad-4be8-8a81-41a514dc1302) or namespace ( in EEM

for existing sources the trace log shows this informational message:

2009-11-17 11:15:46,295 DEBUG ETL Engine (ETL Job Name) - Thread ID (12) - EEM Load Task: Existing Source found (Main Meter 2) with namespace ( in EEM

Causes and Fixes

In the ETL Engine open the job for editing that is having the problem. In the error messages above we can see the ETL Job Name is the name of the ETL job with the problem. On the mappings find the sources that are not mapped properly. Most likely the case is that the end name has not been assigned to 1 or more sources causing the error messages and preventing the ETL Engine from properly importing data into the ION EEM system.


(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/6bb82415190952dbc12576a900583f09/fl_block_5/0.1AD6?OpenElement&FieldElemFormat=gif)
Date Created: January 6, 2010
Last Revised: January 12, 2010
Original Author: MN
All content © 1992-2010 Schneider Electric

Legacy KB System (APS) Data: RESL201020 V1.0, Originally authored by MiNe on 01/12/2010, Last Edited by MiNe on 01/12/2010
Related ranges: EEM V3.95