SQL 2012 - Compatible??

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 2012 - Compatible??

Postby smcleod » Tue Aug 21, 2012 2:40 pm

I am trying to package a database running in SQL Server 2012, and I get the error "ExecuteReader: CommandText property has not been initialized"... what could the problem be, or is SQL Packager not compatible with SQL Server 2012?? Thanks in advance!
smcleod
 
Posts: 3
Joined: Tue Nov 24, 2009 4:39 pm

Postby colinbo » Fri Aug 24, 2012 9:22 pm

I hit the same issue packaging any database residing on a SQL 2012 instance. I turned on verbose logging but it doesn't give much in the way of hints:

Code: Select all
16:20:19.495|Info   |Logging             |1  |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error
16:20:28.292|Info   |SQL Compare Engine  |6  |Register live database start: FOO
16:20:28.292|Info   |SQL Compare Engine  |6  |Populate Live Start, popoptions: #rJg, #wJg
16:20:28.292|Info   |SQL Compare Engine  |6  |Populate Live Start, options: DoNotOutputCommentHeader, IgnoreUsers, Default
16:20:28.308|Info   |SQL Compare Engine  |6  |Populate major version: SqlServer2008
16:20:28.308|Info   |SQL Compare Engine  |6  |Populate got casing: False
16:20:28.308|Info   |SQL Compare Engine  |6  |Populate Case Sensitive: False
16:20:28.323|Info   |SQL Compare Engine  |6  |Populate FulltextCatalogs start.
16:20:28.323|Info   |SQL Compare Engine  |6  |Populate Fulltext Stoplists start.
16:20:28.323|Info   |SQL Compare Engine  |6  |Populate Fulltext Stopwords start.
16:20:28.323|Info   |SQL Compare Engine  |6  |Populate ObjectNames start.
colinbo
 
Posts: 11
Joined: Wed Feb 15, 2006 8:47 pm

Same issue... can't package because of the ExecuteReader

Postby carltierney » Thu Sep 20, 2012 4:23 am

http://imgur.com/UzECV

Here is what I see from trying to use the packager with 2012.
carltierney
 
Posts: 2
Joined: Mon Sep 17, 2012 2:44 pm
Location: Dallas TX

Postby Brian Donahue » Thu Sep 20, 2012 3:21 pm

Can you please try this patch to SQL Packager? This gets it working in SQL 2012 for me. Thanks!

ftp://support.red-gate.com/patches/sql_ ... .0.347.zip
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Re:

Postby colbybhearn » Thu Oct 11, 2012 4:48 pm

Brian Donahue wrote:Can you please try this patch to SQL Packager? This gets it working in SQL 2012 for me. Thanks!

ftp://support.red-gate.com/patches/sql_ ... .0.347.zip


I just upgraded to SQL 2012 and was getting the same message. "ExecuteReader: CommandText property has not been initialized"
Thanks Brian, that small patch immediately fixed it.
-Colby
colbybhearn
 
Posts: 5
Joined: Thu Sep 27, 2012 4:26 pm

Re:

Postby rbelbin » Fri Oct 12, 2012 5:53 pm

Brian Donahue wrote:Can you please try this patch to SQL Packager? This gets it working in SQL 2012 for me. Thanks!

ftp://support.red-gate.com/patches/sql_ ... .0.347.zip


I tried this package, and after it installed it basically removed the trial period from all of the SQL developer Toolbelt products. Any work around to that?
rbelbin
 
Posts: 1
Joined: Fri Oct 12, 2012 5:51 pm

Command Line Functionality

Postby colbybhearn » Fri Oct 12, 2012 11:11 pm

I hate to pile on another issue, but I think that patch (6.6.0.347) which fixed packaging through the GUI may have broken something else - Packager's command line interface (CLI) functionality seems to have changed. To make sure it was the patch, I re-installed Packager 6.4 and ran my CLI automation to verify it worked again. I then re-patched to 6.6 and changed nothing about the CLI or automation. I ran the CLI automation again and verified it no longer worked.

I have not yet compared product documentation to see if there is some switch that changed or got deprecated.

Here is the command line input/output: (carefully redacted)
Code: Select all
C:\\Users\\MyUsername>\"C:\\Program Files (x86)\\Red Gate\\SQL Packager 6\\sqlpackager.exe\" /verbose /server1:BuildServer /database1:\"Ref_Database\" /includedata:Table /rundatabase:\"Db_Install_Name\" /exe /name:\"Db_Installer_Filename\" /location:\"C:\\Program Files (x86)\\RedGateOutpus\\Installers\" > C:\\Users\\MyUsername\\Desktop\\sql5.txt
Error: Object reference not set to an instance of an object.


Here is the content of the sql5.txt file:
Code: Select all
SQL Packager Command Line V6.6.0.347
==============================================================================
Copyright c Red Gate Software Ltd 1999-2008

