Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Rtd server terminated by Excel #724

Open
tomap opened this issue Oct 1, 2024 · 4 comments
Open

Rtd server terminated by Excel #724

tomap opened this issue Oct 1, 2024 · 4 comments

Comments

@tomap
Copy link
Contributor

tomap commented Oct 1, 2024

Hello,

I seem to have stumbled upon this issue:
https://github.com/Excel-DNA/ExcelDna/blob/master/Source/ExcelDna.Integration/ExcelRtdServer.cs#L394

=> my RTD server is stopping

The setup on this Excel (2016, 32 bits) has other ExcelDna plugins, and when the spreadsheet is launched, there are some heavy computations that freeze Excel for some period (maybe up to 30 sec)

I tried to increase the HeartbeatInterval from 15sec to 60sec
The issue seem to be gone, but I'm not sure if this solved the issue
I'm not sure if I'm targeting the right cause

Also, when enabling ExcelDna logs, I found multiple occurences of:
[WRN] Heartbeat callback while Notified in RTD server MyRtdServer - retrying UpdateNotify ExcelDna.Integration

Not sure what it means.

Any help is appreciated

(BTW: I'm still using ExcelDna 1.6 + .Net Framework)

@tomap
Copy link
Contributor Author

tomap commented Oct 29, 2024

Plugin updated to ExcelDna 1.8
Still with a similar issue
It seems now the rtd server is not terminated (at least the terminate is not called) however, some rtd topics are disconnected

Would adding a comvisible() help?
https://github.com/Excel-DNA/Samples/blob/master/RtdClocks/RtdClock-ExcelRtdServer/RtdClockServer.cs#L9
Or is it just an old example?

@govert
Copy link
Member

govert commented Oct 29, 2024

Are you able to make an example that reproduces this, that I can try?

@tomap
Copy link
Contributor Author

tomap commented Oct 29, 2024

hum, probably not, but I'll try...
I believe some other excel plugins (refinitiv & some home made) might be the cause because one case I have is when another plugin is loaded into Excel

@govert
Copy link
Member

govert commented Oct 29, 2024

I wonder how they might be interfering . . . it's not obvious how another add-in could cause that behaviour in your RTD server.

There have been some very isolated and occasional reports of RTD updates getting 'stuck' (and there was a related Excel bug in a recent beta, now fixed). But you're taking about topics getting disconnected unexpectedly. I've not heard of that.
The only normal case would be if you have a UDF wrapper that sometimes fails to call the RTD topic when the cell is updated. That will disconnect the topic (by design).

I'd be very keen to help find any RTD bugs, but I'm not sure where to start. Can you reproduce the disconnect easily, or are these isolated problem reports?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants
@tomap @govert and others