Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: "Cannot insert duplicate Key with unique index" error occurs when you run BizTalk Server backup job

FIX: "Cannot insert duplicate Key with unique index" error occurs when you run BizTalk Server backup job

View products that this article applies to.

Symptoms

Consider the following scenario:
  • You configure log shipping in Microsoft BizTalk Server.
  • You have one or more instances of SQL Server, and there's a SQL Server Agent job that hits multiple databases across job steps.
  • You run the BizTalk Server backup job.
In this scenario, the log shipping configuration fails, and you receive the following error message:
Msg 2601, Level 14, State 1, Procedure bts_ImportSQLAgentJobs, Line 59
Cannot insert duplicate key row in object '<object name> ' with unique index '<index name>'

↑ Back to the top

Resolution

Cumulative update information

This issue was first fixed in the following cumulative update of BizTalk Server:

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

References

For information about the service packs and cumulative update list for BizTalk Server, see KB 2555976: Service pack and cumulative update list for BizTalk Server .

For more information about BizTalk Server hotfixes, see KB 2003907: Information about BizTalk hotfixes and cumulative update support .

↑ Back to the top

Keywords: kb, kbqfe, kbsurveynew, kbfix, kbexpertiseadvanced

↑ Back to the top

Article Info
Article ID : 3088327
Revision : 1
Created on : 1/7/2017
Published on : 12/31/2015
Exists online : False
Views : 408