Red Gate forums :: View topic - Bug: Must declare the scalar variable "@pv"Possible Solution
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

Bug: Must declare the scalar variable "@pv"Possible Solution

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



Joined: 30 Mar 2012
Posts: 6

PostPosted: Fri Mar 30, 2012 2:53 pm    Post subject: Bug: Must declare the scalar variable "@pv"Possible Solution Reply with quote

This was not fixed despite being said so in the maintenance release. Now in fact it is the oposite. Varialbe NOT declared!!!!

The problem seems to be associated with the declaration that is missing from the batch scope.



I am 99% sure that this "Batch13" is executed out of scope.

This happens a lot in our scripts since they contain large number of binary data updates.

You should insert the declaration dynamicaly when the exes are running the scripts, right after the first batch.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Mon Apr 02, 2012 3:56 pm    Post subject: Reply with quote

I believe you may have come across a message in a different forum. The problem was fixed in SQL Data Compare v9, however because Packager development lags behind the rest of the SQL tools, the SQL Data Compare DLL in SQL Packager is still version 8.50.

I'll send you a link via private message to a patched version of SQL Packager that uses the new DLL. I don't know if this build is ready for public release yet, but you're welcome to try it.
Back to top
View user's profile Send private message
vasper



Joined: 30 Mar 2012
Posts: 6

PostPosted: Mon Apr 02, 2012 5:14 pm    Post subject: Reply with quote

Thank you for your quick reply, but I tried it and it didn't work. I get the exact same error.

Quote:

Must declare the scalar variable "@pv".
Must declare the scalar variable "@pv".

SQLPackageMAPSD2Store1

Package13.resx

Batch9



As I said, I generate the script and package it inside an exe using only sql packager. The resulting exe I run against the database that needs update.

Version is 6.6.0.347
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Mon Apr 02, 2012 5:46 pm    Post subject: Reply with quote

Ok, sorry we have not got a fix at this time.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Mon Apr 02, 2012 5:48 pm    Post subject: Reply with quote

Just to make sure - you are not setting the maximum data transaction size option?
Back to top
View user's profile Send private message
vasper



Joined: 30 Mar 2012
Posts: 6

PostPosted: Mon Apr 02, 2012 7:38 pm    Post subject: Reply with quote

Nope...
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Tue Apr 03, 2012 9:12 am    Post subject: Reply with quote

I have logged a bug for this (SPA-589).
Back to top
View user's profile Send private message
vasper



Joined: 30 Mar 2012
Posts: 6

PostPosted: Thu Nov 01, 2012 11:24 am    Post subject: Reply with quote

Any news on this? Please, I loose 1 to 2 working days every time I create an update. We do this procedure at least 4 times a year.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Thu Nov 01, 2012 11:28 am    Post subject: Reply with quote

There is no update to this issue.
Back to top
View user's profile Send private message
vasper



Joined: 30 Mar 2012
Posts: 6

PostPosted: Mon Nov 19, 2012 4:13 pm    Post subject: Reply with quote

It is creating a real problem for me due to the size of data I have to upgrade.

Can you at least give me an ETA? Otherwise I will have to look for a different solution.
Back to top
View user's profile Send private message
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