Data conversion error during upgrade

Question

hi,We have added a data conversion for a new, mandatory column in a table. The default value is an expression, getting the value from another table “settings”.The problem is, that this table “settings” also has some changes in this update, and the tabel is also rebuild during the update. So at the time the value should be calculated, the table setting is renamed __setting__ and the new table is empty. So no value is found and the update fails.Is it possible to have some sort of sequence in rebuilding the tables? Or how can I solve this issue?

Mark Jongeling · Accepted Answer

Hi Tejo,You can safely base your default value expression on the "old” setting table, the one with the underscores. This contains all the values of the table before it gets upgraded.The Upgrade process of migrating data from the underscore-table to the new tablelooks to be Alphabetical and its order cannot be altered. All tables that need to be rebuild, either because they have been altered in a way or that have been manually checked to be Rebuild in the Data migration screen, will be renamed with underscores. Therefore any default value expression should then use the underscore-table for its value, unless said table will not be affected by the upgrade.Hope this helps!

Tejo van de Bor · Answer

Thanks Mark, I didn’t know the ‘underscore’ tables could be part of the model, thought they are more under the hood parts :-)
Can there be a validation that triggers this kind of faults in the model?

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded