I have found an interesting bug where incremental content deployment fails with the following error message:
“Content deployment job ‘Incremental Deploy’ failed.The exception thrown was ‘System.Data.SqlClient.SqlException’ : ‘Violation of PRIMARY KEY constraint ‘PK__#ExportObjects____192930E1’. Cannot insert duplicate key in object ‘dbo.#ExportObjects’. The statement has been terminated.'”
I have found that this occurs if the same page is approved more than once between incremental updates.
I have been informed that Microsoft are aware of this issue and are currently working on a hotfix that should be released shortly. I have just been informed that the hotfix is now available, to obtain the fix you will need to raise a support call (KB Article Number(s): 934577, 935958, 936867, 937038)
Check out the MOSS bugs list page for other MOSS bugs.