commit failed object type transaction sale item key"key number"
Problem Statement :-
Getting an error "commit failed object type transaction sale item key"key number" while completing the sale transaction .
Proposed solution:-
Check the POS log file if below error occur
"Violation of PRIMARY KEY constraint 'PK_TilCashDrawerLog'. Cannot insert duplicate key in object 'dbo.TilCashDrawerLog'. The duplicate key value is ()."
Steps if any:-
Need to increase SysNextNumber
select * from SysNextNumber where NextNumberID=''Table.rtlStoredata '
update SysNextNumber
set NextNumber='Table.rtlStoreata +10000(according to requirment )
select * from CfgSiteInformation
select len(30000000000003384)
select * from Trxtransactionreceipt where TransactionReceiptKey like '30%' and len(TransactionReceiptKey)=17 order by TransactionReceiptKey desc
Related Articles
Getting an error "commit failed object type transaction sale item key"key number" while completing
Problem Statement :- Getting an error "commit failed object type transaction sale item key"key number" while completing the sale transaction Solution:- Check the db fragmentation by using below query SELECT top 100 OBJECT_NAME(i.OBJECT_ID) AS ...Till commit failed - Object type - Master till key - When new store is created
Environment: iVend 6.5 with SAP B1 9.5 Problem Statement: Error while creating new tills in master till for new stores displayed error message - Commit Failed - Object type - Master till key Error Screenshot: Symptoms: Error while creating new tills ...Error when completing transactions on POS "Commit failed. Object Type - TransactionSaleItem, Key
iVend Version: 6.5.6 Problem Statement: Error when completing transactions on POS "Commit failed. Object Type - TransactionSaleItem, Key - 0" Proposed Solution/Workaround: Product id is duplicate (one is created from HO and another one is created ...Relation Between Sale Transaction and Refund Transaction (database level)
Environment: iVend 6.5 Update 6 , 6.6 with SAP B1 9.2 Problem statement: Relation Between Sale Transaction and Refund Transaction (database level) Symptoms: Relation Between Sale Transaction and Refund Transaction (database level) Resolution/Work ...Error Payment Processor: TRANSACTION NOT COMPLETE – Failed on Com Port
Problem statement Error in sale transaction while payment from Card Reader fails to respond to iVend. (Error Payment Processor: TRANSACTION NOT COMPLETE – Failed on Com Port [9] Access..) Product version iVend 6.6 Proposed solution/workaround Steps ...