Hi,
I meet a problem when execute custom SQL query action to get a field from SQL Server database's column with the data type "[nvarchar] (MAX)"
CREATE TABLE [tbl_Config](
[Variable] [nvarchar](50) NOT NULL,
[Value] [nvarchar](MAX) NULL,
[Description] [nvarchar](150) NULL,
[Created] [smalldatetime] NULL DEFAULT (getdate()),
[SoftwareGroup] [varchar](50) NULL
) ON [PRIMARY]
The following sql is OK: SELECT [Description] FROM [tbl_Config] WHERE [Description] = '\\IP_ADRESS\'
But executing this sql is failed: SELECT [tbl_Config].[Value] FROM [tbl_Config] WHERE [tbl_Config].[Variable] = 'Val1'
The errors in log:
OnSqlFetch: bad allocation
OnSqlFetch: SQL script: [SqlQueryDatabaseSize] FAILED !
OnSqlFetch: Aborting install...
.
.
.
CustomAction SqlQueryActionDatabaseSize returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 18:51:22: SqlQueryActionDatabaseSize. Return value 3.
Please help me with the above error.
Attached is the Advanced installer project and log file.
I am using Advanced installer version 14.4.2
With best regards,
Vinh Nguyen