Toad World® Forums

Refreshing Objects Explorer - error


#1

Hi,
app was left unattended by night, today I’ve tried to refresh OE and I’ve got:

System.InvalidOperationException
Connection must be opened.
Stack Trace:
at Quest.Toad.Trl.BaseSqlTrl.ExecuteQuery()
at Quest.Toad.Trl.BaseSqlTrl.Execute()
at Quest.Toad.Trl.BaseSqlTrl.CreateData(ILiveCache entry, IFilterLiveCache filter, FilterInfo filterInfo)
at Quest.Toad.Trl.BaseSqlTrl.GetData(Boolean filtered, FilterInfo filterInfo, Boolean bCacheDasta, Boolean bIsDeferredCall)
at Quest.Toad.Trl.BaseSqlTrl.GetData(Boolean filtered, FilterInfo filterInfo)
at Quest.Toad.Oracle.Trl.Indexes.ListTableIndexesTrl.GetTableIndexes()
at Quest.Toad.Oracle.Trl.Indexes.ListTableIndexesTrl.get_BackgroundData()
at Quest.Toad.Trl.BackgroundCachedTrl.Process()

App also has showed handled message - as attached.
[As for me it sugests, that connection is still active]

Butter

refresh.png


#2

CR 106485 will be responsible for tracking this bug.

Thanks,

Igor.


#3

Do you happen to be using a Direct Connection to Oracle? Or are you using OCI Client? Direct Connections drop every once in awhile and our code is to check if the connection is open before using. We will fortify the code, but if you are using Direct Connect it would be better to switch to instant Client.

Debbie


#4

No, I’m not using direct connections.

Butter


#5

Okay, thanks. I will keep that in mind.

Debbie