Our Brands

Welcome to the Schneider Electric Website

Welcome to our website.
		
How can we help you today?
Cannot Insert Duplicate Key

Issue

SQL Server Management Studio throws the following error when assigning data to a location where data already exists, ex. reassigning data to a source that is already populated when performing the functions in How to move historical data from an existing device to another device in Power Monitoring Expert | Schneider Electric USA

"Cannot insert duplicate key row in object 'dboDataLog2' with unique index 'CIX_DataLog2_SourceID_QuantityID_TimestampUTC'. The duplicate key value is (...)"

error

Product Line

Power Monitoring Expert 2020

Power Monitoring Expert 2021

Power Monitoring Expert 2022

Power Monitoring Expert 2023

Power Monitoring Expert 2024

Environment

Microsoft SQL Server Management Studio

Cause

The device to which data is being assigned already has existing entries for the specific time stamps included in the script. This may happen due to an overlap in time between disabling and enabling the two devices that data is being transferred between. In the following example the error is seen when trying to insert data to the source in the first column from 1/28/2025 8:15:00 AM onwards.

data

Resolution

Be sure to take an updated backup of the ION_Data database before making these changes

Remove the existing data, which is unwanted and intended to be replaced by using the following scripts, use desired SourceID (verify from [ION_Data].[dbo].[Source]) and TimestampUTC based on the system.

DELETE FROM [ION_Data].[dbo].[DataLog2] where SourceID = 9 and QuantityID = 69 and TimestampUTC > '2022-09-14' and TimestampUTC <  '2022-09-15'

Proceed with https://www.se.com/us/en/faqs/FA271539/

Schneider Electric Philippines

Cannot Insert Duplicate Key

Issue

SQL Server Management Studio throws the following error when assigning data to a location where data already exists, ex. reassigning data to a source that is already populated when performing the functions in How to move historical data from an existing device to another device in Power Monitoring Expert | Schneider Electric USA

"Cannot insert duplicate key row in object 'dboDataLog2' with unique index 'CIX_DataLog2_SourceID_QuantityID_TimestampUTC'. The duplicate key value is (...)" 

error

Product Line

Power Monitoring Expert 2020

Power Monitoring Expert 2021

Power Monitoring Expert 2022

Power Monitoring Expert 2023

Power Monitoring Expert 2024

 

Environment

Microsoft SQL Server Management Studio

 

Cause

The device to which data is being assigned already has existing entries for the specific time stamps included in the script. This may happen due to an overlap in time between disabling and enabling the two devices that data is being transferred between. In the following example the error is seen when trying to insert data to the source in the first column from 1/28/2025 8:15:00 AM onwards. 

data

 

Resolution

Be sure to take an updated backup of the ION_Data database before making these changes

Remove the existing data, which is unwanted and intended to be replaced by using the following scripts, use desired SourceID (verify from [ION_Data].[dbo].[Source]) and TimestampUTC based on the system. 

 

DELETE FROM [ION_Data].[dbo].[DataLog2] where SourceID = 9 and QuantityID = 69 and TimestampUTC > '2022-09-14' and TimestampUTC <  '2022-09-15'

 

Proceed with https://www.se.com/us/en/faqs/FA271539/

 

 

 

 

Schneider Electric Philippines

Explore more
Range:
Explore more
Range:
Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more
Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more
Explore more
Range:
Explore more
Range:

Need help?

  • Product Selector

    Quickly and easily find the right products and accessories for your applications.

  • Get a Quote

    Start your sales inquiry online and an expert will connect with you.

  • Where to buy?

    Easily find the nearest Schneider Electric distributor in your location.

  • Help Center

    Find support resources for all your needs, in one place.

1. 什么是工业物联网?

这一概念将工业机械和设备与先进的传感器、软件和网络技术相结合。通过这种方式,您可以创建并连接一个自动化的生态系统。这样的数字化使智能工厂能够提高效率、员工安全性和可持续性。

工业物联网在制造业中的应用以及工业物联网解决方案的使用加速了制造过程并减少了浪费。因此,在保证地球安全的同时,生产力也得到提高。显然,它还可以减少停机时间,降低维护成本,因为它能够提供实时数据,从而引入预测性维护。

2.工业物联网解决方案如何推动工业4.0?

工业4.0指的是工业革命的一个新阶段,主要关注互连互通、自动化、机器学习和实时数据。工业4.0(也称为IIoT技术或智能制造)将物理生产和运营与智能数字技术、机器学习和大数据相结合。所有这些都为专注于制造和供应链管理的公司创造了一个更全面、更互联互通的生态系统。

工业物联网解决方案可应用于解决物流、制造和供应链问题,使制造商和消费者都获益。在现有企业中利用工业物联网是工业物联网实施的一个互利方面,它可以降低运营成本,同时确保行业各种流程中的最高质量。

3.使用我们的工业物联网解决方案有何益处?

我们的工业物联网解决方案非常适合各种行业的多任务处理服务。过程自动化、机械、食品和饮料、水和废水、能源和化学品、水泥、金属和采矿等行业使用这些解决方案可提高工作环境的安全性、提高效率并减少碳足迹。

显然,使用工业物联网解决方案有助于整个生态系统,并会带来大量创新性变化,这对于要求非常高的正常运行时间和期待预测性维护的行业来说至关重要。

  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and Contact Center
  • Find our Offices
  • Get a Quote
  • Where to buy
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.