Crash During Smart Rename

[RMD]

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.

[Ben Pinchen]

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

[Bernard Sheppard]

+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?

[RMD]

How can I access your bug tracking database so I can see what progress has been made on this topic?

[Brian Donahue]

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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[James Edwards]

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

[Brian Donahue]

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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[James Edwards]

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

[forensicare]

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?

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521