After wondering why exports failed to my P4 I dug around the logfiles generated to find it’s being caused by an exception when inserting records into the PlaytlistEntity table. SQL statement fails on a constaint with the ID of the track.
Really could do with a DB integrity checker, this could remove the duplicate entries and report which ones and allow the collection db to be used again.