Forums

Hi,

for testing purposes I am trying to import multiple BOM versions against a single BOM. (1 item -> 1 BOM -> Multiple BOM versions)

The file I am importing contains just 2 rows of data against 1 BOM and ITEM and the rows have different To & From dates and Active flags.

To my mind that should be what is required to represent an obsolete BOM version and a current BOM Version.

However, when I do "Get Staging Data" it fails with a Primary key violation "Cannot insert duplicate key in to object dbo.DMFBOMVERSIONENTITY"

The primary key on DMFBOMVERSIONENTITY is:

ALTER TABLE [dbo].[DMFBOMVERSIONENTITY] ADD  CONSTRAINT [I_100994ITEMIDX] PRIMARY KEY CLUSTERED
(
    [ITEMID] ASC,
    [BOM_BOMID] ASC,
    [EXECUTIONID] ASC,
    [DEFINITIONGROUP] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF,
 ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

I have no idea what EXECUTIONID or DEFINITIONGROUP are, and for my purposes it doesn't make sense that ITEMID or BOM_BOMID should be different.

Any suggestions?

Many Thanks