[SSRS] How to get detail error message by table :ExecutionLogStorage

Question

I execute SQL without error message detail , only Status rsProcessingAborted
:

  SELECT B.Path ,a.*
  FROM [ReportServer].[dbo].[ExecutionLogStorage] A,[ReportServer].[dbo].[Catalog] B
  WHERE A.REPORTID=B.ItemID AND B.Path  ='Reportpath' ORDER BY A.TimeStart DESC ;

How to get error message from ssrs table? Thanks !

like below :

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'dsCheck'. (rsErrorExecutingCommand)
ORA-16000: 資料庫或可插拔資料庫已開啟供唯讀存取

Answer 1

First, querying the tables directly is not supported, better use the execution log views, see

Report Server ExecutionLog and the ExecutionLog3 View

But it gives you only the info, if an execution failed, for details you have to lookup error/trace files, see

Reporting Services Log Files and Sources

Answer 2

Hi @ShaoYu Hung(洪紹渝)

Detailed error information is generally stored in log files. Status is a performance diagnosis node, it can only tell you the error code, you need to find the specific details in the log file.

Please see: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/reporting-services-log-files-and-sources?view=sql-server-ver16.

Best regards,

Aniya

Answer 3

ok ,Thanks !