Concurrency Exception
From Logic Wiki
if you receive this exception check stored procedures. in this case the nulls at the last line were missing.
USE [Aviva_Dev]
GO
/****** Object: StoredProcedure [dbo].[isp_EmpBankUpdateCommand] Script Date: 20/02/2015 15:54:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[isp_EmpBankUpdateCommand]
(
@EmployeeID int,
@Sequence int,
@RecordID int,
@SortCode varchar(50),
@AccountNo varchar(50),
@AccountName varchar(50),
@AccountTypeID int,
@AccountRollNo varchar(50),
@PercentAmount float,
@Original_EmployeeID int,
@Original_Sequence int,
@Original_RecordID int,
@Original_AccountName varchar(50),
@Original_AccountNo varchar(50),
@Original_AccountRollNo varchar(50),
@Original_AccountTypeID int,
@Original_PercentAmount float,
@Original_SortCode varchar(50)
)
AS
SET NOCOUNT OFF;
UPDATE isEmployeeBank SET EmployeeID = @EmployeeID, RecordID = @RecordID, SortCode = @SortCode,
AccountNo = @AccountNo, AccountName = @AccountName, AccountTypeID = @AccountTypeID,
AccountRollNo = @AccountRollNo, PercentAmount = @PercentAmount, Sequence = @Sequence
WHERE (EmployeeID = @Original_EmployeeID) AND (RecordID = @Original_RecordID)
AND (Sequence = @Original_Sequence)
AND (AccountName = @Original_AccountName OR @Original_AccountName IS NULL)
AND (AccountNo = @Original_AccountNo OR @Original_AccountNo IS NULL)
AND (AccountRollNo = @Original_AccountRollNo OR @Original_AccountRollNo IS NULL)
AND (AccountTypeID = @Original_AccountTypeID OR @Original_AccountTypeID IS NULL)
AND (PercentAmount = @Original_PercentAmount OR @Original_PercentAmount IS NULL)
AND (SortCode = @Original_SortCode OR @Original_SortCode IS NULL)