If you try to commit an update set containing an insert of a new table that has a function field, the update set fails to properly commit the new table. The function field is a field type first included Kingston release.
For more information, see the product documentation topic Create a function field to perform database functions.
Steps to Reproduce
Create a new update set.
Create a new table with the fields, for example:
- Type: String, length: 200
- Description, Type HTML (default length is 8000)
After creating the table, create a new function field of Type String, with Function.
Set the update set to Complete.
Load the update set to another instance
The update set log contains the following errors:
1 - Version loading was stopped by DictionaryUpdateLoader for sys_dictionary_<table_name>_null
2 - Changes for table <table> failed to commit
Do not include the dictionary field with the function field during the creation of a new table in an update set. Apply the update set that will create the new table first, then create a new update set that will contain the dictionary field with the function field checked.
Related Problem: PRB1284788