X5 Studio crashes when loading large SQL scripts

Got a problem you cannot solve? Try here.
roddyvet
Posts: 3
Joined: Wed Aug 31, 2016 7:43 am

X5 Studio crashes when loading large SQL scripts

Postby roddyvet » Wed Aug 31, 2016 1:39 pm

I am running the latest version of X5 Studio and trying to create an MS SQL Script command to execute a script. The script I am trying to load is a little large at 9MB. I am able to use the Load Script file and see the content get pulled into the dialog. When I click Ok, X5 locks up and never responds. I have to kill the process. Smaller scripts load fine. I have the same problem in the Designer and in MSICode.

Is there another way I can call and execute the script?

bokkie
Posts: 767
Joined: Sun Feb 08, 2009 6:30 am

Re: X5 Studio crashes when loading large SQL scripts

Postby bokkie » Thu Sep 01, 2016 2:50 am

I experienced the same effect. I created a text file containing about 10MB-worth of nothing but SQL comments. It took a few seconds to load it in the dialog and clicking the OK button caused my IDE to freeze.

I then reduced the text file by about half its original size and it still froze the IDE. Like you, I eventually found it worked when I got my file down to roughly 1.3MB but at what threshold it eventually breaks I don't have the time to look at. At the other extreme, I tried loading a 150MB file and I got an out of memory exception which is perhaps to be expected.

If we're talking about SQL Server (I don't know the other database engines) I suppose it's possible to keep everything in the file and then use a DOS command to execute the osql command. That can accept an input file on the command line; that's how I remember it anyway but I'll let you investigate that. Then, in theory, you can let the SQL Server engine do the grunt work. It's not necessarily an elegant solution but it might work? :?:
Peter. Smartly dressed, he still resembles an unmade bed.
InstallAware MVP

FrancescoT
Site Admin
Posts: 5360
Joined: Sun Aug 22, 2010 4:28 am

Re: X5 Studio crashes when loading large SQL scripts

Postby FrancescoT » Thu Sep 01, 2016 4:43 am

Dear Roddyvet,

I suggest you to have a look at the following link.
http://www.installaware.com/forums/viewtopic.php?f=2&t=10060&hilit=SQLCMD

Regards
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE


Return to “Technical Support”

Who is online

Users browsing this forum: Majestic-12 [Bot] and 59 guests