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://<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
- Change the type from currency to decimal.
- Save and recommit the update set.