| Author |
Message |
vasper
Joined: 30 Mar 2012
Posts: 6
|
 Posted: Fri Mar 30, 2012 2:53 pm Post subject: Bug: Must declare the scalar variable "@pv"Possible Solution |
 |
|
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 |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software
|
| Posted: Mon Apr 02, 2012 3:56 pm Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
vasper
Joined: 30 Mar 2012
Posts: 6
|
| Posted: Mon Apr 02, 2012 5:14 pm Post subject: |
|
|
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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software
|
| Posted: Mon Apr 02, 2012 5:46 pm Post subject: |
|
|
Ok, sorry we have not got a fix at this time.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software
|
| Posted: Mon Apr 02, 2012 5:48 pm Post subject: |
|
|
Just to make sure - you are not setting the maximum data transaction size option?
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
vasper
Joined: 30 Mar 2012
Posts: 6
|
| Posted: Mon Apr 02, 2012 7:38 pm Post subject: |
|
|
| Nope... |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software
|
| Posted: Tue Apr 03, 2012 9:12 am Post subject: |
|
|
I have logged a bug for this (SPA-589).
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
vasper
Joined: 30 Mar 2012
Posts: 6
|
| Posted: Thu Nov 01, 2012 11:24 am Post subject: |
|
|
| 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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6341
Location: Red Gate Software
|
| Posted: Thu Nov 01, 2012 11:28 am Post subject: |
|
|
There is no update to this issue.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
vasper
Joined: 30 Mar 2012
Posts: 6
|
| Posted: Mon Nov 19, 2012 4:13 pm Post subject: |
|
|
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 |
|
|
|
