try running SQL Profiler with the error message options turned on, it is likely trying to insert and existing record or something like that.