PM86163: SA crash when Merge between encyclopedias by Violation of PRIMARY KEY constraint error

APAR status

• Closed as duplicate of another APAR.

Error description

• SA crashes when Merge between encyclopedias by Violation of
  PRIMARY KEY constraint error
  
  Select Tools/Merge/
  Select 'Always replace Target'
  SA will crash showing the following error message:
  
  A database error has occurred: (250, 104, 0, 460, 1)
  Number = 80040e2f;
  NativeCode = 2627;
  Source = Microsoft OLE DB Provider for SQL Server;
  Desc = Violation of PRIMARY KEY constraint 'PK_ID'. Cannot
  insert duplicate key in object 'dbo.Entity'.
  Number = 80040e2f;
  NativeCode = 3621;
  Source = Microsoft OLE DB Provider for SQL Server;
  Desc = The statement has been terminated.
  
  Workaround:
  
  Employ the 'Use most recent' collision option.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• This APAR is a duplicate of PM86164
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels