Toad World® Forums

Error when trying to alter a table


#1

Hello,

Today I received this error when trying to alter a table in Toad 5.0.0.444. What
is curious is just successfully altered the table and went back to do another
modification and received this error. I probably should also mention that this
table has a column in it that is of the xml datatype.

Quest.Toad.SqlServer.Trl.TrlHasEmptyResultSetException

FastTable.Rows.Count = 0, FastTable.Columns.Count = 59 for:
sqlserver://@FNBZDEV/TABLE/Sales/TEST_SalesOrders//dbo/PROPERTIES

Stack Trace:

at Quest.Toad.SqlServer.Trl.BaseObjPropertiesTrl.getProperties()

at Quest.Toad.SqlServer.Trl.Tables.TablePropertiesTrl.get_SystemTable()

at

Quest.Toad.SqlServer.Doe.Tables.TableProperties.OnTablePropertiesLoaded(TablePropertiesTrl
tablePropertiesTrl)

at Quest.Toad.SqlServer.Doe.Tables.TableProperties…ctor(String locator,
IConnection connection, EnumActionType actionType, EnumInitialOptions
enumInitialOptions)

at Quest.Toad.SqlServer.Doe.Tables.TableEditForm.Initialize()

at Quest.Toad.Doe.BaseDoeForm.BaseDoeForm_Load(Object sender, EventArgs e)

at Quest.Toad.Doe.BaseDoeForm.PreShowInitialize()

at Quest.Toad.Doe.BaseDoeForm.Alter(Object sender, UIActionEntry uiEntry, ITrl[]
trls, Object customModeTag)

at Quest.Toad.Doe.BaseDoeForm.Alter(Object sender, ItemClickEventArgs e, Object
customModeTag)

at Quest.Toad.Doe.BaseDoeForm.Alter(Object sender, ItemClickEventArgs e)

After a restart of the application I was able to alter the table. But still is
strange because I had Toad open for about 10 minutes prior to encountering this
issue.

Thanks,

Kent

Kent Maxwell

Business Analyst

TISSUE SYSTEMS


Fabio Perini North America, Inc.

3060 S. Ridge Road • Green Bay, WI 54304

P.O. Box 28380 • Green Bay, WI 54324-0380

Phone: (920) 339-2673 • Mobile: (920) 619-3221

Fax: (920) 338-4315

E-mail: kmaxwell@fabio-perini.com

Internet: www.fabio-perini.com

Skype: kentmaxwell


This e-mail may contain confidential and / or privileged information. If you are
not the intended recipient (or have received this e-mail in error) please notify
the sender immediately and destroy this e-mail. Any unauthorized copying,
disclosure or distribution of the material in this e-mail is strictly forbidden


#2

Kent,

Is this issue reproducible on your end? Most likely it has nothing to do with
xml column of the table. The interesting thing here is your second attempt to
alter the same table. We’ll check this scenario.

Thanks for reporting,

Igor.


#3

Kent, I probably had the same issue and reported same to support…

Gita, please check to see if this is the same as I reported !!! I may have had
the XML issue as well but did not spot it…

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image001.gif


#4

Kent, I probably had the same issue and reported same to support…

Gita, please check to see if this is the same as I reported !!! I may have had
the XML issue as well but did not spot it…

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image002.jpeg