Article Details
Id:19122
Product:finPOWER Connect
Type:FIX
Version:3.04.04
Opened:29/03/2022
Closed:29/03/2022
Released:09/06/2022
Job: J028532

Database Purge; Master Clear fails with an error

The Master Clear in the Database Purge function may fail with an error if the Zepto (Split Payments) Banking Interface has been used.

The error will look like "Failed to Purge Database. Failed to perform a Master clear. Failed to execute SQL. The DELETE statement conflicted with the REFERENCE constraint "RI_ISServiceLogBankTran_1". The conflict occurred in database "[Database]", table "dbo.BankTransaction", column 'ApiServiceLogPk'. The statement has been terminated.".