Physical Inventory
Why I got this error "
Create-Intfc-Entries
e:\fs92dev\sqr\ampi1000.sqr: AMIF1000 - SQL Statement =
Create-Intfc-Entries-Location: INSERT INTO PS_INTFC_PHY_A
SQL Status = 2601, SQL Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_INTFC_PHY_A' with unique index 'PS_INTFC_PHY_A'. The duplicate key value is (10000016, 4, PUCMM, 000000000095, Mar 27 2014 2:36PM, , 0, 0, PHY, ).
" when I execute the process "Generate Transactions" at Load/Match/Reconcile PI Info page?
I checked and analyzed the ampi1000.sqr, but I found that when the functions (Create-Intfc-Entries-Location & Create-Intfc-Entries-Custodian) execute, both do the same Insert to the INTFC_PHY_A table.