Crash During Smart Rename

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

Crash During Smart Rename

Postby RMD » Thu Jan 29, 2009 5:54 pm

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.
RMD
 
Posts: 13
Joined: Thu Jan 29, 2009 5:50 pm

Postby Ben Pinchen » Mon Feb 02, 2009 9:25 pm

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
Ben Pinchen
 
Posts: 157
Joined: Thu Dec 28, 2006 1:21 pm
Location: Red Gate

Postby Bernard Sheppard » Mon Feb 16, 2009 6:55 am

+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?
Bernard Sheppard
 
Posts: 39
Joined: Wed Oct 12, 2005 2:24 am
Location: Melbourne, Victoria, Australia

Postby RMD » Mon Feb 23, 2009 4:49 pm

How can I access your bug tracking database so I can see what progress has been made on this topic?
RMD
 
Posts: 13
Joined: Thu Jan 29, 2009 5:50 pm

Postby Brian Donahue » Thu Mar 19, 2009 6:26 pm

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_ ... .4.0.4.zip

If anyone still has problems, feel free to contact us at support (at) red-gate.com.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby James Edwards » Wed Apr 21, 2010 2:42 pm

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
James Edwards
 
Posts: 2
Joined: Wed Apr 21, 2010 2:34 pm

Postby Brian Donahue » Wed Apr 21, 2010 3:02 pm

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

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

If this doesn't work, by all means email support at red-gate.com and we'll go from there.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby James Edwards » Wed Apr 21, 2010 3:16 pm

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
James Edwards
 
Posts: 2
Joined: Wed Apr 21, 2010 2:34 pm

Crash on Smart Rename

Postby forensicare » Tue Jun 22, 2010 2:13 am

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?
forensicare
 
Posts: 1
Joined: Tue Jun 22, 2010 2:05 am

Postby Brian Donahue » Tue Jun 22, 2010 9:17 am

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.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests

cron