Hi
Mt target is host a wcf website. For that I am able to run set of sql scripts.
I am unable to run sql scripts I am getting rolled back.
I attached my log file please suggest any solution.
Suggested Articles
I am unable to run 2 or more sql scripts
- Attachments
-
- logs.log
- (339.01 KiB) Downloaded 446 times
Re: I am unable to run 2 or more sql scripts
Hello and welcome to Advanced Installer forums,
Thank you for your interest in Advanced Installer.
I'm not sure why you are encountering this behavior. Can you also please send us the .aip (project file) to support at advancedinstaller dot com so we can check you project settings? Also, please tell us if you can successfully run the related SQL scripts manually outside the installer?
All the best,
Daniel
Thank you for your interest in Advanced Installer.
I'm not sure why you are encountering this behavior. Can you also please send us the .aip (project file) to support at advancedinstaller dot com so we can check you project settings? Also, please tell us if you can successfully run the related SQL scripts manually outside the installer?
All the best,
Daniel
Re: I am unable to run 2 or more sql scripts
Hi,
How large are your scripts? We have found that when a script gets over a certain size, it will not work. I ask because, I see from your log that you have a table called "post code lookup" or something like that and, in the UK, if you are filling that up in your script, my guess is that your script may be pretty large.
Thanks,
Rob
How large are your scripts? We have found that when a script gets over a certain size, it will not work. I ask because, I see from your log that you have a table called "post code lookup" or something like that and, in the UK, if you are filling that up in your script, my guess is that your script may be pretty large.
Thanks,
Rob
Re: I am unable to run 2 or more sql scripts
Yes Rob I have four scripts to insert data into post code look up table each script contains 4200 rows
Size of the script is 1765 KB
Is it a problem?
Size of the script is 1765 KB
Is it a problem?
Re: I am unable to run 2 or more sql scripts
Hi,
We had the same problem. I found that when we changed the installer and made the scripts no larger than about 1MB each, they began to work. I don't think it is a problem with AE; it is more a problem with the MSI foundation it is built on.
Ours eventually got so large (we had a total of about 64MB of these scripts - so, more than 64 scripts), we ended up creating a separate web service (with an RSS feed) that delivers the "metadata content" (stuff like the postcodes, in your example) and an automatic update program that lives with the application that regularly checks the centralized web service.
In your example, your lookup table of UK postcodes (if that's where you are from) most likely gets updated more often that your application. We continually update the central repository that feeds the web service to keep it current and the applications are always kept current with the metadata.
Hope this helps,
Rob
We had the same problem. I found that when we changed the installer and made the scripts no larger than about 1MB each, they began to work. I don't think it is a problem with AE; it is more a problem with the MSI foundation it is built on.
Ours eventually got so large (we had a total of about 64MB of these scripts - so, more than 64 scripts), we ended up creating a separate web service (with an RSS feed) that delivers the "metadata content" (stuff like the postcodes, in your example) and an automatic update program that lives with the application that regularly checks the centralized web service.
In your example, your lookup table of UK postcodes (if that's where you are from) most likely gets updated more often that your application. We continually update the central repository that feeds the web service to keep it current and the applications are always kept current with the metadata.
Hope this helps,
Rob