We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

deatiit86
Posts: 13
Joined: Sat Nov 10, 2012 3:13 am

Problem with SQL Query

Hi have a few sql queries in my advanced installer project. These work find on SQL 2008 R2. However on SQL 2012 I done get one of the return properties set.

The log when using SQL 2012 is as follows:

MSI (c) (FC:7C) [12:16:55:897]: Doing action: AI_DATA_SETTER_1
Action 12:16:55: AI_DATA_SETTER_1.
Action start 12:16:55: AI_DATA_SETTER_1.
MSI (c) (FC:7C) [12:16:55:897]: PROPERTY CHANGE: Adding CustomActionData property. Its value is 'CheckDBVersion'.
Action ended 12:16:55: AI_DATA_SETTER_1. Return value 1.
MSI (c) (FC:7C) [12:16:55:897]: Doing action: CheckDBVersion
Action 12:16:55: CheckDBVersion.
Action start 12:16:55: CheckDBVersion.
MSI (c) (FC:50) [12:16:55:898]: Invoking remote custom action. DLL: C:\Users\ADMINI~1\AppData\Local\Temp\2\MSIF86B.tmp, Entrypoint: OnSqlFetch
MSI (c) (FC!B0) [12:16:56:061]: PROPERTY CHANGE: Deleting DB_VERSION_NAME property. Its current value is 'SQL Server'.
MSI (c) (FC!B0) [12:16:56:061]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (FC!B0) [12:16:56:062]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (FC!B0) [12:16:56:062]: PROPERTY CHANGE: Deleting DB_VERSION_SUPPORTED property. Its current value is '0'.
MSI (c) (FC!B0) [12:16:56:062]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (FC!B0) [12:16:56:063]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (FC:50) [12:16:56:065]: Leaked MSIHANDLE (203) of type 790540 for thread 4016
MSI (c) (FC:50) [12:16:56:065]: Leaked MSIHANDLE (197) of type 790541 for thread 4016
Action ended 12:16:56: CheckDBVersion. Return value 1.
MSI (c) (FC:7C) [12:16:56:066]: Doing action: AI_DATA_SETTER_3
Action 12:16:56: AI_DATA_SETTER_3.
Action start 12:16:56: AI_DATA_SETTER_3.
MSI (c) (FC:7C) [12:16:56:066]: PROPERTY CHANGE: Modifying CustomActionData property. Its current value is 'CheckDBVersion'. Its new value: 'CheckDBSchema'.
Action ended 12:16:56: AI_DATA_SETTER_3. Return value 1.
MSI (c) (FC:7C) [12:16:56:066]: Doing action: CheckDBSchema

When using SQL 2008 R2 I get:

MSI (c) (C4:C4) [11:32:50:228]: Doing action: AI_DATA_SETTER_1
Action 11:32:50: AI_DATA_SETTER_1.
Action start 11:32:50: AI_DATA_SETTER_1.
MSI (c) (C4:C4) [11:32:50:228]: PROPERTY CHANGE: Adding CustomActionData property. Its value is 'CheckDBVersion'.
Action ended 11:32:50: AI_DATA_SETTER_1. Return value 1.
MSI (c) (C4:C4) [11:32:50:228]: Doing action: CheckDBVersion
Action 11:32:50: CheckDBVersion.
Action start 11:32:50: CheckDBVersion.
MSI (c) (C4:D0) [11:32:50:229]: Invoking remote custom action. DLL: C:\Users\ADMINI~1\AppData\Local\Temp\MSI424D.tmp, Entrypoint: OnSqlFetch
MSI (c) (C4!F4) [11:32:50:336]: PROPERTY CHANGE: Deleting DB_VERSION_NAME property. Its current value is 'SQL Server'.
MSI (c) (C4!F4) [11:32:50:337]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:337]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:338]: PROPERTY CHANGE: Deleting DB_VERSION_SUPPORTED property. Its current value is '0'.
MSI (c) (C4!F4) [11:32:50:338]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:338]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:387]: PROPERTY CHANGE: Adding DB_VERSION_NAME property. Its value is 'SQL Server 2008 R2 RTM Standard Edition (64-bit)'.
MSI (c) (C4!F4) [11:32:50:387]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:388]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:389]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:389]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (C4!F4) [11:32:50:390]: PROPERTY CHANGE: Adding DB_VERSION_SUPPORTED property. Its value is '1'.
MSI (c) (C4:D0) [11:32:50:417]: Leaked MSIHANDLE (203) of type 790540 for thread 3060
MSI (c) (C4:D0) [11:32:50:417]: Leaked MSIHANDLE (197) of type 790541 for thread 3060
Action ended 11:32:50: CheckDBVersion. Return value 1.
MSI (c) (C4:C4) [11:32:50:418]: Doing action: AI_DATA_SETTER_3
Action 11:32:50: AI_DATA_SETTER_3.
Action start 11:32:50: AI_DATA_SETTER_3.
MSI (c) (C4:C4) [11:32:50:418]: PROPERTY CHANGE: Modifying CustomActionData property. Its current value is 'CheckDBVersion'. Its new value: 'CheckDBSchema'.
Action ended 11:32:50: AI_DATA_SETTER_3. Return value 1.
MSI (c) (C4:C4) [11:32:50:418]: Doing action: CheckDBSchema

As you can see with 2008 I get the variable set. But not with 2012. Should I be doing something different with 2012?

Thanks.
-Arun
Dan
Posts: 4530
Joined: Wed Apr 24, 2013 3:51 pm

Re: Problem with SQL Query

Hello Arun,

I'm not sure why you encountered this behavior.

Can you please provide us a sample which reproduce this behavior (the .AIP project file with all the related resources) to support at advancedinstaller dot com
so we can build the project and investigate it?

Best regards,
Dan
Dan Ghiorghita - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
deatiit86
Posts: 13
Joined: Sat Nov 10, 2012 3:13 am

Re: Problem with SQL Query

Just sent the .aip and the .sql scripts. If there are any other files that you need, please let me know.
Thanks.
-Arun

Return to “Building Installers”