Looks like you have an XmlFile element somewhere that points to a property that isn't resolving to a file.
That error has nothing to do with SQL. <smile/> On Wed, Jun 12, 2013 at 8:57 AM, Chase Woofer <chasewoofe...@gmail.com>wrote: > Guys - > > I need some help here, I have an installation package that installs a bunch > of files and then creates an MS SQL Database. The installer fails with the > message "Error 25531. Failed to open XML file , system error: -2147024786" > > I can't figure out what I am doing wrong: > > code from SetupDatabase.wxs > <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"; > xmlns:sql="http://schemas.microsoft.com/wix/SqlExtension";> > <?include $(sys.CURRENTDIR)\Includes\SetupVariables.wxi?> > > <!-- Create Database --> > <Fragment> > <Property Id="DBFOLDERDATA" Value="$(var.dbDataFolder)" Hidden="no" > Secure="yes" /> > <Property Id="DBFOLDERLOGS" Value="$(var.dbLogsFolder)" Hidden="no" > Secure="yes" /> > > <Property Id="DBNAME" Value="$(var.dbName)" Hidden="yes" Secure="yes"/> > > <DirectoryRef Id="TARGETDIR"> > <Component Id="cmdDBCreate" > Guid="{108CAE8F-8DFA-4510-999B-95B87451FA51}" KeyPath="yes"> > <sql:SqlDatabase Id="sqlDatabase" Server="[SERVER_INSTANCE]" > Database="[DBNAME]" CreateOnInstall="yes" DropOnUninstall="yes" > ContinueOnError="no"> > <sql:SqlFileSpec Id="sqlDataFile" Name="[DBNAME]_DATA" > Filename="[DBFOLDERDATA]\[DBNAME].mdf" GrowthSize="1024KB" Size="20480KB"/> > <sql:SqlLogFileSpec Id="sqlLogFile" Name="[DBNAME]_LOGS" > Filename="[DBFOLDERLOGS]\[DBNAME]_log.ldf" GrowthSize="10%" Size="1024KB"/> > </sql:SqlDatabase> > </Component> > </DirectoryRef> > </Fragment> > > <!-- Setup ODBC --> > <Fragment> > <DirectoryRef Id="TARGETDIR"> > <Component Id="cmpCreateODBC" > Guid="{3690D626-2841-47C1-AAB4-A30675485E16}" KeyPath="yes"> > <ODBCDataSource Id="odbcTSLS" Name="$(var.dbODBC.Name)" > Registration="machine" DriverName="SQL Server"> > <Property Id="Server" Value="[SERVER_INSTANCE]" /> > <Property Id="Database" Value="[DBNAME]" /> > <Property Id="Description" Value="DataSource for > $(var.ProductName)" /> > <Property Id="Trusted_Connection" Value="yes" /> > </ODBCDataSource> > </Component> > </DirectoryRef> > </Fragment> > > <Fragment> > <ComponentGroup Id="SetupDatabase"> > <ComponentRef Id="cmdDBCreate"/> > <ComponentRef Id="cmpCreateODBC"/> > </ComponentGroup> > </Fragment> > > Error From Log File : > > (Action=RollbackCreateDatabase,ActionType=25857,Source=BinaryData,Target=**********,CustomActionData=**********) > MSI (s) (38:14) [11:22:44:348]: Executing op: > ActionStart(Name=CreateDatabase,Description=Creating Databases,) > MSI (s) (38:14) [11:22:44:348]: Executing op: > > CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********) > MSI (s) (38:48) [11:22:44:348]: Invoking remote custom action. DLL: > C:\WINNT\Installer\MSI513.tmp, Entrypoint: CreateDatabase > MSI (s) (38:14) [11:22:44:707]: Executing op: > ActionStart(Name=ExecXmlFile,,) > MSI (s) (38:14) [11:22:44:707]: Executing op: > > CustomActionSchedule(Action=ExecXmlFile,ActionType=3073,Source=BinaryData,Target=ExecXmlFile,CustomActionData=1 > 0 3 0 //configuration/appSettings/add[@key=’DIR.EXES’]/@value C:\Program > Files\BearSolutions\EXES\ 3 0 > //configuration/appSettings/add[@key=’DIR.DEST.INCOMMING’]/@value > G:\INBOUND_DATA\BearSolutions 3 0 > //configuration/appSettings/add[@key=’DIR.DEST.OUTGOING’]/@value > G:\OUTBOUND_DATA\BearSolutions 3 0 > //configuration/appSettings/add[@key=’DIR.DEST.INVENTORY’]/@value > E:\IInetPUB\wwwroot\BearSolutions\MOCFTP\INVENTORY\ 3 0 > //configuration/appSettings/add[@key=’DIR.DEST.REPORTS’]/@value > E:\IInetPUB\wwwroot\BearSolutions\MOCFTP\TREPORTS\ 1 0 3 0 > //configuration/appSettings/add[@key=’DIR.TEMP’]/@value C:\Program > Files\BearSolutions\TMPS\) > MSI (s) (38:C0) [11:22:44:707]: Invoking remote custom action. DLL: > C:\WINNT\Installer\MSI514.tmp, Entrypoint: ExecXmlFile > ExecXmlFile: Error 0x8007006e: failed to load XML file: > MSI (c) (50:10) [11:22:44:754]: Font created. Charset: Req=0, Ret=0, Font: > Req=MS Shell Dlg, Ret=MS Shell Dlg > Error 25531. Failed to open XML file , system error: -2147024786 > MSI (s) (38!B0) [11:25:57:304]: Product: BearSolutions Shipboard Library > System (TSLS) -- Error 25531. Failed to open XML file , system error: > -2147024786 > > > I am realy stuck and can't figure this out. > > Thanks, > Chase > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Windows: > > Build for Windows Store. > > http://p.sf.net/sfu/windows-dev2dev > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > ------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
