Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Why Does the Message "Looking for currency/price fields to change field length" Appear During an Update Set Commit? - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Why Does the Message "Looking for currency/price fields to change field length" Appear During an Update Set Commit?
KB0780992

Why Does the Message "Looking for currency/price fields to change field length" Appear During an Update Set Commit?


412 Views Last updated : Jan 3, 2025 public Copy Permalink
KB Summary by Now Assist

Summary

During the commit of an update set which modifies fields on a table, the message "Looking for currency/price fields to change field length" can be seen in the commit logs:

2019-10-01 21:23:30 (098) worker.7 worker.7 txid=6475f7ecdb54 Looking for currency/price fields to change field length.

If the table has currency or price fields which are decimal(15,2) fields, then modifications to widen these fields to decimal(20,4) will be added to the other changes being performed on the table:

2019-10-01 21:23:30 (129) worker.7 worker.7 txid=6475f7ecdb54 Adding field to batcher to change field length, table [x_acme_cust_purchase_order_line_item] field [list_price]
2019-10-01 21:23:30 (135) worker.7 worker.7 txid=6475f7ecdb54 BootstrapBatcher: Adding dictionary xml parse results for [x_acme_cust_purchase_order_line_item]:
    Changed fields: list_price(20)
2019-10-01 21:23:30 (144) worker.7 worker.7 txid=6475f7ecdb54 Adding field to batcher to change field length, table [x_acme_cust_bid] field [bid_amount]
2019-10-01 21:23:30 (144) worker.7 worker.7 txid=6475f7ecdb54 BootstrapBatcher: Adding dictionary xml parse results for [x_acme_cust_bid]:
    Changed fields: bid_amount(20)

The currency and price fields were increased from decimal(15,2) to decimal(20,4) in Istanbul, which is documented in the Istanbul Release Notes.   Other decimal fields types, such as decimal itself and percent_complete are not included in this widening and remain as decimal(15,2) fields.

For Istanbul or later, newly provisioned or zBooted instances the currency and price fields should be decimal(20,4) and would need no further modification.

For instances upgraded to Istanbul or later the fields are not widened as part of the upgrade, as that would lead to increasing the overall time an upgrade would take by hours, particularly on production instances.  Therefore these operations are deferred until an update set is committed which contains a sys_dictionary sys_update_xml record for any field on a table, regardless of whether that is a currency or price field.

The sys_dictionary update that triggers the the modification of the table, by the Update Set bootstrap batcher, does not need to modify the structure of the table and could be as simple as an update to the attributes on the table's collection record.

Once a table has had its existing currency or price fields successfully widened then the fields should not be modified when any subsequent update sets are committed for the same table.


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.