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

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>'

Resolution

Cumulative update information

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

Status

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

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 .
Propiedades

Id. de artículo: 3088327 - Última revisión: 31 dic. 2015 - Revisión: 1

Comentarios