Msg 567: Unable to retrieve data for this section of the report

In this article, we will discuss the error message “Msg 567: Unable to retrieve data for this section of the report. Following error occurred. File is not a recognizable trace file.

Problem

I encountered this error while I was working with the Log files. I was trying to get various information about the stored procedures like date of creation, last modification, etc. You can visit my article “SQL Server stored procedure modified date” to know more.

  • When I tried to access the Schema Changes History in the SQL Server Management Studio, I got this error.
Msg 567 Unable to retrieve data for this section of the report
The Error Message

Solution – Unable to retrieve data for this section of the report

  • The first thing you would after facing this error is to verify if the path to the log file is correct.
  • In my case, the path was correct but still I was not able to open the Schema Changes History.
  • However, I noticed one thing, the size of this log file was 0 Bytes. Also, there were more log files with the similar names.
  • I concluded that either the file is corrupt or the SQL Server is not able to connect to this log file.
  • Therefore, I deleted the file with 0 Bytes of size i.e. log_23.trc.
  • Then I opened the Schema Changes History again in the SQL Server Management Studio.
  • I noticed that, this time SQL Server was pointing to the another log file. and I was able to access the logs. All the recent logs were available.

You may like the following SQL server tutorials:

In this way, I was able to resolve this issue, Msg 567: Unable to retrieve data for this section of the report