Notifications

168 views

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.

Article Information

Last Updated:2019-08-02 20:39:03
Published:2019-07-02