Notifications

22 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

Intended Fix Version

Orlando

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:2019-07-19 09:01:42
Published:2019-05-20