[wix-users] Database creation issue

[Ven H]

I have an MSI which has lots of sql script files (around 1500) to create
around 8 databases and tables, stored procs, views, indexes, functions and
so on. These sql script files are executed in a sequence. Almost towards
the end, there is a very big file in the 8th DB (around 138 MB). This file
basically has insert statements with binary data.

When I install the MSI, I expect that it would create all the 8 DBs but
will fail only when it reaches this script. But it gets stuck for a very
long time, before it finally throws the error saying "Failed to allocate
memory to CustomActionData string.". But when I check the log, I can see
that it is logging all the sql statements from the previous scripts before
this file.

Although, there is a rollback script to drop everything in case of error, I
thought, when I refresh the SQL Management Studio, I would see the
databases during installation, but I don't. So, does it try to load
everything into memory first before starting to execute? If not, why does
it not create the databases during installation and then rollback after
error? Can anyone please provide any inputs?