VBA Rubberducking - 2018-08-17 (page 3 of 3)

« first day (1533 days earlier) ← previous day next day → last day (1647 days later) »

9:00 PM

I wonder if we're also still cross-logging if 2 ducks are in the same pond.

No error. It starts with "2018-08-17 22:53:04.1094;TRACE-2.2.0.3675;Rubberduck.Common.LogLevelHelper;
Rubberduck version 2.2.0.3675 loading:
Operating System: Microsoft Windows NT 10.0.15063.0 x64
Host Product: Microsoft Office 2013 x86
Host Version: 15.0.5045.1000
Host Executable: EXCEL.EXE;
2018-08-17 22:53:04.1629;TRACE-2.2.0.3675;Rubberduck.App;Checking for legacy Smart Indenter settings.;" and it ends with "2018-08-17 22:56:13.6690;TRACE-2.2.0.3675;Rubberduck.Common.Hotkeys.Hotkey;Hotkey for the associated command Rubberduck.UI.Command.TestExplorerCommand was registered with id 49260;"

Mathieu Guindon

aye, EXCEL.EXE :(

worse.

we're stomping on the other log

But i run it with only AutoCAD open

Mathieu Guindon

so it crashed before it got to log anything?

(or even nuke the older EXCEL log)

9:02 PM

now I'm trying again. just to be sure not to mix up things and logs

So, from what i see, the last host will reset the log

Mathieu Guindon

^

meaning any hosts open prior to the last lost their entries

then as long the hosts are open concurrently, they will intermingle their entries into the same log file

Mathieu Guindon

^

that should make diagnosis EXTRA FUN!

sooo, we need to prefix the log.... MSACCESS.Rubberduck.log, EXCEL.Rubberduck.Log?

Mathieu Guindon

9:03 PM

does that mean we need to include a process ID in log entries?

no I don't want one big file.

that would be horrid

^^

That would be a mess.

Mathieu Guindon

ok but I routinely start two EXCEL.EXE processes, each with their own respective VBE+RD

I could have sworn there was an issue for multi-ducking and log files...

per-host log file seems a simple way out....

Mathieu Guindon

9:04 PM

and I'm sure I'm not the only one doing that

hm. maybe we need timestamp, too

Mathieu Guindon

we have the timestamps...

so EXCEL.Rubberduck.20180816144839.log

Mathieu Guindon

ah

no in the file name

Mathieu Guindon

9:04 PM

hmm

HTH do we clean those up?

Yeah ^ was just thinking that

Mathieu Guindon

NLog cleans them up

that means rotation.

Issue #7854: RD ate my hard drive.

9:05 PM

oh they're NLog?

you can configure Nlog to rotate 10 log files

Mathieu Guindon

^

or some reasonable value

Mathieu Guindon

@Comintern lol

it errors out and the log file begins with "2018-08-17 23:02:51.8076;FATAL-;Rubberduck._Extension;Startup sequence threw an unexpected exception.;Castle.MicroKernel.ComponentActivator.ComponentActivatorException: ComponentActivator: could not instantiate Rubberduck.Parsing.VBA.RubberduckParserState ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. --->....(to be continued)

Will it rotate on a timestamp? I was thinking it only did dates for some reason.

9:06 PM

"System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Autodesk.AutoCAD.Interop.AcadApplication'. " ...

is there a way to upload a txt file?

@Comintern IIRC, on one webserver we run, we rotate on both timestamp and number of files.

@DisplayName Just attach it to the git issue.

Mathieu Guindon

or just type ``` {enter} then paste and do ``` again

@DisplayName Uh oh.....

@DisplayName, do you have any other add-ins running on AutoCAD?

[rubberduck-vba/Rubberduck] RICVBA created comment on issue #4283: Problem with AutoCAD VBA

> and here's the "RubberduckLog.txt]"

[RubberduckLog.txt](https://github.com/rubberduck-vba/Rubberduck/files/2298733/RubberduckLog.txt)

9:08 PM

You thinking #4041?

[rubberduck-vba/Rubberduck] RICVBA closed issue #4283: Problem with AutoCAD VBA

[rubberduck-vba/Rubberduck] comintern reopened issue #4283: Problem with AutoCAD VBA

I clicked the wrong button...

@Comintern Yes

NP, I got it.

thanks @Comintern

9:09 PM

I also just checked --- AutoCAD isn't the one that Carlos had problem with. It was Inventor.

so shim solution does apply still.

I could have sworn he mentioned AutoCAD.

Mathieu Guindon

Carlos said shim would just need to be disabled in AutoCAD

but we don't have a shim ATM

no. Inventor.

visualstudioextensibility.com/2016/07/11/…

different product by same company

(right?)

I'm probably confusing it with the random guy.

Anyone know of a way to have a file "forwarded" to another folder if it's put into a specific folder? IE anything that's moved into \\Foo\Bar will automatically be forwarded to `\\Buzz\Bazz\Fazz`.

9:15 PM

What do you mean by "forwarded"? Copied?

i'd just make the \\Foo\Bar a symlink to the \\Buzz\Bazz\Fazz

Preferably moved but copied would work.

Mathieu Guindon

@IvenBach docs.microsoft.com/en-us/dotnet/api/…

@this Now you're more Linux-like...

Your path separators are backward though.

I have a "mnl" file, two "lsp" files,"accoremgd.dll", "acetauto.LSP", acetmain.mnl", acettest.fas", "acetutil.fas", "aclaunchnfw.arx", "acmgd.dll", "acvmtools.crx", "vl.crx". All these I cannot unload. Then I have "acapp.arx", acapp.crx", "acautoloader.arx", "accloudconnect.crx", "acdim.arx", "acdim.crx", "acetutil.arx", "acobjclassimp.arx", "AcOcSchemaUtil.arx", "acopm.arx", "acopmext.arc", "AcPEXCtl.arx", "Acpi.arx", "acsign.arx", "actp.arx", "vl.arx". These I can unload

9:21 PM

@DisplayName no I mean other VBA addins.

e.g. via Tools -> AddIn Managers

(or are they all that?)

@Comintern only to a windows user. It's proper the way it is.

[rubberduck-vba/Rubberduck] bclothier created comment on issue #4041: Discussion: COM Shims

> Linking issue #4283 as it seems to be also affected by the lack of shim. Being just AutoCAD, it is not subject to the issue Carlos identified with the Inventor.

I wonder if Autodesk is using some common code there now.

then it shouldn't have had that problem?

AIUI, Inventor would crash if there's a shim but is peachy with non-shim

Actually I'm assuming that Inventor will never have that particular error we're discussing.

@this peachy if only one interop addin is loaded at a time, sure...

Mathieu Guindon

TTQW

9:28 PM

@this, what I listed "should" be all that is being loaded. While I did have to run a VBA enabler (which I cannot find/recognize in that list) since VBA has been officially abandoned by AutoCAD for some time

Oh okay. The extensions confused me for a second.

If they are all truly VBA addins, then we can try and disable them as much as you can then see if RD will work

@MathieuGuindon Thanks.

@this, that is what I'm trying to do. But with no success at all: even files eligible for Unloading don't get unloaded...

hmm. that's weird. screenshot?

how to load them?

9:37 PM

no no, screenshot of the addin manager

but how to show a screenshot here?

simplest thing to do is copy and paste into a github issue (but don't comment!), copy the URL and paste it here

like this?

!capture

that works and now makes sense

that's not the addin manager i'm talking about

user image

user image

^ that's the VBA Addin manager.

I had to uninstall RD to get there! Anyway, nothing installed

user image

9:49 PM

fyi - to onebox the image you have to get rid of the ![capture( and the )

so it confirms that there are NO other addins loaded.

Which wouldn't lead to the lack of shim being an explanation. :|

(the one I was thinking is when there are 2 add-ins loaded at same time; one will fail with the error that we just saw)

Can transferring too much from a remotely connected computer cause you to disconnect?

@IvenBach #ItDepends

on what the connection is and how it's configured

are you talking about copying files?

#ProTip don't wire the ethernet cable willy-nilly on the floor across rooms.

@this, sadly I suppose. anyhow hear you all tomorrow

thanks for your help, @DisplayName! we'll get to the bottom of it!

9:56 PM

@mansellan Connected to a remote computer via RDP. I'm having to transfer files from it to our network.

RDP shouldn't have size limits

iiuc

but there may be, for example, a firewall in between that is killing the connection

Wouldn't be surprised if there is. It's taking forever and I need these files yesterday.

31 mins ago, by DisplayName

@this, what I listed "should" be all that is being loaded. While I did have to run a VBA enabler (which I cannot find/recognize in that list) since VBA has been officially abandoned by AutoCAD for some time

What's the VBA enabler doing I wonder...

@Comintern afaict from the autodesk site, VBA isn't installed by default any more - the "enabler" dl's and installs it.

Yeah, but I'm thinking there's some underlying reason for that.

10:01 PM

plausible

[rubberduck-vba/Rubberduck] bclothier edited comment on issue #4041: Discussion: COM Shims

> Linking issue #4283 as it seems to be also affected by the lack of shim. Being just AutoCAD, it is not subject to the [issue Carlos identified with the Inventor](http://www.visualstudioextensibility.com/2016/07/11/the-strange-case-of-mz-tools-8-0-crashing-the-vba-editor-of-autodesk-inventor/).

Update: On further investigation, there is no other add-ins loaded so it might not be related after all?

> VBA sends messages using the AutoCAD ActiveX Automation Interface. AutoCAD VBA permits the Visual Basic environment to run simultaneously with AutoCAD and provides programmatic control of AutoCAD through the ActiveX Automation Interface. This linking of AutoCAD, ActiveX Automation, and VBA provides an extremely powerful interface. It not only controls AutoCAD objects, it also can send data to or retrieve data from other applications.

"Permits" is an odd word choice there.

@mansellan When the transfer rate is bouncing up and down 150mb/s to 3mb/s back up to 150? briefly is that an indication of throttling?

Over the course of a 2 minutes it ranges between high and low, usually kept on the low side.

fyi copying over RDP is brutal.

it's ok when you're copying a small text file but for anything bigger, bouncing it over dropbox is likely to be faster

@Comintern hmm. I wonder if that means it basically loads the VBA environment using COM interop. That might cause the interop DLL to be loaded already and thus the error?

@IvenBach not necessarily, could just be a lumpy network. I get that regularly at work.

10:06 PM

@this That's what I was thinking. keanw.com/2014/02/crashing-autocad-using-net.html

I'm noticing how brutal indeed...

hi @CarlosQuintero :-)

@CarlosQuintero welcome to the pond

> The plug-in has allowed many developers to continue using VBA routines, albeit with some difficulty: Because VBA is a 32-bit application, it runs as a separate 32-bit process on 64-bit AutoCAD, resulting in sluggish behavior and even crashing of VBA routines. VBA’s days are clearly numbered for AutoCAD users.

Sounds like they didn't get the VBA7 after all.

10:11 PM

Yeah, I wonder if they just didn't re-up their licensing with MS.

well, officially, MS never released VBA7 SDK to ISVs. Someone here argued that some ISVs did get VBA7 but I don't know if that's the case.

Possibly relevant: through-the-interface.typepad.com/through_the_interface/2010/02/…

I have a feeling that any solution originates from that guy's blog.

Hmm. Interesting; he's using IMessageFilter

that seems to be in lieu of handling a message pump

I just had a look at how RD uses the host application atm.

No, that's nothing to do with message pumps. IMessageFilter is at COM level still.

10:16 PM

There are two easy fixes I see for the AutoCAD problem:

1) Simply also catch invalid cast exceptions when COM reflecting the host application and set it to null in case there is an error.

2) Stop reflecting the host application alltogether and only safe the name.

The only thing RD uses the host application for anymore is in two places in the DeclarationFinder that reuire the name of the host application.

@Comintern what do you think of this?

> To enable behaviors such as focus management and type-ahead to function correctly, input-synchronized calls require the called object to complete the call before relinquishing control.

Carlos Quintero

The AutoCAD problem that you are getting is System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Autodesk.AutoCAD.Interop.AcadApplication'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{2959C1CC-8577-4EDB-ADDC-6EBBAB147926}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

[rubberduck-vba/Rubberduck] mansellan created pull request #4284: Quick hack to fix VB6 crash on certain project types to merge mansellan/Rubberduck/4280 into rubberduck-vba/Rubberduck/next

> Closes #4280.

This is just a quick hack to remove the Forms context menu from VB6 RD. I'll open another issue to put back the menu, which will need some thought as to how best to hook the form designer load event and attach the menu at the right time.

F5'd in VB6 and VBA to make sure no other menus affected.

@this We're really not interacting with the host directly at that point.

To clarify, I was thinking about our subclassing / interacting w/ VBE

Carlos Quintero

10:20 PM

On May 28, 2016 I saw this only once on my machine, and it was not AutoCAD but some Office app:

System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'VBClassicExtensibility.VBE'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{0002E166-0000-0000-C000-000000000046}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

Target Site: Void MZTools.Adapters.IDTExtensibility2.OnConnection(System.Object, MZTools.Adapters.ConnectMode, System.Object, System.Array ByRef)

[rubberduck-vba/Rubberduck] connerk forked us into connerk/Rubberduck

3

@M.Doerner While it's true that we don't really use IHostApplication for anything beyond getting its name, there are other issues where solution may depend on getting access to its OM to investigate the state of document modules. For example, if an Access form is open, parser probably should not parse that open form. But I don't think it's possible to know that using VBIDE OM alone.

@CarlosQuintero just to be clear, that's fixed by having a shim, too? I ask because that is also mentioned in this issue which you commented about.

Carlos Quintero

I am not sure if a shim fixes that problem, because the only time I saw that issue was when I was introducing a shim and I am not sure if the shim was active or not. But I was not able to reproduce the problem, it was sporadic, and it was Office or VB6, not sure. If your AutoCAD problem is reproducible is a good thing.

Gotcha. AIUI, yes it's consistently reproducible for the guy (@DisplayName ) with AutoCAD. He got to crash it few times.

The one about classic VB extensibility never got resolved since it's been impossible to reproduce.

Carlos Quintero

Which is "The one about classic VB extensibility"?

10:34 PM

[rubberduck-vba/Rubberduck] build for commit 7afb435d on unknown branch: AppVeyor build succeeded

The issue I just linked

[rubberduck-vba/Rubberduck] [codecov[bot]](github.com/apps/codecov) created comment on pull request #4284: Quick hack to fix VB6 crash on certain project types

> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4284?src=pr&el=h1) Report
> Merging [#4284](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4284?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/055d9110421e53908807d8aac9348209f4af3b55?src=pr&el=desc) will **decrease** coverage by `0.01%`.
> The diff coverage is `45.45%`.

```diff
@@ Coverage Diff @@
## next #4284 +/- ##
=========================

[rubberduck-vba/Rubberduck] build for commit 7afb435d on unknown branch: 52.3% (target 0%)

Carlos Quintero

@this Ah, that is reproducible and solved by a COM Shim for sure. Since MZ-Tools has a COM Shim, likely it was not active due to the presence of HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Autodesk but the person who opened the issue never responded to confirm the existence of that key.

@CarlosQuintero maybe i'm blind but I don't see anything from the original poster to indicate that AutoDesk was at play?

Carlos Quintero

@this That was what I was asking him, if he had AutoDesk installed. Because if MZ-Tools detects AutoDesk then it doesn't register the shim and therefore the InvalidCastException can happen. If the shim is active, the InvalidCastException should not happen. Another possibility is that he was using a very old version of MZ-Tools that lacked shims (before Jun 2016)

10:45 PM

Gotcha

ttgtb

11:28 PM

Stars and Forks a-plenty today.

11:46 PM

Don't Workbook.ExportAsFixedFormat ... with the file open that you're going to export it as. Had a WTF moment till I realized it was my derpy fault.

« first day (1533 days earlier) ← previous day next day → last day (1647 days later) »

Transcript for

Aug '1817

VBA Rubberducking

This chat has moved to Discord: discord.gg/MYX9RECenJ

antlr com-interop parsing rubberduck vb6 vba whiskey-tango-foxtrot

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile