Description:
After upgrading a model from a lower version of erwin Data Modeler to a later version (ie. 9.7 to 2019 R1), column default values are being left out when generating the schema, even when the Default Value option is selected in the option set.
Solution:
If a custom option set is being used, it's possible that the option set became corrupted during the model upgrade process. The reason option sets sometimes become corrupt during the upgrade process is because Option Sets are specific to a database and its versions. The Option Set has a selection of properties which may or may not be the same from one database to another and also from one version to another of the same database. In some very rare cases we have seen the Option Set being impacted without any change in the database and version. The easiest resolution is to recreate the Option Set. To recreate the option set, just make the selections in Forward Engineer (FE) Options. Once the selections are made, click on 'Save As' option to save it either with the model or as an XML (outside of the model). The second option (Save as XML) will also allow the same option to be used for other models as well where as the Save As option with the model will only be available for that model only. After using the new option set, the default values should now show up in the forward engineering script.
