Can you recommit an already commited update set?

[house1]

any idea on below step 3 ??  recommit the update set

My update set is already committed

Unable to commit update set with atf tables related errors.

269 views

Number: KB0752190 

Description

Symptoms

Unable to commit update set with the following error in the node logs

SEVERE *** ERROR *** An error occurred trying to alter storage table: [var__m_atf_input_variable_a5836cd7739023005a59e5c754f6a700]

FAILED TRYING TO EXECUTE ON CONNECTION glide.19 (connpid=332215): ALTER TABLE a5836cd7739023005a59e5c754f6a7 MODIFY /*Currency field widening*/ `hourly_rate` DECIMAL(20,4) /* instancename, gs:glide.scheduler.worker.7, tx:77cfff28db5abf00158493afaa96199a */ 
Syntax Error or Access Rule Violation detected by database (Table 'instancename.a5836cd7739023005a59e5c754f6a7' doesn't exist)

Or the following 

Changes for table var__m_atf_input_variable_a5836cd7739023005a59e5c754f6a700 failed to commit

and

Changes for table var__m_atf_input_variable_4fd1e497739023005a59e5c754f6a793 failed to commit

Cause

Failure of alter of the currency field widening on table var__m_atf_input_variable_a5836cd7739023005a59e5c754f6a700 and var__m_atf_input_variable_4fd1e497739023005a59e5c754f6a793

Resolution

1. Navigate to the two records in sys_dictionary.
   • https://<instance_name>.service-now.com/nav_to.do?uri=%2Fsys_dictionary_list.do%3Fsysparm_query%3DnameSTARTSWITHvar__m_atf_input_variable_a5836cd%255EORnameSTARTSWITHvar__m_atf_input_variable_4fd1e4977390%255Einternal_type%253Dcurrency%26sysparm_first_row%3D1%26sysparm_view%3D
2. Change the type from currency to decimal.
3. Save and recommit the update set.

[Harsh Vardhan]

after completing the first and second point, try to click on "preview update" button on update set again and see if you are getting an error or not. if not then commit it 

[Brad Tilton · Accepted solution]

If you've already committed an update set and want to recommit it, you can load it back into your instance via an xml and then the state should change back to Loaded from Committed allowing you to preview and commit again.

[house1]

Thanks-you Brad!  that worked!!  now we know what “recommit” means!

[suneel226]

Hi Brad!

How can I make changes in the committed updated set which is moved from Dev to another instance (INT) without creating new update set in dev. I have to make some changes in the previous update which is committed already and not moved to Q from INT.