I am not using UUID, instead, I set the ID explicitly and it works well.

Thanks for looking into this issue. The tricking thing is, if I create a new record with this record name using code, I will got an error saying the record exists and cannot insert.