NEW3.04.02 · Released 2 December 2021
High Importance
NEWfinPOWER Connect
Released in
3.04.02
2 December 2021
  1. Opened16 Sep
  2. Closed16 Sep
  3. Released2 Dec
Article 18595 Job J027412

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.