I'm on AI 10.1 build 51253.
I created a SQL Query action to get some values from the database (SQL Server).
For almost all installs this works great, but for one or two installs, we've seen an error like this:
MSI (c) (F8:D4) [11:45:33:621]: Leaked MSIHANDLE (1536) of type 790540 for thread 4516
MSI (c) (F8:D4) [11:45:33:621]: Leaked MSIHANDLE (1526) of type 790541 for thread 4516
MSI (c) (F8:D4) [11:45:33:621]: Note: 1: 2769 2: SqlQueryAction_1 3: 2
Info 2769. Custom Action SqlQueryAction_1 did not close 2 MSIHANDLEs.
CustomAction SqlQueryAction_1 returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 11:45:33: SqlQueryAction_1. Return value 3.
MSI (c) (F8:D4) [11:45:33:623]: Doing action: FatalError
The query I'm running is pretty basic, so I was stumped until I took a wild guess based on this post: http://www.advancedinstaller.com/forums ... =2&t=26115
I was creating and returning some variables that were of type varchar, and I switched the type to nvarchar instead, assuming it was some odd collation issue.
That seemed to fix the issue for now.
I'm posting this in hopes to see if you guys have seen anything like this before.
And one other note; I saw a similar error in installs with the same SQL Query action and that time, I had to change the SQL from inline to a script, based on another forum post about problems if inline scripts got too long.