Data Streamer - Runtime errors on second launch

%3CLINGO-SUB%20id%3D%22lingo-sub-738030%22%20slang%3D%22en-US%22%3EData%20Streamer%20-%20Runtime%20errors%20on%20second%20launch%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738030%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%0A%3CP%3EI%20am%20currently%20re-testing%20the%20Data%20Streamer%20Add-In%2C%20and%20I%20noticed%20that%20some%20localization%20bugs%20I%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FDeutsch%2FExcel-Data-Streaming-Add-In-Translation-to-German%2Fidi-p%2F376705%22%20target%3D%22_self%22%3Ereported%20some%20time%20ago%3C%2FA%3E%26nbsp%3Bare%20fixed%2C%20that's%20great.%20Thanks%20%3A)%3C%2Fimg%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20new%20version%2C%20I%20can%20however%20currently%20reproduce%20runtime%20errors%20from%20the%20Add-In%2C%20which%20did%20not%20happen%20in%20March%202019.%20The%20runtime%20errors%20only%20happens%20when%20Excel%20is%20launched%20a%20second%20time%20after%20having%20activated%20the%20Add-In.%20And%20it%20only%20happens%20on%20one%20of%20my%20test%20computers%20-%20the%20one%2C%20which%20has%20a%20COM%20port%20and%20is%20running%20Windows%207%20(German)%20and%20Excel%202016%20monthly%20targeted%20(German%2C%20English%20and%20more%20languages).%20The%20other%20computer%20is%20a%20laptop%2C%20which%20has%20no%20external%20devices%20connected%20and%20is%20running%20Windows%2010.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20seems%20for%20me%2C%20that%20Data%20Streamer%20is%20automatically%20connecting%20a%20device%20on%20the%20problematic%20computer%20and%20does%20not%20release%2Fdisconnect%20the%20device%20after%20closing%20Excel.%20The%20steps%20for%20reproducing%20look%20for%20me%20like%20the%20following%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFirst%2C%20open%20Excel%20and%20activate%20Data%20Streamer%20from%20the%20COM-Add-Ins%2C%20e.g.%20from%20the%20developer%20tools%20tab%20and%20COM%20Add-Ins.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122192i04478A3A229170E8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20button%20on%20the%20left%20for%20connecting%20an%20external%20device%20shows%20me%202%20devices.%20I%20did%20not%20connect%20to%20anyone%20of%20them.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122193iBADB491B8762B9A6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENow%20just%20close%20Excel%20and%20open%20Excel%20again.%20After%20then%2C%20the%20Data%20Streamer%20Add-In%20looks%20like%20the%20screenshot%20below.%20As%20you%20can%20see%2C%20Data%20Streamer%20offers%20to%20disconnect%20a%20device.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20988px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122194i563EB0C79F643C08%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%2C%20this%20does%20not%20work%20and%20any%20click%20on%20a%20command%20on%20the%20menue%20(excepted%20the%20button%20for%20resetting%20the%20data)%20leads%20to%20a%20runtime%20error.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122195i3B4B6E07A8EC0A44%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHere%20the%20same%20error%2C%20which%20appears%20when%20I%20switch%20Excel%20to%20English.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122196i12523D99C6A825AE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20only%20way%20I%20found%20to%20let%20the%20errors%20disappear%20is%20to%20deactivate%20the%20Add-In%20and%20then%20reactivate%20it.%20Works%20for%20one%20session%2C%20meaning%20after%20closing%20and%20reopening%20Excel%2C%20same%20procedure.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENote%3A%20if%20you%20test%20this%2C%20the%20Excel%20Option%20%3CEM%3EShow%20add-in%20user%20interface%20errors%3C%2FEM%3E%20from%20the%20Advanced%20options%20must%20be%20active.%20Otherwise%2C%20no%20error%20messages%20are%20displayed.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBest%2C%3C%2FP%3E%0A%3CP%3EMourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-738030%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EData%20streamer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738236%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Streamer%20-%20Runtime%20errors%20on%20second%20launch%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738236%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%0A%3CP%3Eadditional%20note%3A%20I%20can%20also%20reproduce%20the%20error%20in%20a%20Windows%2010%20%3CSTRONG%3Evirtual%3C%2FSTRONG%3E%20machine%20with%20Excel%202016%2C%20Version%201906%2C%20Build%2011727.20030%2C%20having%202%20COM%20ports.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20987px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122220iECE13A928A71E6EA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20987px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122221iEB9F52C85E127F69%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBest%2C%3C%2FP%3E%0A%3CP%3EMourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777091%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Streamer%20-%20Runtime%20errors%20on%20second%20launch%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777091%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61451%22%20target%3D%22_blank%22%3E%40Mourad%20Louha%3C%2FA%3E%2C%20the%20issue%20seems%20to%20have%20been%20fixed%20with%20the%20comment%3A%20%22Checked%20on%20latest%20build%2016.0.11903.10000%20on%201903%20OS%2C%20there's%20no%20issue%20on%26nbsp%3Bsecond%20launch%20DataStreamer%20and%20no%20error%20pop%20up%20when%20clicking%20button.%20Please%20see%20attached%20video%3A%26nbsp%3B%3CSTRONG%3E%3CI%3ENo%20issue_DataStreamer%20on%20second%20launch.%3C%2FI%3E%3C%2FSTRONG%3E%20Thanks!%22%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI've%20attached%20the%20video%20here%20for%20your%20convenience.%20Let%20me%20know%20if%20you're%20happy%20with%20the%20solution.%20Thanks%2C%20Janna%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777153%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Streamer%20-%20Runtime%20errors%20on%20second%20launch%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777153%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F192213%22%20target%3D%22_blank%22%3E%40Janna%20Braeuning%3C%2FA%3E%2C%3C%2FP%3E%3CP%3Ethanks%20-%20I%20have%20just%20tested%20it%20and%20seen%20that%20Data%20Streamer%20has%20been%20updated%20in%20the%20last%20days.%20It%20has%20Version%205.4.7109%20now.%20The%20version%20before%20was%205.4.7071.%20I%20did%20not%20see%20the%20problem%20in%20the%20new%20version%20and%20a%20second%20start%20works%20fine.%20So%2C%20big%20thanks%20to%20you%20and%20to%20the%20Data%20Streamer%20team.%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3EMourad%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
MVP

Hi there,

I am currently re-testing the Data Streamer Add-In, and I noticed that some localization bugs I reported some time ago are fixed, that's great. Thanks :)

 

In the new version, I can however currently reproduce runtime errors from the Add-In, which did not happen in March 2019. The runtime errors only happens when Excel is launched a second time after having activated the Add-In. And it only happens on one of my test computers - the one, which has a COM port and is running Windows 7 (German) and Excel 2016 monthly targeted (German, English and more languages). The other computer is a laptop, which has no external devices connected and is running Windows 10.

 

It seems for me, that Data Streamer is automatically connecting a device on the problematic computer and does not release/disconnect the device after closing Excel. The steps for reproducing look for me like the following:

 

First, open Excel and activate Data Streamer from the COM-Add-Ins, e.g. from the developer tools tab and COM Add-Ins.

image.png

 

The button on the left for connecting an external device shows me 2 devices. I did not connect to anyone of them.

image.png

 

Now just close Excel and open Excel again. After then, the Data Streamer Add-In looks like the screenshot below. As you can see, Data Streamer offers to disconnect a device.

image.png

 

However, this does not work and any click on a command on the menue (excepted the button for resetting the data) leads to a runtime error.

image.png

 

Here the same error, which appears when I switch Excel to English.

image.png

 

The only way I found to let the errors disappear is to deactivate the Add-In and then reactivate it. Works for one session, meaning after closing and reopening Excel, same procedure.

 

Note: if you test this, the Excel Option Show add-in user interface errors from the Advanced options must be active. Otherwise, no error messages are displayed.

 

Best,

Mourad

3 Replies
Highlighted

Hi there,

additional note: I can also reproduce the error in a Windows 10 virtual machine with Excel 2016, Version 1906, Build 11727.20030, having 2 COM ports.

 

image.png

 

image.png

 

Best,

Mourad

Highlighted

Hi @Mourad Louha, the issue seems to have been fixed with the comment: "Checked on latest build 16.0.11903.10000 on 1903 OS, there's no issue on second launch DataStreamer and no error pop up when clicking button. Please see attached video: No issue_DataStreamer on second launch. Thanks!"

 

I've attached the video here for your convenience. Let me know if you're happy with the solution. Thanks, Janna

Highlighted

Hi @Janna Braeuning,

thanks - I have just tested it and seen that Data Streamer has been updated in the last days. It has Version 5.4.7109 now. The version before was 5.4.7071. I did not see the problem in the new version and a second start works fine. So, big thanks to you and to the Data Streamer team.:)

Best,

Mourad