Red Gate forums :: View topic - Crash During Smart Rename
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Refactor 1
SQL Refactor 1 forum

Crash During Smart Rename

Search in SQL Refactor 1 forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
RMD



Joined: 29 Jan 2009
Posts: 13

PostPosted: Thu Jan 29, 2009 5:54 pm    Post subject: Crash During Smart Rename Reply with quote

Whenever I try to rename a table in my database using the Smart Rename feature, SQL Refactor crashes.

The crash occurs after I've chosen the new schema/name and clicked Next. The next step appears very briefly and then the Smart Rename window disappears.

I don't see any entries in the Event Log. How do I debug this issue? I'm using SQL Refactor 1.3.
Back to top
View user's profile Send private message
Ben Pinchen



Joined: 28 Dec 2006
Posts: 157
Location: Red Gate

PostPosted: Mon Feb 02, 2009 9:25 pm    Post subject: Reply with quote

I'm sorry that you've experienced this issue. It seems that for some reason the Smart Rename function can exit without any warning in certain situations. The developers are aware of this issue and will be looking into it to find out what is causing this. There is already a bug raised against this and for your reference the bug tracking code is: SR-699
Back to top
View user's profile Send private message
Bernard Sheppard



Joined: 12 Oct 2005
Posts: 39
Location: Melbourne, Victoria, Australia

PostPosted: Mon Feb 16, 2009 6:55 am    Post subject: Reply with quote

+1 on this problem.

Any update on SR-699?

Is there a alpha / beta on this fix? I'm very keen to use this function to tidy up some badly named tables before a release to a source-code client.

I have support - should I raise a support call?
Back to top
View user's profile Send private message AIM Address
RMD



Joined: 29 Jan 2009
Posts: 13

PostPosted: Mon Feb 23, 2009 4:49 pm    Post subject: Reply with quote

How can I access your bug tracking database so I can see what progress has been made on this topic?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Thu Mar 19, 2009 6:26 pm    Post subject: Reply with quote

We now have a fix for the Smart Rename issue in SQL Refactor 1.3. The fix not only eliminates the error that causes the window to disappear, but at long last an error dialog will appear with some information about the error and what had caused it. Feel free to get the update from:

ftp://support.red-gate.com/Patches/SQL_Refactor/SQL%20Refactor_1.4.0.4.zip

If anyone still has problems, feel free to contact us at support (at) red-gate.com.
Back to top
View user's profile Send private message
James Edwards



Joined: 21 Apr 2010
Posts: 2

PostPosted: Wed Apr 21, 2010 2:42 pm    Post subject: Reply with quote

Hi,

I have recently purchased ReFactor and the recently released upgrade. However I am still experiencing the problem that was originally posted but now with the error, "An error occured while generating the refactoring:\r\nIndex was outside the bounds of the array .\r\n Please contact support@red-gate.com". This seems to only be on a handful of tables with only one new column name. I have tried those same tables with other new names which seems to work. I guess this is down to something already in my database but I have yet to search the 200 or so objects dependant on the table. Is this something I will have to fix manually or can you guys help?


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



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Wed Apr 21, 2010 3:02 pm    Post subject: Reply with quote

Have you tried the latest patch for Refactor (at this time, build 55)?

http://www.red-gate.com/messageboard/viewtopic.php?t=9960

If this doesn't work, by all means email support at red-gate.com and we'll go from there.
Back to top
View user's profile Send private message
James Edwards



Joined: 21 Apr 2010
Posts: 2

PostPosted: Wed Apr 21, 2010 3:16 pm    Post subject: Reply with quote

Hi,

I have now and get "An error occured while generating the refactoring:Index was outside the bounds of the array. . Please contact support@red-gate.com". Should have mentioned before I am on 2005 standard edition, SP1.

Thanks
Back to top
View user's profile Send private message
forensicare



Joined: 22 Jun 2010
Posts: 1

PostPosted: Tue Jun 22, 2010 2:13 am    Post subject: Crash on Smart Rename Reply with quote

Using SQL Server 2008 any smart rename causes a crash with the following text immediately after pressing the 'Next' button for the new name:
"An error occurred while generating the refactoring: Object reference not set to an instance of an object.. Pleae contact support@red-gate.com.
I have applied the cumulative patch and the version is 1.5.1.74.

Any fixes?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Tue Jun 22, 2010 9:17 am    Post subject: Reply with quote

Hello,

I will open a support case for you and lock this topic. Object Reference not set... errors have too many possible causes and will never be completely "fixed". We'll have to work with you personally in this case to find out what the cause of the exception is.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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