Dear All,
I've playing with WiX for a week now and it's a great toolset, but I've
hit a wall with a particularly strange error.
I'm using WiX 3.0.2526 (last week's build). Here's a snippet from my
.wxs file:
<sql:SqlDatabase Id="MsSqlDatabase"
Database="anova"
Server="(local)\SQLEXPRESS"
CreateOnInstall="yes"
DropOnUninstall="yes"
ContinueOnError="no">
<sql:SqlString Id="Blah"
ExecuteOnInstall="yes"
SQL='CREATE TABLE "Pants" ( "Id" int not null )' />
</sql:SqlDatabase>
The above works great -- the database is created with a "Pants" table
sitting inside it. Unfortunately, I've got about a bajillion such
queries to run, so I thought I'd use SqlScript instead:
<sql:SqlDatabase Id="MsSqlDatabase"
Database="anova"
Server="(local)\SQLEXPRESS"
CreateOnInstall="yes"
DropOnUninstall="yes"
ContinueOnError="no">
<sql:SqlScript Id="MsSqlDdlInstall"
BinaryKey="CreateMsSqlDdlScript"
ExecuteOnInstall="yes" />
</sql:SqlDatabase>
For testing purposes, I've put the same exact "CREATE TABLE" line that I
used in SqlString in the file identified by the binary key in SqlScript.
But every time I run the installer, it exits prematurely:
MSI (s) (D8:78) [17:22:55:953]: Doing action: ConfigureSql
Action 17:22:55: ConfigureSql. Configuring SQL Server
Action start 17:22:55: ConfigureSql.
MSI (s) (D8:58) [17:22:55:968]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI14A7.tmp, Entrypoint: ConfigureSql
MSI (s) (D8:58) [17:22:55:984]: Leaked MSIHANDLE (14105) of type 790531
for thread 2028
MSI (s) (D8:58) [17:22:55:984]: Leaked MSIHANDLE (14104) of type 790531
for thread 2028
MSI (s) (D8:58) [17:22:55:984]: Leaked MSIHANDLE (14103) of type 790540
for thread 2028
MSI (s) (D8:58) [17:22:55:984]: Leaked MSIHANDLE (14102) of type 790540
for thread 2028
MSI (s) (D8:58) [17:22:55:984]: Leaked MSIHANDLE (14092) of type 790541
for thread 2028
MSI (s) (D8:58) [17:22:55:984]: Note: 1: 2769 2: ConfigureSql 3: 5
DEBUG: Error 2769: Custom Action ConfigureSql did not close 5 MSIHANDLEs.
The installer has encountered an unexpected error installing this
package. This may indicate a problem with this package. The error code
is 2769. The arguments are: ConfigureSql, 5,
Action ended 17:22:56: ConfigureSql. Return value 3.
I saw postings that referred to the encoding of this file; I've tried
ANSI, UTF-8, and UTF-16 (Big and Little Endian), but still no joy.
Any thoughts or ideas? I appreciate it!
V/R,
Nicholas Piasecki
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
