SQL Query failing with 1603 error

[PeterM]

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.

[Dan]

Hello,

I'm glad you got this working. Thank you for sharing this with us. Certainly this will help other users in the future.

Best regards,
Dan