Notifications

253 views

Description

When trying to ALTER a large table though methods such as deletion, field type change, or field length increase, transactions times out and gets cancelled on the back end.

Steps to Reproduce

  1. Create a new column directly on the [task] table (the table needs to have over 2 million records for larger ALTER).
    • Creating a column will not time out, this has already been tested
  2. From the UI, delete a column or change the Field Type of the new column created on the [task] table.

Expected results: The transactions should complete even if it goes over the 298 seconds.

Actual results: The Transaction times out and gets cancelled from the back end causing orphaned metadata (which connects to PRB1315639 - When ALTERS are cancelled it leaves behind orphaned metadata)

Workaround

Please consult KB0547328 - Creating or altering a field on a large table from the UI can be canceled by "UI Transactions" Quota Rule 


Related Problem: PRB1315581

Seen In

Fuji Patch 10
Fuji Patch 11
Fuji Patch 11 Hot Fix 2
Fuji Patch 12 Hot Fix 1
Fuji Patch 13 Hot Fix 1
Fuji Patch 7 Hot Fix 5
Fuji Patch 7 Hot Fix 9
Fuji Patch 9 Hot Fix 1
Helsinki Patch 2 Hot Fix 2
SR - IntegrationHub - Microsoft SharePoint Integration v1.0.4
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - PA Premium Integration - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - ITOM - CMDB CI Class Models - 201909
SR - ITOM - Discovery and Service Mapping - 201908
SR - ITOM - Discovery and Service Mapping - v1.0.35
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response Flow Designer Content - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Security Incident Response UI Patch - London 2019 Q2 v.6.2.3
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - SIR - Threat intelligence - New York 2019 Q3
SR - VR - Vulnerability Response - New York 2019 Q3

Intended Fix Version

Quebec

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-08-06 11:23:19
Published:2019-05-20