Article Details
Id: | 18595 |
Product: | finPOWER Connect |
Type: | NEW |
Version: | 3.04.02 |
Opened: | 16/09/2021 |
Closed: | 16/09/2021 |
Released: | 02/12/2021 |
Job: | J027412 |
High Importance |
Clients; may fail to delete a Client or fail to combine Clients
Attempting to delete a Client may fail with an error like "Failed to delete Client. Failed to execute SQL. The DELETE statement conflicted with the REFERENCE constraint "RI_ClientClientEmployme_1". The conflict occurred in database "[databasename]", table "dbo.ClientEmployment", column 'OrganisationClientPk'. The statement has been terminated.".
Note, this error may also occur with combining Clients.
This issue occurs if the Client has an Employment record.