When a user creates or updates a field on a large table from the UI (for example, Task), the transaction may time out and be canceled by the UI Transactions Quota Rule.
This can affect the instance in different ways:
- the database operation fails and the field is not created or altered;
- the user transaction is canceled and the update is is not captured in the current update set.

Steps to Reproduce

  1. Identify a large table with numerous columns and populated with a million records or more.
  2. Choose the current Update Set.
  3. Follow one of these scenarios:
    • Create a new field from the system dictionary or from the table maintenance
    • Update the dictionary record of a field to increase the max_length

Observe the screen going blank after several minutes. The following may have occurred:

  • The field has been created in the table, but there is no record of it in the current Update Set.
  • The field was created on the database, but the related Dictionary record is missing.
  • The field length change is not done on the database, but the Dictionary record is updated. If the field was being extended, longer values will not be stored. There is no update record in the current Update Set.



1. If creating a new field, use the Form/List Configuration slushbucket. This will create the new field(s) using a Progress Worker which is not subject to UI Transaction Quota rules.

2. If possible, reduce the size of the affected table.

Table changes done via UI, such as adding and removing fields, or extending fields length, are commonly done on a Development instance in order to be captured in Update Sets and promoted.
If the issue occurs, for example on Task table, it likely has a large number of records (over a million). Simply reducing the number of records or excluding them during a clone prevents the issue.

Update Set commits are not user actions and are not canceled by UI Transactions Quota Rule, so the issue does not occur when deploying such Update Sets. 


Adjust the Quota Rules to allow relevant system modules to wait longer for the database transaction to complete. Use these steps cautiously as they may affect instance performance.

  1. Navigate to System Definition > Quota Rules.
  2. Select the UI Transactions rule.
  3. Add these as AND conditions:
    • URL does not contain sys_dictionary
    • URL does not contain sys_db_object
    • URL does not contain
    • URL does not contain
    • URL does not contain

Related Problem: PRB597639

Seen In

Calgary Patch 1 Hot Fix 3
Calgary Patch 4
Dublin EA 9
Dublin Patch 1
Dublin Patch 5
Eureka Patch 1 Hot Fix 2
Eureka Patch 10
Eureka Patch 11
Eureka Patch 13
Eureka Patch 13 Hot Fix 5
Eureka Patch 2
Eureka Patch 4 Hot Fix 1
Eureka Patch 7
Eureka Patch 8
Eureka Patch 9
Eureka Patch 9 Hot Fix 4
Fuji Patch 5
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 - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - SIG Assessment Legacy - Madrid 2019 Q1
SR - IRM - SIG Questionnaire - New York 2019 Q3
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITBM - Agile 2.0 Dashboards v1.0
SR - ITBM - Scrum Dashboards Common v1.0
SR - ITOM - CMDB CI Class Models - 201909
SR - ITOM - Discovery and Service Mapping - 201908
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 UI Patch - London 2019 Q2 v.6.2.3
SR - SIR - Splunk Enterprise Event Ingestion - Madrid 2019 Q2 v5.0.2
SR - SIR - Splunk Sighting Search Integration - Madrid 2019 Q1
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 - VR - Qualys - New York 2019 Q3
SR - VR - Vulnerability Response - New York 2019 Q3
Eureka Patch 8

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-05-29 05:25:01