Unable to commit update set with atf tables related errors. - Support and Troubleshooting

Unable to commit update set with atf tables related errors. Issue  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 Navigate to the two records in sys_dictionary. https:// .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 Change the type from currency to decimal. Save and recommit the update set.