Modifying a SP generates "This object requires rebuilding ..."
Modifying a SP generates "This object requires rebuilding ..."
Since the last upgrade, I am receiving a warning "The object requires rebuilding, this may result in the loss of some properties." any time I make a small change to a stored procedure.
At first I thought the message wasn't really relevant because the change I was making was very minor, however after doing some testing, it appears that security rights are being removed.
This has rendered the tool virtually unusable for managing/debug any stored procedures.
I tried to submit a support incident yesterday, however I never receive any notification or feedback since then.
dbForge Studio for MySQL Professional Edition version 7.4.185
Windows Server 2008 R2 Standard SP1 64Bits
At first I thought the message wasn't really relevant because the change I was making was very minor, however after doing some testing, it appears that security rights are being removed.
This has rendered the tool virtually unusable for managing/debug any stored procedures.
I tried to submit a support incident yesterday, however I never receive any notification or feedback since then.
dbForge Studio for MySQL Professional Edition version 7.4.185
Windows Server 2008 R2 Standard SP1 64Bits
Re: Modifying a SP generates "This object requires rebuilding ..."
We will investigate this issue and will answer you as soon as possible.
Re: Modifying a SP generates "This object requires rebuilding ..."
Debug stop on LOOP statements
Re: Modifying a SP generates "This object requires rebuilding ..."
Could you please describe this in more detail and provide us the full script? A video or screenshots demonstrating the issue would be also of help.
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
Re: Modifying a SP generates "This object requires rebuilding ..."
Create the simple stored procedure and start Debug:
Image:
https://drive.google.com/file/d/1gA89QM ... sp=sharing
This software is paid ... it's not free ... even if it were free these errors could not come out in a new version.
Please do not release new versions without testing first.
To do the update we have to stop all our work ...
I buy and pay for the software and I help you identify stupid mistakes like this and still ask me to detail ???
Urgent. I can not develop anything ... I paid for the tool and I have to use it.
Code: Select all
DECLARE p1 INT DEFAULT 0;
label1: LOOP
SET p1 = p1 + 1;
IF p1 < 10 THEN
ITERATE label1;
END IF;
LEAVE label1;
END LOOP label1;
SELECT p1;
https://drive.google.com/file/d/1gA89QM ... sp=sharing
This software is paid ... it's not free ... even if it were free these errors could not come out in a new version.
Please do not release new versions without testing first.
To do the update we have to stop all our work ...
I buy and pay for the software and I help you identify stupid mistakes like this and still ask me to detail ???
Urgent. I can not develop anything ... I paid for the tool and I have to use it.
Re: Modifying a SP generates "This object requires rebuilding ..."
We are really sorry to find out you have experienced the issues with the new version.
Until we release a new build with the fixes, you could use the previous version that can be downloaded from Registered Users' Area.
Until we release a new build with the fixes, you could use the previous version that can be downloaded from Registered Users' Area.
-
- Posts: 11
- Joined: Fri 27 Jan 2017 21:53
Re: Modifying a SP generates "This object requires rebuilding ..."
To the OP, I'm getting this error every time I change a stored procedure also. What properties did you find were changing?
Re: Modifying a SP generates "This object requires rebuilding ..."
We would like to let you know that we released dbForge Studio for MySQL, v7.4.201 where this issue is fixed https://www.devart.com/dbforge/mysql/st ... nload.htmlSince the last upgrade, I am receiving a warning "The object requires rebuilding, this may result in the loss of some properties." any time I make a small change to a stored procedure.
Thank you for your help in improving dbForge Studio for MySQL.
Re: Modifying a SP generates "This object requires rebuilding ..."
Hey there, I've updated to v7.4.201 and this issue still exist.alexa wrote: ↑Fri 06 Apr 2018 06:25We would like to let you know that we released dbForge Studio for MySQL, v7.4.201 where this issue is fixed https://www.devart.com/dbforge/mysql/st ... nload.htmlSince the last upgrade, I am receiving a warning "The object requires rebuilding, this may result in the loss of some properties." any time I make a small change to a stored procedure.
Thank you for your help in improving dbForge Studio for MySQL.
-
- Posts: 11
- Joined: Fri 27 Jan 2017 21:53
Re: Modifying a SP generates "This object requires rebuilding ..."
This issue exists for me also, even after updating to 201.
Re: Modifying a SP generates "This object requires rebuilding ..."
Hello,
>This issue exists for me also, even after updating to 201.
We will investigate the issue and will contact you back once there is any news.
>This issue exists for me also, even after updating to 201.
We will investigate the issue and will contact you back once there is any news.
Re: Modifying a SP generates "This object requires rebuilding ..."
Hello,
Could you provide us with the steps to reproduce and the procedure so we could replicate the issue on our side?
Could you provide us with the steps to reproduce and the procedure so we could replicate the issue on our side?
Re: Modifying a SP generates "This object requires rebuilding ..."
1 - Open a stored procedure, trigger or function
2 - Change something, you could add a single white space, but there's need to be a modification on the file
3 - CRTL + S or press Save button
4 - Shows alert: "The object requires rebuilding, this may result in the loss of some properties."
5 - Click to "Continue"
6 - Saves normally
Re: Modifying a SP generates "This object requires rebuilding ..."
If you place a space inside a stored procedure, dbForge shows such a message. This can be when the user wants to make their own formatting in the procedure using spaces. However, if you place a space outside of a stored procedure, dbForge will automatically remove the space and wont show such a message. This is by design.
Re: Modifying a SP generates "This object requires rebuilding ..."
alexa wrote: ↑Tue 17 Apr 2018 14:21 If you place a space inside a stored procedure, dbForge shows such a message. This can be when the user wants to make their own formatting in the procedure using spaces. However, if you place a space outside of a stored procedure, dbForge will automatically remove the space and wont show such a message. This is by design.
The space was just an example to explain that there's need to be a change on the procedure to the message appear. I believe that the question here is what is the need of this message every time we change something on the procedure?