SQLTeam.com | Weblogs | Forums

Error with ClearTraceCmd


#1

Hi,

i'm having an issue with the cmd version (47) where i cannot do an import.
Error:
Processing: TraceOutput.trc
Inner Exception: Exception has been thrown by the target of an invocation.
Inner Exception: Failed to initialize object as reader.
Inner Exception: Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.

The Gui version works without any issues.

i hope someone can help


#2

You can try running the following PowerShell Script for me? And paste the output back here?

cls
$PSVersionTable.PSVersion
[reflection.assembly]::loadwithpartialname("Microsoft.SqlServer.ConnectionInfoExtended")
[reflection.assembly]::Load("Microsoft.SqlServer.ConnectionInfoExtended, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");

You can go through this to know more how to fix the error.
http://www.ithero.nl/post/2013/05/12/How-to-fix-the-error-Exception-has-been-thrown-by-the-target-of-an-invocation-when-using-the-BRI-resolver-in-the-ESB-Toolkit-and-BizTalk-2013.aspx


#3

This is the response from powershell
I'm using it on a windows 2008r2 server with sqlserver 2008R2


#4

Hi,

I've tried ClearTraceCMD on different os versions with different powershell versions but none seem to work.
anyone an idea?