Error Packaging a script from the command line.

Forum for users of SQL Packager database archive utility

Error Packaging a script from the command line.

Postby christiang » Fri May 02, 2014 6:15 pm

We are packaging a sql script as part of our build process. I'm using the following command:

H:\\myproject>"C:\\Program Files (x86)\\Red Gate\\SQL Packager 7\\SQLPackager.exe" /f /project MySQLPackage.sqlpkg
SQL Packager: activated, edition: professional, serial number: xxx-xxx-xxxxxx-xxxx
SQL Packager Command Line V7.0.0.1484
==================================================================================================
Copyright c Red Gate Software Ltd 1999-2013

Creating package...
Unexpected error: Value cannot be null. Parameter name: collection
Value cannot be null.
Parameter name: collection
System.ArgumentNullException
at System.Collections.Generic.HashSet`1..ctor(IEnumerable`1 collection, IEqualityComparer`1 compa
rer)
at System.Collections.Generic.HashSet`1..ctor(IEnumerable`1 collection)
at RedGate.SQLCompare.Engine.Options.ToString()
at #4rpb.#XWA.#wVD()
at #4rpb.#XWA.#OUb()
at #4rpb.#OsPb.#6sc(String[] #ead)



Here is the sqlpackager 6 output:

H:\\myproject>"C:\\Program Files (x86)\\Red Gate\\SQL Packager 6\\SQLPackager.exe" /f /project MySQLPackage.sqlpkg
SQL Packager Command Line V6.4.0.8
==================================================================================================
Copyright c Red Gate Software Ltd 1999-2008

Serial Number:xxx-xxx-xxxxxx-xxxx

Creating package...
OK



The project file was created in sql packager 6 initially, then when I got the error I created a new project file from sql packager 7. It seems to build fine from the UI.
christiang
 
Posts: 5
Joined: Tue Feb 03, 2009 7:42 pm

Postby eddie davis » Mon May 05, 2014 3:35 pm

Thank you for your forum post and sorry that you have encountered a problem.

It looks a bug to me. Therefore I have added the details of your post to Bug Report SPA-639.

I will request that the SQL Packager Product Manager review this bug report.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 996
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Re: Error Packaging a script from the command line.

Postby thinkingsoftware » Tue Nov 04, 2014 6:37 pm

We are seeing the same behaviour, just upgraded to SQLPackager 7 from 6 and a previous command line function now failing (others all fine, just one):

"C:\Program Files\Red Gate\SQL Packager 7\SQLPackager.exe" /scriptsource:"C:\Installation\SQL Scripts & Snapshots\horizon_data.sql" /force /makeexe /name:horizon_data /location:"C:\Installation\SQL Scripts & Snapshots"

Output is the same:

Creating package...
Unexpected error: Value cannot be null. PArameter name: collection
...
System.ArgumentNullException at System.Collections.Generic.HashSet'1..ctor(IEnumerable'1 collection, IEqualityComparer'1 compare)
at System.Collections.Generic.HashSet'1..ctor(IEnumerable'1 collection)
at RedGate.SQLCompare.Engine.Options.ToString
at #4rpb.#XWA.#wVD()
at #4rpb.#XWA.#OUb()
at #4rpb.#OsPb.#6sc(String[] #ead)


This query was originally posted in May, surely there is a resolution available for this by now?
Last edited by thinkingsoftware on Wed Nov 05, 2014 9:51 am, edited 1 time in total.
thinkingsoftware
 
Posts: 1
Joined: Tue Nov 04, 2014 6:31 pm


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests