Professional OPC
Development Tools

logos

Excel RTD - Data Refreshing stops for 5 seconds

More
17 Nov 2019 10:12 - 17 Nov 2019 10:14 #7975 by support
Hello,

thank you for this. The PNG is unfortunately not detailed enough, I will need the actual log files.
Do you have some FTP client? If so, I will send you an email with access data to our FTP server where you can upload files.
If you do not have an FTP client, we will have to find something else.

I have tested attaching a TXT file to this post, and it worked fine from my side, so I do not know what's wrong.

Regards
Attachments:
Last edit: 17 Nov 2019 10:14 by support.

Please Log in or Create an account to join the conversation.

More
16 Nov 2019 12:45 #7973 by Enrico
Hi,

I tried once again to attach all types of files:
* blg -> Unable to get properties for the image.
* txt -> Failed to open upload input stream.
* png ->

I hope one of these attachments is readable for you.

Ciao Enrico
Attachments:

Please Log in or Create an account to join the conversation.

More
15 Nov 2019 10:57 #7972 by support
Hello,

neither .blg nor .txt file name extensions were allowed. They are allowed now. .png was allowed. Please retry, possibly from a different browser. if that fails, I will provide alternative means of delivery.

Best regards

Please Log in or Create an account to join the conversation.

More
14 Nov 2019 15:03 #7971 by Enrico
I tried to attach the blg file from two different pcs as a txt file and also as a png file.

I always get the failure message:

Failed to open upload input stream.

Please Log in or Create an account to join the conversation.

More
14 Nov 2019 14:25 #7970 by Enrico
Hi,

as requested here is the log file of the performance measurement. Let me know is something is missing.

In the meanwhile we moved the Excel-Display onto the main Telemetry Server. That improved the situation dramatically. The log file has been written with the new configuration.

This configuration is OK for a short time workaround (the planned operation is tomorrow), but this will not work as a long time solution, as we would like the Excel-Display to be used for remote stations.

Please let me know if the log file helps or I can do some more tests.

Ciao Enrico

Please Log in or Create an account to join the conversation.

More
13 Nov 2019 14:19 #7969 by support
Thank you.

It is possible that .NET garbage collector may have something to do with this - or possibly not, but we should rule it out first. Please

I am sorry that I have to "task" you again, but there is hardly any other way, unless we get to reproduce the issue on our computer. Basically, I'd like you to run the Performance Monitor tool (included with Windows). I am not sure whether/how you are accustomed to work with it - it's not hard, and there are plenty of materials on the Web to explain.

If you could please use PERFMON to observe the process (in this case, it will be the Excel process), and its GC-related characteristics, and figure out whether there isn't a correlation between .NET GC collections, and the periods of the high CPU usage. The related counters are mainly under ".NET CLR Memory": # Gen n Collections, % Time in GC, # Bytes in all Heaps, #GC Handles etc. Other .NET counters in other groups may be interesting as well, and the CPU consumption.

Seeing the chart of "Gen ... Collections" counter (a screenshot, or send me a data capture file form PERFMON) would allow me to determine whether the .NET garbage collector might be responsible for the pauses.

If you need instructions that are more "step by step", I can work on that too.

Best regards

Please Log in or Create an account to join the conversation.

More
12 Nov 2019 16:11 #7964 by Enrico
Hi,

the video is smaller than the other ones. No clue what is different with the video. But I can explain.

Yes at the same time, when Excel is in 'overload' condition also the connectivity Explorer is.

Yes the GUI was very slow, any control took several seconds. The responsitivity was too slow to work with the connectivity Explorer.

Thanks for taking care!

Ciao Enrico

Please Log in or Create an account to join the conversation.

More
12 Nov 2019 14:47 #7963 by support
Hello,
how big is the Connectivity Explorer video? I may have to increase the maximum allowed size, if it is big.

Was the "irresponsivenes" of Connectivity Explorer at the same moment as that of Excel, or were they generally at different times?
When you write "Impossible to be used", is it meant to say that also the user interface of Connectivity Explorer was irresponsive (e.g. you could work with its controls)?

Thank you

Please Log in or Create an account to join the conversation.

More
12 Nov 2019 09:22 #7960 by Enrico
I'm having difficulties in attaching the video of the connectivity explorer. I have no ideas why, because, it has been recorded with the same tool. What ever, the connectivity explorer was as responsive as Excel, in the order of multiple seconds. Impossible to be used.

Please Log in or Create an account to join the conversation.

More
12 Nov 2019 09:12 #7959 by Enrico
Hi,

thanks for given me the instructions. Nice to see, that we can also aquire 'quality data' and 'error messages'. This will be helpful for other investigations.

As you have been asking me, I have implemented quality and error subscritptions to all the data nodes we have been subscribed.

I have recorded a Video. As you can see, the iimplementation of all the subscribtions has worsen the Situation, but there are no error Messages, and the quality is 'good' for all data nodes.

As requested I also observed the behaviour of the connectivity explorer. Also here I recorded a video. It is stuck like Excel. I wasn't really able to add some data nodes.

Then I recorded the ressource monitor of Windows. One of the cores is at his Limits.

Then I recorded the UA Expert to show that the data come in as expected.

Let me know, if some futher Investigation is needed from my side.

Thanks iin Advance

Ciao Enrico
Attachments:

    MicrosoftE..._CUT.mp4

    Ressourcen...2_30.mp4

    UnifiedAut...8_30.mp4

Please Log in or Create an account to join the conversation.

Moderators: support
Time to create page: 0.235 seconds

      

 Recommend this on Google