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)


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 - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - Policy and Compliance - Madrid 2019 Q2

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-12-19 12:23:12