Skip to Content
0
Sep 28, 2020 at 04:17 PM

Error updating receipt in table service mode

71 Views

Hello all,

I am updating receipt values such as quantities or prices, this works perfectly in quick service mode but in table mode I am getting the following error:

javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: DELETE on table 'SALESITEM' caused a violation of foreign key constraint 'RDRSLSTMSSCTSLSTMS' for key (3b87aed9-d1aa-4784-890f-c4809bdad43e).  The statement has been rolled back.
Error Code: 20000
Call: DELETE FROM CCO.SALESITEM WHERE (OBJECTKEY = ?)
	bind => [1 parameter bound]
Query: DeleteObjectQuery(com.sap.scco.ap.pos.entity.SalesItemMetaDataEntity@d5a9eaf4)

the error occurs exactly when updating the receipt

receiptManager.updateReceipt(receipt, true);

does anyone know what happens here?