>>Explain how else you could even get an ICE03 "String overflow (greater than length permitted in column)" error!
I couldn't, which was why I was speculating that recent MSI engines were stricter than others. However, I guess the fact that IDT tables are being used explains it. It's probably safer to violate ICE03 when compared to losing data by truncating fields in the resulting database. Phil Wilson -----Original Message----- From: Mike Dimmick [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 2:49 PM To: Wilson, Phil; wix-users@lists.sourceforge.net Subject: RE: [WiX-users] ICE03 error Explain how else you could even get an ICE03 "String overflow (greater than length permitted in column)" error! ICE validation occurs by merging darice.cub (really an MSM with a different extension) into the final MSI and running the _ICESequence sequence. If a string overflow is found, it's because the data in the table exceeds the size declared in the schema. Each ICEnn is a custom action which lives in the CUB's Binary table. Most of them are implemented as DLLs but a few (ICE08, ICE09, ICE32 and ICE61) are implemented as VBScript custom actions. If you wanted, you could create your own validators, and you can specify them on the light command line using the -cub switch. IIRC (looked at the code a while ago, haven't rechecked it) suppressing an ICE works by simply editing the _ICESequence. You'll notice from that information that validation requires a working mergemod.dll and a working VBScript engine to work properly. IIRC someone had a broken VBScript engine and therefore validation failed. It may be that if you're trying to insert data using SQL, it doesn't allow you to do it. Light generates text archive (.idt) files and imports them into a database using MsiDatabaseImport. Rob can probably explain why it does this rather than using SQL CREATE and INSERT statements. -- Mike Dimmick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Phil Sent: 09 May 2007 21:39 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] ICE03 error Are you sure about that "allows you to insert lengths longer than stated in the column definition"? Just the other day I had error 1627 when trying to insert a string of more than 72 characters into the Registry column of the Registry table. It's not clear to me whether a definition such as string [72] can really be circumvented, buit maybe some MSI versions are more strict than previously. Phil Wilson -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Dimmick Sent: Wednesday, May 09, 2007 1:24 PM To: 'Mike Dimmick'; 'jrcolons'; wix-users@lists.sourceforge.net Subject: Re: [WiX-users] ICE03 error Appears to be a limit imposed by the column definition format (see http://msdn2.microsoft.com/en-us/library/aa367870.aspx). Interestingly there is an s0 which should be unlimited but I'm not sure whether that would still work. Having said that, the SQL column of the SqlString table used by the <SqlString> element is length 0, so I think it should. Since the MSI database allows you to insert lengths longer than stated in the column definition I'm not entirely sure what the impact of 'overflowing' a column is. If you wanted to try hacking it yourself, edit the definition in tables.xml (in WiX 2.0, in src\wix\Data\tables.xml; in WiX 3.0, in src\ext\UtilExtension\wixext\Data\tables.xml) to set 'length="0"' rather than 255. I think. -- Mike Dimmick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Dimmick Sent: 09 May 2007 21:00 To: 'jrcolons'; wix-users@lists.sourceforge.net Subject: Re: [WiX-users] ICE03 error You say in the title it's an ICE03 error. What's the exact text of the error? ICE03 generates a number of different messages - it's basically the data structure integrity-checking ICE. Given how long that is I think that you're exceeding the length of the column. WiX permits up to 255 characters in the Value column of the XmlFile table (see src\ext\UtilExtension\wixext\Data\tables.xml), at least in 3.0.2813.0 - your data is 283 characters long. I don't know if there's any way you can build it up from shorter strings. The XmlConfig element has the same limit - 255 characters. I'm not sure what the limit is in Windows Installer itself. -- Mike Dimmick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jrcolons Sent: 09 May 2007 19:58 To: wix-users@lists.sourceforge.net Subject: [WiX-users] ICE03 error Hi! I'm trying to set a connection string in my web.config file for a third party application that's maybe too long for xmlfile to work... I am trying to figure out how i can work around that. can anyone enlighten me in that? that's the string I'm trying to setvalue on my web.config: <util:XmlFile Id="wc2" Action="setValue" File="[Intheco]\Web.config" ElementPath="//[EMAIL PROTECTED]'Intheco.Platform.Services.ProxyConnectionStr ing' [\]]/@value" Value="ProxyType=Remoting;WellKnownType=Infocorp.Platform.Services.Commo n.IB asePort,Infocorp.Platform.Services.Common,Version=1.0.0.0,Culture=neutra l,Pu blicKeyToken=718628017ffb966e;WellKnownUrl=tcp://[ApplicationServer]:898 9/In focorp.Platform.Services.Ports.RemotingPort.rem;DefaultTimeOut=90;"/> thanks in advance! jose -- View this message in context: http://www.nabble.com/ICE03-error-tf3717662.html#a10400611 Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------ - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------ - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------ - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------ - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
