Red Gate forums :: View topic - SQL Packager Failing to Install an Assembly
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

SQL Packager Failing to Install an Assembly

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Davy Mitchell



Joined: 15 Oct 2008
Posts: 14
Location: Scotland

PostPosted: Thu May 21, 2009 11:29 am    Post subject: SQL Packager Failing to Install an Assembly Reply with quote

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.

Evil or Very Mad

Thanks,
Davy Mitchell
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Mon May 25, 2009 10:53 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Davy Mitchell



Joined: 15 Oct 2008
Posts: 14
Location: Scotland

PostPosted: Mon May 25, 2009 11:03 am    Post subject: Reply with quote

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. Very Happy

Regards,
Davy Mitchell
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Tue May 26, 2009 10:34 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Davy Mitchell



Joined: 15 Oct 2008
Posts: 14
Location: Scotland

PostPosted: Tue May 26, 2009 3:40 pm    Post subject: Reply with quote

Ok - understand that. Thanks Brian. Very Happy
Back to top
View user's profile Send private message
alice.easey



Joined: 27 Feb 2008
Posts: 93
Location: Red Gate

PostPosted: Wed May 27, 2009 9:36 am    Post subject: Reply with quote

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
View user's profile Send private message
Davy Mitchell



Joined: 15 Oct 2008
Posts: 14
Location: Scotland

PostPosted: Thu May 28, 2009 7:06 am    Post subject: Reply with quote

Thanks for the update Alice! Very Happy
Back to top
View user's profile Send private message
Davy Mitchell



Joined: 15 Oct 2008
Posts: 14
Location: Scotland

PostPosted: Thu Jun 11, 2009 3:01 pm    Post subject: Reply with quote

Hi just wondering if there is any news on this? Smile
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Thu Jun 11, 2009 3:06 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Davy Mitchell



Joined: 15 Oct 2008
Posts: 14
Location: Scotland

PostPosted: Thu Jun 11, 2009 3:10 pm    Post subject: Reply with quote

That's great Brian - I will check it out and report back to you. Very Happy

Take care,
Davy
Back to top
View user's profile Send private message
Davy Mitchell



Joined: 15 Oct 2008
Posts: 14
Location: Scotland

PostPosted: Tue Jun 23, 2009 1:45 pm    Post subject: Reply with quote

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 Very Happy Is there a date set for the official final release?

Davy
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Thu Jun 25, 2009 10:39 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group