DLL error when importing dbatools

[ACALVETT]

Before submitting a bug report:

Hi,

I downloaded the latest version today and got a timeout error so ran below and receive a dll error, not sure where to start digging into that one, i do have SQL management tools installed on my machine.

Steps to Reproduce

$dbatools_serialimport=$true 
import-module dbatools

Expected Behavior

Module should load without error

Actual Behavior

Exception calling "Invoke" with "3" argument(s): "Could not load file or assembly 'file:///P:\Documents\WindowsPowerShell\MappedModules\dbatools\bin\smo\Microsoft.SqlServer.BatchParser.dll' or one of its dependencies. An attempt was made to load a program with an incorrect format."
At line:151 char:5

$scriptBlock.Invoke($script:PSModuleRoot, "$script:DllRoot\smo", ...

CategoryInfo : NotSpecified: (:) [], MethodInvocationException
FullyQualifiedErrorId : CmdletInvocationException

Environmental data

PowerShell:  
Name                           Value                                                                                                                                                                                                                                                                                                                      
----                           -----                                                                                                                                                                                                                                                                                                                      
PSVersion                      5.1.14409.1018                                                                                                                                                                                                                                                                                                             
PSEdition                      Desktop                                                                                                                                                                                                                                                                                                                    
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}                                                                                                                                                                                                                                                                                                    
BuildVersion                   10.0.14409.1018                                                                                                                                                                                                                                                                                                            
CLRVersion                     4.0.30319.42000                                                                                                                                                                                                                                                                                                            
WSManStackVersion              3.0                                                                                                                                                                                                                                                                                                                        
PSRemotingProtocolVersion      2.3                                                                                                                                                                                                                                                                                                                        
SerializationVersion           1.1.0.1

[wsmelton]

@potatoqualitee This is on Windows 7.

[potatoqualitee]

thank you @wsmelton
@ACALVETT - are you running x86 or x64?

[wsmelton]

@potatoqualitee I can duplicate this with version 0.9.784 on Server 2012 R2 with PowerShell 4.0.

[potatoqualitee]

UNC or plain ol import too?

[potatoqualitee]

plz say plain ol cuz i'd have no idea with unc 😅

[wsmelton]

I don't have unc to test with so this is local disk.

…

On Thu, Mar 14, 2019, 8:00 PM Chrissy LeMaire ***@***.***> wrote: plz say plain ol cuz i'd have no idea with unc 😅 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#5195 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AKr2m0Rait5OiFaAkH4WaCnwAi3guGfQks5vWvCqgaJpZM4bqyVE> .

[potatoqualitee]

why cant i repro?

i guess ill just uhh catch it

[wsmelton]

It was a fresh Azure VM the Windows 2012 R2 DC edition.

[potatoqualitee]

Please try with version 0.9.811, released today. It uses SSMS 2018's SMO 👍

[ACALVETT]

Happy to report that import from UNC works and no more DLL errors when importing with latest build.
Awesome, thank you!