Data Publication Failing : Unable to obtain database write access due to deadlock
I have a Data Publication for a Solution that contains two Applications. When the Data publication runs I get an error message on the "Run Detail" screen for the main table of each application. The error is "The Data Publication failed. The following exception occured: An item with the same key has already been added.. Please review the log file for additional detail."
In the logs I have an error : "Unable to obtain database write access due to deadlock"
I was publishing to a new target database that had no tables or records.
Any guidance on where to look? corrupt records maybe??
Thanks @DavidPetty , yes I have done that and confirmed that both the apps are failing. I am getting the same error in both apps. Do you have any recommendations on how to find / look for the bad records that could be causing the problems?
For both apps I can see that all the tables/records are being published except for the primary tables i.e. the tables that include subform data etc.