sql-serverssassql-server-2014sql-server-profiler

Unable to read trace definition file Microsoft Analysis Services TraceDefinition 12.0.5553 when running SQL Server profiler


I'm getting below error when I want to start a trace in profiler

Unable to read trace definition file Microsoft Analysis Services TraceDefinition 12.0.5553.xml. Click OK to retrieve it from server. Retrieval may take a few moments

I tried many advise can be found over the web. no luck so far.

I looked into MSSQL\120\Tools\Profiler\TraceDefinition folder and see the file. there are bunch of the same xml with different version there. So I delete the 5553 file and the ran profiler. I was able to start a trace and the next time I opened profiler, I got the same error.

I looked into the folder and I saw the evil file is there again. Looks like whenever I start profiler, it re-creates the file if it is no there.

Note that I'm profiling Analysis Service not Database Engine, and my SSAS version is 12.0.5553, the same as the xml file.

Thanks in advance.


Solution

  • I had the same issue a few weeks ago. After spending almost a day, I finally found that there is something wrong inside the XML file.

    You can resolve the issue by editing the content of XML. Open the XML and find the <BUILDNUMBER> node. if it is something other than 5553, change it to 5553.

    Looks like the wrong build number on that node will cause the issue.