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 TableName, i.name AS IndexName,
indexstats.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')
indexstats
INNER JOIN sys.indexes i ON i.OBJECT_ID = indexstats.OBJECT_ID
WHERE indexstats.avg_fragmentation_in_percent > 30
AND i.index_id = indexstats.index_id
ORDER BY 3 desc
If the fragmentation is very high then optimize the db
Related Articles
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 ...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 ...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 ...Getting integration error "System.Exception: DI:To generate this document, first define the number
Problem Statement Integration error "generate this document, first define the numbering series in the Administration module" Issue in detail Getting integration error "System.Exception: DI:To generate this document, first define the numbering series ...Coupon is getting applied only for 1 line item in the Sale transaction
Problem: - Coupon is getting applied only for 1 line item in the Sale transaction. How can we use the same coupon for all the line items in the same transaction? Solution: - As per above screenshot coupon is configured to give a discount of 5% on one ...