SQLTeam.com | Weblogs | Forums

Experimental ClearTrace build to test SMO loading


#1

I put up an experimental build to test issues with loading the SMO libraries. You can find it at

http://www.scalesql.com/cleartrace/cleartrace.48.zip

The only change is how SMO libraries are loaded. It only includes the GUI.

Please test this out and let me know if it's working for you.


ClearTrace on Windows 10 - Exception
Exception message
#2

Hi,

When clicking "Import Files" I'm getting the exception "Could not load file or assembly 'Microsoft.SqlServer.Instapi, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified."

I have SQL Server 2012, which contains the ClearTrace tables in their own DB.
It looks like I have the SMO assemblies in C:\Program Files\Microsoft SQL Server\120\SDK\Assemblies
I'm trying to import a single trace file.
I get the same error with both ClearTrace versions 47 and 48.

What am I doing wrong? Any help would be much appreciated.


#3

Are you sure that's where SMO is located? I find mine at C:\Program Files (x86)\Microsoft SQL Server\120\SDK\Assemblies. I'm not sure it makes a difference. Although nothing odd surprised me about SMO anymore.

Is there a .txt file in the same location as the ClearTrace.EXE file? That should have a full stack trace that I'd really like to see.