| Author |
Message |
Davy Mitchell
Joined: 15 Oct 2008
Posts: 14
Location: Scotland
|
 Posted: Thu May 21, 2009 11:29 am Post subject: SQL Packager Failing to Install an Assembly |
 |
|
I have a SQL script which updates that database. This is verified as working via SSMS.
If I package with SQL Packager and run I get the error
Upgrading Database: OPTAC_MyCompany
SQL Error: ALTER ASSEMBLY for assembly 'procInfringements' failed because assembly 'procInfringements' is malformed or not a pure .NET assembly.
Unverifiable PE Header/native stub.
Thanks,
Davy Mitchell |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software
|
| Posted: Mon May 25, 2009 10:53 am Post subject: |
|
|
Hi Davy,
I can't say for sure, but I think you've run into a bug in Packager that causes it to split scripts up in the middle of a query when you package scripts that are very large. We will be releasing an update to SQL Packager soon that will fix this problem.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
Davy Mitchell
Joined: 15 Oct 2008
Posts: 14
Location: Scotland
|
| Posted: Mon May 25, 2009 11:03 am Post subject: |
|
|
Thanks for your help - sounds very likely. The script is currently 1406kb in size.
This is impacting our current development. Can you be any more accurate than 'soon'? Sorry - I know it is difficult. 
Regards,
Davy Mitchell |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software
|
| Posted: Tue May 26, 2009 10:34 am Post subject: |
|
|
Hi Davy,
At this point, we are still trying to figure out the best way to fix it, so I don't have a date. I have found out that the magic number is around 250 -- batches that are 250 lines or less do not get broken up.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
Davy Mitchell
Joined: 15 Oct 2008
Posts: 14
Location: Scotland
|
| Posted: Tue May 26, 2009 3:40 pm Post subject: |
|
|
| Ok - understand that. Thanks Brian. |
|
| Back to top |
|
|
alice.easey
Joined: 27 Feb 2008
Posts: 93
Location: Red Gate
|
| Posted: Wed May 27, 2009 9:36 am Post subject: |
|
|
Hi Davy,
Our developers are planning to have a look at this issue in the next couple of weeks - hopefully we'll be able to get a fix out to you then.
Alice Easey
Project Manager
Red Gate Software |
|
| Back to top |
|
|
Davy Mitchell
Joined: 15 Oct 2008
Posts: 14
Location: Scotland
|
| Posted: Thu May 28, 2009 7:06 am Post subject: |
|
|
| Thanks for the update Alice! |
|
| Back to top |
|
|
Davy Mitchell
Joined: 15 Oct 2008
Posts: 14
Location: Scotland
|
| Posted: Thu Jun 11, 2009 3:01 pm Post subject: |
|
|
Hi just wondering if there is any news on this?  |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software
|
| Posted: Thu Jun 11, 2009 3:06 pm Post subject: |
|
|
Hi Davy,
I think this may be fixed as part of Packager's enhancements to support large scripts -- I'll send you a link by Private Message.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
Davy Mitchell
Joined: 15 Oct 2008
Posts: 14
Location: Scotland
|
| Posted: Thu Jun 11, 2009 3:10 pm Post subject: |
|
|
That's great Brian - I will check it out and report back to you.
Take care,
Davy |
|
| Back to top |
|
|
Davy Mitchell
Joined: 15 Oct 2008
Posts: 14
Location: Scotland
|
| Posted: Tue Jun 23, 2009 1:45 pm Post subject: |
|
|
Thought I would feedback on this.
The large script fix appears to have solved the install issue (not tested the application much yet!).
Thanks for the help Is there a date set for the official final release?
Davy |
|
| Back to top |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1079
|
| Posted: Thu Jun 25, 2009 10:39 am Post subject: |
|
|
Sorry, we don't have a date on an official release. We generally wait until either a major product release or a sufficient number of smaller fixes that will justify a public point release.
There are no known issues that should prevent you using the private patch. The only disclaimer is that it hasn't undergone the full set of regression tests that our public releases undergo, so we would urge you to satisfy yourself that it works in your environment before using it in anger.
Kind regards,
David Atkinson
Red Gate Software |
|
| Back to top |
|
|
|
