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.".