Article Details
Id: | 14318 |
Product: | finPOWER Connect |
Type: | FIX |
Version: | 3.00.04 |
Opened: | 27/01/2017 |
Closed: | 27/01/2017 |
Released: | 01/03/2017 |
Job: | J018524 |
Database Purge; Master Clear fails with error related to the table "TaxCertificate"
During a Database Purge the Master Clear may fail with the error "Failed to Purge Database. Failed to perform a Master clear. PHASE 1 OF CLEAR PASSED. THIS DATABASE CANNOT BE USED IN A PRODUCTION ENVIRONMENT UNLESS A MASTER CLEAR IS SUCCESSFULLY COMPLETED. Failed to execute SQL. The record cannot be deleted or changed because table 'TaxCertificate' includes related records.".
This occurs if there are TaxCertificate records where GroupTaxCertificatePk is not Null.