You are currently viewing the content available in Vietnam. If you are looking for information for another region, please select the correct country from the top-left dropdown in the page and 'Navigate to Browse FAQs' in the Support menu.
Issue:
ETL versions 3.0.13325.02 and 3.0.14050.01 produce the following error when attempting to extract data out of EEM.
2014-08-14 08:34:06,007 ERROR ETLEngine (Job_HTML) - Thread ID (4) - EEM Extract Task: Task EEM Extract Task failed
System.ArgumentException: An item with the same key has already been added.
System.ApplicationException: Task Execution Failed ---> System.ApplicationException: Task EEM Extract Task failed ---> System.ArgumentException: An item with the same key has already been added.
Product Line:
ION EEM 5.0
Environment:
ETL versions 3.0.13325.02 and 3.0.14050.01 with ION EEM 5.0
Cause:
There are duplicate source name(s) contained within the database.
The ETL uses the source name as a key in a dictionary to perform the extraction.
Resolution:
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
Execute the following SQL select statement to identify the duplicate source(s) :
ETL versions 3.0.13325.02 and 3.0.14050.01 produce the following error when attempting to extract data out of EEM.
2014-08-14 08:34:06,007 ERROR ETLEngine (Job_HTML) - Thread ID (4) - EEM Extract Task: Task EEM Extract Task failed
System.ArgumentException: An item with the same key has already been added.
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at SchneiderElectric.ETL.EEM50.EEMExtractTask.DataTableToDictionary(DataTable dt)
at SchneiderElectric.ETL.EEM50.EEMExtractTask.PrepareForExtract()
at SchneiderElectric.ETL.Core.SQThreadExtractTask.Extract(TaskData data)
at SchneiderElectric.ETL.Core.ExtractTask.DoWork()
at SchneiderElectric.ETL.Core.Task.Execute()
2014-08-14 08:34:06,090 ERROR ETLEngine (Job_HTML) - Thread ID (1) - A fatal exception occurred while executing the job.at SchneiderElectric.ETL.EEM50.EEMExtractTask.DataTableToDictionary(DataTable dt)
at SchneiderElectric.ETL.EEM50.EEMExtractTask.PrepareForExtract()
at SchneiderElectric.ETL.Core.SQThreadExtractTask.Extract(TaskData data)
at SchneiderElectric.ETL.Core.ExtractTask.DoWork()
at SchneiderElectric.ETL.Core.Task.Execute()
System.ApplicationException: Task Execution Failed ---> System.ApplicationException: Task EEM Extract Task failed ---> System.ArgumentException: An item with the same key has already been added.
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at SchneiderElectric.ETL.EEM50.EEMExtractTask.DataTableToDictionary(DataTable dt)
at SchneiderElectric.ETL.EEM50.EEMExtractTask.PrepareForExtract()
at SchneiderElectric.ETL.Core.SQThreadExtractTask.Extract(TaskData data)
at SchneiderElectric.ETL.Core.ExtractTask.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()
[Job Logger Finished]at SchneiderElectric.ETL.EEM50.EEMExtractTask.DataTableToDictionary(DataTable dt)
at SchneiderElectric.ETL.EEM50.EEMExtractTask.PrepareForExtract()
at SchneiderElectric.ETL.Core.SQThreadExtractTask.Extract(TaskData data)
at SchneiderElectric.ETL.Core.ExtractTask.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()
Product Line:
ION EEM 5.0
Environment:
ETL versions 3.0.13325.02 and 3.0.14050.01 with ION EEM 5.0
Cause:
There are duplicate source name(s) contained within the database.
The ETL uses the source name as a key in a dictionary to perform the extraction.
Resolution:
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
Execute the following SQL select statement to identify the duplicate source(s) :
SELECT count(Name)as countname, Name FROM SRC_Source group BY Name having count (*) > 1 order by countname
Using Edit Mode in SQL Management Studio, modify the source name(s) identified issuing the following SQL select statement: Select * from SRC_Source where Name = "(name to be edited)"
In the results pane returned from the above query, click on the Name column, and edit so that each row contains a unique value.
Released for: Schneider Electric Vietnam
Need help?
Start here!
Find answers now. Search for a solution on your own, or connect with one of our experts.
Contact Support
Reach out to our customer care team to receive more information, technical support, assistance with complaints and more.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Search FAQs
Search topic-related frequently asked questions to find answers you need.
Contact Sales
Start your sales inquiry online and an expert will connect with you.
