I would suggest writing a self-contained script that creates the table, inserts a single record, and updates that record. Present that for consideration along with a description or capture of the results of running the script on your machine.
But not all the records fail the update...
We won't ge anywhere until you show the actual sql and the actual error(s)