Error: Cannot insert duplicate key row in object 'dbo.VOLUNTEERASSIGNMENT' with unique index 'UIX_VOLUNTEERASSIGNMENT_VOLUNTEERID_JOBOCCURRENCEID_DATE'

Error occurs when attempting to remove multiple assigned job schedules via the 'Schedule multiple days' form.


Data could not be saved.
Cannot insert duplicate key row in object 'dbo.VOLUNTEERASSIGNMENT' with unique index 'UIX_VOLUNTEERASSIGNMENT_VOLUNTEERID_JOBOCCURRENCEID_DATE'.
The duplicate key value is (a096d282-c34a-4c26-a215-e78c70ab7b43, 60477551-a278-44ea-8b89-58c16d2bc011, Jul 1 2014 12:00AM).

Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.  

Environment

 3.0.516.34
 3.0.516, Service Pack 11 ; 4.0.138, patch 2

Was this article helpful?