[wix-users] MSI database update at install time

[Stephen Woolhead]

Hi, I writing a WiX extension and one of the steps I need my custom actions to do is update existing records in the MSI database at install time.


After a bit of research it appears that I can't use SQL UPDATE on permanent tables at install time. Blog posts I've seen [1] say that I need to delete and insert a new row, but when I try this I get the following errors:


Ready to execute delete query: DELETE FROM `IIsAppPool` WHERE `IIsAppPool`.`AppPool`='web_general_apppool'
Delete Query Executed Successfully
Ready to execute insert query: INSERT INTO `IIsAppPool` (`AppPool`, `Name`, `Component_`, `Attributes`, `User_`, `RecycleMinutes`, `RecycleRequests`, `RecycleTimes`, `IdleTimeout`, `QueueLimit`, `CPUMon`, `MaxProc`, `VirtualMemory`, `PrivateMemory`, `ManagedRuntimeVersion`, `ManagedPipelineMode`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) TEMPORARY
Executing insert query...
MSI (s) (B8!D0) [22:33:20:906]: Database string pool is corrupted.
MSI (s) (B8!D0) [22:33:20:906]: Note: 1: 2259 2:  3:  4:
Exception Type: Microsoft.Deployment.WindowsInstaller.InstallerException


Is this possible or am I heading down a blind end?


Cheer,


Stephen.




[1]  http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Updating-msi-database-install-time-tp7587512p7587523.html