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.