SQL Compare running with option: IgnoreFillFactor (OK).
SQL Compare running with option: IgnoreWhiteSpace (OK).
SQL Compare running with option: IncludeDependencies (OK).
SQL Compare running with option: IgnoreFileGroups (OK).
SQL Compare running with option: IgnoreUserProperties (OK).
SQL Compare running with option: IgnoreWithElementOrder (OK).
SQL Compare running with option: DecryptPost2kEncryptedObjects (OK).
Comparing database BuildServer.Ref_Database with database ....
Registering data sources
Creating mappings
Comparing
Applying Command Line Items
Retrieving migration scripts
Creating SQL

Summary Information
===============================================================================
DB1 = BuildServer.Ref_Database
DB2 =

Object type             Name                                           DB1 DB2
-------------------------------------------------------------------------------
            ...Proper Object Enumeration Here...   
-------------------------------------------------------------------------------

Details - comparing BuildServer.Ref_Database with
===============================================================================
            ...Proper Object Content Here...
-------------------------------------------------------------------------------

Used mapping option 'IgnoreSpaces'
Used mapping option 'IncludeTimestamps'
Used mapping option 'IncludeIdentities'
Used Sql Option 'DisableKeys'
Used Sql Option 'DontOutputComments'
SQL Data Compare running with Mapping Option: IgnoreSpaces (OK).
SQL Data Compare running with Mapping Option: IncludeTimestamps (OK).
SQL Data Compare running with Mapping Option: IncludeIdentities (OK).
SQL Data Compare running with SQL Option: DisableKeys (OK).
SQL Data Compare running with SQL Option: DontOutputComments (OK).
SQL Data Compare running with Mapping Option: MissingFrom2AsInclude (OK).
Comparing database BuildServer.Ref_Database with database ....
Registering databases
Mapping


For clarity, the \"BuildServer\" is SQL Server 2008.
I can't find anything in the event log from Packager.
Is there anything that the patch changed about the CLI?
Is there anything I can do to find out more about what might be going wrong?
I'd greatly appreciate some help.
-Colby
colbybhearn
 
Posts: 5
Joined: Thu Sep 27, 2012 4:26 pm

Postby Brian Donahue » Mon Oct 15, 2012 9:32 am

Hi,

The patch was designed specifically to solve the problem at the top of this thread. Given all of these problems, I would uninstall the patch. I have notified the product manager that there is this problem and that some effort needs to be put into proper support for SQL Server 2012.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

SQL 2012 Compatibility

Postby colbybhearn » Mon Oct 15, 2012 2:43 pm

Hey Brian,
I totally understand. Thanks for relaying the concerns.
-Colby
colbybhearn
 
Posts: 5
Joined: Thu Sep 27, 2012 4:26 pm

Postby Calvin » Mon Jan 14, 2013 2:10 pm

Any news on this being completed? I use Packager quite a bit and am getting close to my license renewal.
Calvin
 
Posts: 1
Joined: Mon Jan 14, 2013 2:09 pm

Postby dw5304 » Tue Apr 02, 2013 8:54 pm

having same issue as listed above with patch 6.6.0.347 any eta on fix?
dw5304
 
Posts: 3
Joined: Tue Apr 02, 2013 8:53 pm

Postby GGinBerkeley » Sat Jun 15, 2013 3:05 pm

I am having the same issue as reported above. I can start SQL Packager (latest version). It can see my server, and the list of databases shows OK. After selecting a database to package, it goes to the next step, but that errors out.

It aborts when in the Register Database step, Reading Assemblies.

It says "ExecuteReader: CommandText property has not been initialized."

And it refuses to do anything else.

Note: I seem to be having similar issues when using SQL Compare too.

I have purchased licenses for both of these for myself, but they seem to be having problems running with SQL Server 2012.

I will try the patch, but it should be noted that your latest and greatest software products seem to be having some "issues" working properly with up-to-date versions of SQL Server.
GGinBerkeley
 
Posts: 3
Joined: Fri Apr 12, 2013 12:29 am

Postby GGinBerkeley » Sat Jun 15, 2013 3:17 pm

OK...that patch fixed my problem.

But...

1) I had to spend time searching for this fix, after your software refused to work in an up-to-date environment.

2) The readme file for that patch is very explicit. It says, "This patch is for the error "must declare scalar variable @pv" when running a package.
DO NOT install this patch unless you have the problem described."

But this was NOT the error I saw, so just installing the patch was an exercise in faith and ignoring your explicit warning.

Again...this was a waste of my time, that should NOT have been necessary.

I'm glad there is a patch, but why hasn't this been incorporated into the main branch? It's been over a year that you have been aware of the problem.

For the record, I really like your products, and use them on a near-daily basis (and I promote your products to my professional colleagues).
GGinBerkeley
 
Posts: 3
Joined: Fri Apr 12, 2013 12:29 am


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests