Error in RTD server ExcelObserverRtdServer ConnectData/DisconnectData
56 views
Skip to first unread message
Bennett Blazei
Mar 21, 2017, 4:31:17 PM3/21/17
to Excel-DNA
Hello,
First, Govert, thank you for creating this tool and thank you even more for your continued support in this group. With your help I was able to successfully accomplish feats I never thought doable in Excel.
Long time lurker, first time poster :)
Microsoft Office Professional Plus 2010
ExcelDNA.Integration v0.30.4718.347
I implemented an RTD system following the skeleton put forth by gjvdkamp: https://www.codeproject.com/articles/662009/streaming-realtime-data-to-excel
Everything has been running smoothly for weeks now. However recently I've gotten a few one-off errors that I can't quite track down nor identify if they are things I should really be worried about...
While doing other work outside of Excel, I'll get a little text box popup with the following errors below. There is nothing about this pop-up that screams Excel, and I wouldn't have really known if not for the package names listed. There really don't appear to be any other side effects from this error aside from the pop-up; all the fields that I'm observing continue to update with the correct values, life goes on, and no other errors are reported. This has only happened twice (once last week, and again today) in the >2 months of daily operation and nothing out of the ordinary was happening at either time.
Have you seen this type of error before?
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer ConnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.ConnectData(Topic topic, IList`1 topicInfo, Boolean& newValues)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.ConnectData(Int32 topicId, Array& strings, Boolean& newValues)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Error in RTD server ExcelObserverRtdServer DisconnectData: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at ExcelDna.Integration.Rtd.AsyncObservableImpl.DisconnectObserver(Guid id)
at ExcelDna.Integration.Rtd.ExcelObserverRtdServer.DisconnectData(Topic topic)
at ExcelDna.Integration.Rtd.ExcelRtdServer.ExcelDna.Integration.Rtd.IRtdServer.DisconnectData(Int32 topicId)
Govert van Drimmelen
Mar 21, 2017, 6:47:29 PM3/21/17
to Excel-DNA
Hi Bennett,
The version of Excel-DNA that you are using is quite old. There have been some fixes along the way, some may be relevant to your case.
The first thing I would suggest is to update to the latest version - maybe install the pre-release of version 0.34 from NuGet (in the Package Manager Console put: Install-Package ExcelDna.AddIn -Pre ).
(I'm suggesting this rather than the last stable release, since there were some changes (regression & fix) to the Observable support that affect how these behave when you re-open a workbook.)
If you still have problems on the current version, I'm happy to dig further to see what might be going on.
-Govert
Bennett Blazei
Mar 30, 2017, 12:23:42 PM3/30/17
to Excel-DNA
Hi Govert,
Thanks for the speedy reply! I somehow missed the notification, I'll check more frequently in the future.
I'm happy to upgrade the version as you suggested. As this behavior appears rarely, it may not happen again, but I'll definitely make note if it does.
What is your reasoning for not upgrading to the latest stable? I'm fine working through whatever upgrade pains if the issue is backward compatibility. I'd rather have the latest and greatest especially if there were fixes/ to the Observable support. But if you don't think it's worth it, then I'll take your word for it!
Thanks again,
Bennett
Govert van Drimmelen
Apr 1, 2017, 3:44:43 PM4/1/17
to Excel-DNA
Hi Bennett,
To be clear, I'm suggesting you skip the last stable version (0.33) from 2015 and go ahead with the current release candidate for the next version (0.34) which should be release soon.
-Govert
Reply all
Reply to author
Forward
0 new messages