Thursday, September 12, 2013

Could not Reserve Record Error while Updating Grade Step Placements



Run the following scripts to Update Object version number which is the cause of this issue

Step 1:
create table per_spinal_point_plac_bkp as select * from per_spinal_point_placements_f;

Step 2: (Check no of rows to be updated)
SELECT count(*)
  FROM per_spinal_point_placements_f
 WHERE object_version_number IS NULL;

Step 3: Update Object Version Number

UPDATE per_spinal_point_placements_f
   SET object_version_number = 1
 WHERE object_version_number IS NULL;

No comments:

Post a Comment