{"id":1363,"date":"2007-09-01T13:19:28","date_gmt":"2007-09-01T13:19:28","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/heaths\/2007\/09\/01\/column-types-cannot-be-changed-in-a-patch-or-transform\/"},"modified":"2019-02-17T15:30:12","modified_gmt":"2019-02-17T22:30:12","slug":"column-types-cannot-be-changed-in-a-patch-or-transform","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/setup\/column-types-cannot-be-changed-in-a-patch-or-transform\/","title":{"rendered":"Column Types Cannot be Changed in a Patch or Transform"},"content":{"rendered":"

Transforms can change just about anything in an installation package – even the code page. Transforms can also add and drop both tables and columns<\/a> but they cannot, however, change the column type. This is true for patches as well, since a patch package contains transforms<\/a>.<\/p>\n

At their core, transforms store data aligned to the size of the data type. An i2 column – a SHORT, INT, or INTEGER in the column definition format<\/a> – stores 16 bits of data while an i4 column – a LONG – stores 32 bits of data. If a product, for example, defines the File<\/a> table’s Sequence column as i2 and a patch updates the Sequence column type to i4 then the data in the patch transform will be misaligned.<\/p>\n

When applying the transform or patch, the installation will fail. Windows Installer 4.0 and newer handle this failure gracefully by posting Windows Installer error message<\/a> 2247 and returning error<\/a> ERROR_PATCH_PACKAGE_INVALID (1636). Windows Installer 3.1 and older will throw an access violation exception.<\/p>\n

The best approach if you need to change the column type for a product that has already shipped is to ship a new small update<\/a> or minor upgrade<\/a> .msi<\/em> package and re-cache it when reinstalling<\/a>. This is a full product install but will still follow much of the same behavior as a patch when it comes to updating component resources. The key is that the REINSTALLMODE property<\/a> contains “v” in its value to copy the new, updated .msi<\/em> package to the cache. Future maintenance installations can then take advantage of the updated column types. You can also use a major upgrade<\/a> that removes the existing product. This is a new product install<\/a> – not a reinstall – and is cached automatically like any other new product install.<\/p>\n

If you plan on using the new msidbCustomActionTypePatchUninstall (0x8000) custom action attribute introduced in Windows Installer 4.5<\/a> you will need to update the CustomAction<\/a> table’s Type column to i4. Note that ICE validation will fail for ICE03<\/a> if you don’t update the _Validation<\/a> table, and for ICE45<\/a> with these new bits set when using older .cub<\/em> files. When new .cub<\/em> files are made available for Windows Installer 4.5 you should validate against them.<\/p>\n

There is some protection against this problem when generating patches.<\/p>\n

When the schemas of the target and upgrade databases differ, PatchWiz.dll<\/em> will return an error. PatchWiz.dll<\/em> 3.1 and older simply log that the authoring transform couldn’t be created. PatchWiz.dll<\/em> 4.0 and newer is more helpful, logging both the return code from MsiDatabaseGenerateTransform<\/a> as ERROR_INSTALL_TRANSFORM_FAILURE (1624) and the last error record, message 2248, which explicitly states that a specific column’s type differ between the target and upgrade databases. In both cases, UiCreatePatchPackage<\/a> and UiCreatePatchPackageEx<\/a> (available in PatchWiz.dll<\/em> 4.0 and newer) – assuming no errors occur during clean-up – return<\/a> ERROR_PCW_CANT_GENERATE_TRANSFORM (0xC00E5173, 3222163827).<\/p>\n

In WiX<\/a> 3.0.3210.0 support was added for generating a patch from two administrative installations. Currently, if the target or upgrade database schemas differ from the internal table definitions in WiX, a transform will be generated against the internal schema so that the transform builds successfully but will not apply, nor will a patch containing that transform apply, to the target product. It is recommended, therefore, to use the same version of WiX that was used to build the product or use the existing PatchCreation element in WiX to generate a .pcp<\/em> file that can be used with PatchWiz.dll<\/em> from the Windows Installer SDK. You can use msimsp.exe<\/em> also in the SDK as a wrapper around PatchWiz.dll<\/em>. The topic “Using Patch Creation Properties” in wix.chm<\/em> has more details and instructions.<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

Transforms can change just about anything in an installation package – even the code page. Transforms can also add and drop both tables and columns but they cannot, however, change the column type. This is true for patches as well, since a patch package contains transforms. At their core, transforms store data aligned to the […]<\/p>\n","protected":false},"author":389,"featured_media":3843,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[20,23,26,64],"class_list":["post-1363","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-installation","tag-logging","tag-msi4-5","tag-wix"],"acf":[],"blog_post_summary":"

Transforms can change just about anything in an installation package – even the code page. Transforms can also add and drop both tables and columns but they cannot, however, change the column type. This is true for patches as well, since a patch package contains transforms. At their core, transforms store data aligned to the […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/setup\/wp-json\/wp\/v2\/posts\/1363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/setup\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/setup\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/setup\/wp-json\/wp\/v2\/users\/389"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/setup\/wp-json\/wp\/v2\/comments?post=1363"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/setup\/wp-json\/wp\/v2\/posts\/1363\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/setup\/wp-json\/wp\/v2\/media\/3843"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/setup\/wp-json\/wp\/v2\/media?parent=1363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/setup\/wp-json\/wp\/v2\/categories?post=1363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/setup\/wp-json\/wp\/v2\/tags?post=1363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}