Error 2147217873 Not allowing sales

When you login to RMS all looks ok, ring up sale still ok, hit enter to finish it and you get the above error number with:

this statement has been terminated source: MS OLE DB Provider SQL Server SQL state: 01000 Native error: 3621 No help file available

SET NOCOUNT ON INSERT INTO transaction shiptoid, storeid,batchnumber, time, customerid, cashierid, total, sales tax, values (?,?,?......... SELECT @@ IDENTITY AS Transaction number

Any ideas would be really appreciated. Version number 1.20151

I have seen a similar problem happen with Physical Inventory and Purchaseorder etc where the POS tries to pick the next numerically incremented number for the new entry. In this case it is the TransactionNumber from the Transaction table. I think the way to fix it would be to find all the existing transactionnumbers with this query:

select transactionnumber from [transaction] order by transactionnumber

Either at the top of the list or the bottom will be an unusual entry that doesn't match the others. once you find it, change it with this query:

update [transacti> When you login to RMS all looks ok, ring up sale still ok, hit enter to