Hello,
While performing a minor upgrade to my wix setup, I want to reinstall my
database, all the existing content should be removed.
I try to do this with these commands:
<Component Id="SqlComponent" Guid="1234">
<Sql:SqlDatabase Id="SqlDatabase" Database="Foobar" User="SQLUser"
Server="[SQLSERVER],[SQLSERVERPORT]" CreateOnInstall="yes"
DropOnUninstall="yes" DropOnReinstall="yes" CreateOnReinstall="yes">
<Sql:SqlScript Id="CreateTable" BinaryKey="CreateTable"
ExecuteOnInstall="yes"/>
</Sql:SqlDatabase>
</Component>
But I get the following error:
Error 6 Cannot set column 'Attributes' with value 128 because it is
greater
than the maximum allowed value for this column, 127. candle.exe 0
1 WixSetup
Without the DropOnReinstall="yes" attribute everything works fine but the
msi log file looks like this and the database content is definitely not
removed:
MSI (s) (E0:E4) [15:20:47:052]: Doing action: UninstallSqlData
Action 15:20:47: UninstallSqlData. Configuring SQL Server
Action start 15:20:47: UninstallSqlData.
MSI (s) (E0:E4) [15:20:47:067]: Creating MSIHANDLE (1) of type 790542 for
thread 1764
MSI (s) (E0:F4) [15:20:47:067]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI1857.tmp, Entrypoint: UninstallSqlData
MSI (s) (E0:10) [15:20:47:067]: Generating random cookie.
MSI (s) (E0:10) [15:20:47:067]: Created Custom Action Server with PID 6132
(0x17F4).
MSI (s) (E0:98) [15:20:47:114]: Running as a service.
MSI (s) (E0:98) [15:20:47:114]: Hello, I'm your 32bit Impersonated custom
action server.
MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (2) of type 790541 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (3) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (3) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (4) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (4) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (5) of type 790540 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (6) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (6) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (5) of type 790540 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (7) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (7) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (8) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (8) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (9) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (9) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (10) of type 790540 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (11) of type 790540 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (12) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (12) of type 790531 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (10) of type 790540 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (11) of type 790540 for
thread 5452
MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (2) of type 790541 for
thread 5452
MSI (s) (E0:F4) [15:20:47:130]: Closing MSIHANDLE (1) of type 790542 for
thread 1764
Action ended 15:20:47: UninstallSqlData. Return value 1.
I'm using candle.exe version 3.0.4318.0
I would really appreciate if somebody can help me on this issue.
Thanks in advance!
Daniel
--
View this message in context:
http://n2.nabble.com/Problem-with-SqlDatabase-while-upgrading-tp719783p719783.html
Sent from the wix-users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
