none
ASTrace and SQL Server 2016 RRS feed

  • Question

  • Hi,

    We've been using ASTRACE with SQL 2012/Windows Server 2008 R2 for a good while now. We are currently migrating to new SQL Server 2016 SP1/CU1 Windows 2012 R2 servers. I have tried to install the version of AStrace we have been using on 2012 and also copied the latest ASTrace from GitHub.

    It seems to install OK but I cannot start the service  - I get the following error:

    Log Name:      Application
    Source:        .NET Runtime
    Date:          11/04/2017 16:30:41
    Event ID:      1026
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      XXXWISQLP14.BlueCrest.local
    Description:
    Application: ASTrace.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.IO.FileNotFoundException

    Exception Info: System.IO.FileNotFoundException
       at ASTrace.Trace..ctor()
       at ASTrace.Program.Main()

    Does anyone have any suggestions, please, why I am having this issue? The config file is shown below and the service account should have permissions:

    regardd

    Ken

    <?xml version="1.0"?>
    <configuration>
        <configSections>
            <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
                <section name="ASTrace.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
            </sectionGroup>
        </configSections>
        <applicationSettings>
            <ASTrace.Properties.Settings>
                <setting name="AnalysisServerNames" serializeAs="String">
                    <value>XXXWISQLP14\SSAS01</value>
                </setting>
                <setting name="SQLServer" serializeAs="String">
                    <value>XXXLWISQLP14\INST01</value>
                </setting>
                <setting name="SQLServerDatabase" serializeAs="String">
                    <value>TraceDB</value>
                </setting>
                <setting name="TraceTableName" serializeAs="String">
                    <value>ASTraceTable</value>
                </setting>
                <setting name="TraceDefinition" serializeAs="String">
                    <value>Standard.tdf</value>
                </setting>
                <setting name="PreserveHistory" serializeAs="String">
                    <value>True</value>
                </setting>
                <setting name="RestartRetries" serializeAs="String">
                    <value>3</value>
                </setting>
                <setting name="RestartDelayMinutes" serializeAs="String">
                    <value>5</value>
                </setting>
            </ASTrace.Properties.Settings>
        </applicationSettings>
      <startup useLegacyV2RuntimeActivationPolicy="true">
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
      </startup>
       <runtime>
          <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
             <dependentAssembly>
                <assemblyIdentity name="Microsoft.SqlServer.ConnectionInfo" publicKeyToken="89845dcd8080cc91" />
                <bindingRedirect oldVersion="10.0.0.0" newVersion="11.0.0.0" />
                <publisherPolicy apply="no" />
             </dependentAssembly>
          </assemblyBinding>
          <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
             <dependentAssembly>
                <assemblyIdentity name="Microsoft.SqlServer.ConnectionInfoExtended" publicKeyToken="89845dcd8080cc91" />
                <bindingRedirect oldVersion="10.0.0.0" newVersion="11.0.0.0" />
                <publisherPolicy apply="no" />
             </dependentAssembly>
          </assemblyBinding>
       </runtime>
    </configuration>



    Ken E


    • Edited by Ken Eng Tuesday, April 11, 2017 4:24 PM
    Tuesday, April 11, 2017 4:23 PM

Answers

All replies

  • <assemblyIdentity name="Microsoft.SqlServer.ConnectionInfoExtended" publicKeyToken="89845dcd8080cc91" />

    Hello Ken,

    Have you also installed latest AMO and SMO assemblies Microsoft® SQL Server® 2016 Feature Pack; that mentioned assembly is from SMO.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, April 11, 2017 4:44 PM
  • I'll give that a try and let you know,

    regards

    Ken


    Ken E

    Tuesday, April 11, 2017 4:48 PM
  • Installed AMO and SMO from the feature pack, restarted the ssas service and reinstalled ASTRACE but no luck I'm afraid :-(

    regards

    ken


    Ken E

    Tuesday, April 11, 2017 4:59 PM
  • And you installed AMO/SMO in same 32/64 bit architecture as the used ASTrace?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, April 11, 2017 5:50 PM
  • We're running 64 bit. I guess ASTRACE is 32 bit, I'll check tomorrow,

    cheers

    Ken


    Ken E

    Tuesday, April 11, 2017 8:53 PM
  • Hi Ken,

    Thanks for your question.

    I agree with Olaf, you may need to install AMO/SMO in same 32/64 bit architecture as the used ASTrace.

    You can also refer to blog Installing ASTrace.exe in a 64-bit enviroment.

    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, April 12, 2017 6:34 AM
    Moderator
  • The easiest is to install both.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, April 12, 2017 6:51 AM
  • Thanks - I installed both and also copied the registry key from our older Windows 2008 R2 server pointing to the location as per the link you mentioned. Still no luck! I'm not a c# dev so I'll get one of our devs to help me rebuild the project.

    Many thanks for you help so far

    Ken



    Ken E

    Wednesday, April 12, 2017 8:46 AM
  • I know this is an old thread, but for anyone else still looking....

    Per:

    Exception Info: System.IO.FileNotFoundException

    Exception Info: System.IO.FileNotFoundException
       at ASTrace.Trace..ctor()
       at ASTrace.Program.Main()

    I had to install a lower version of SSMS.  I had 18.x version and I installed an 17.x version and ASTRACE worked.

    (I installed 17.9.1)

    Thursday, November 14, 2019 8:15 PM