SQL Packager Failing to Install an Assembly

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

SQL Packager Failing to Install an Assembly

Postby Davy Mitchell » Thu May 21, 2009 11:29 am

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:

Thanks,
Davy Mitchell
Davy Mitchell
 
Posts: 14
Joined: Wed Oct 15, 2008 2:41 pm
Location: Scotland

Postby Brian Donahue » Mon May 25, 2009 10:53 am

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby Davy Mitchell » Mon May 25, 2009 11:03 am

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. :D

Regards,
Davy Mitchell
Davy Mitchell
 
Posts: 14
Joined: Wed Oct 15, 2008 2:41 pm
Location: Scotland

Postby Brian Donahue » Tue May 26, 2009 10:34 am

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby Davy Mitchell » Tue May 26, 2009 3:40 pm

Ok - understand that. Thanks Brian. :D
Davy Mitchell
 
Posts: 14
Joined: Wed Oct 15, 2008 2:41 pm
Location: Scotland

Postby alice.easey » Wed May 27, 2009 9:36 am

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
alice.easey
 
Posts: 93
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Postby Davy Mitchell » Thu May 28, 2009 7:06 am

Thanks for the update Alice! :D
Davy Mitchell
 
Posts: 14
Joined: Wed Oct 15, 2008 2:41 pm
Location: Scotland

Postby Davy Mitchell » Thu Jun 11, 2009 3:01 pm

Hi just wondering if there is any news on this? :)
Davy Mitchell
 
Posts: 14
Joined: Wed Oct 15, 2008 2:41 pm
Location: Scotland

Postby Brian Donahue » Thu Jun 11, 2009 3:06 pm

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby Davy Mitchell » Thu Jun 11, 2009 3:10 pm

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

Take care,
Davy
Davy Mitchell
 
Posts: 14
Joined: Wed Oct 15, 2008 2:41 pm
Location: Scotland

Postby Davy Mitchell » Tue Jun 23, 2009 1:45 pm

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

Davy
Davy Mitchell
 
Posts: 14
Joined: Wed Oct 15, 2008 2:41 pm
Location: Scotland

Postby David Atkinson » Thu Jun 25, 2009 10:39 am

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests