none
SSRS logs showing Drop table and drop procedure in logs RRS feed

  • Question

  • ibrary!ReportServer_0-7!3ffc!11/11/2019-15:23:45:: i INFO: RenderForNewSession('/Enterprise Reporting/test')
    processing!ReportServer_0-7!3ffc!11/11/2019-15:24:24:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet1'. ---> System.Data.SqlClient.SqlException: Cannot drop the procedure 'SP_LegalCaseTrackerTracker_LegalBureau_Legal', because it does not exist or you do not have permission.
    Cannot drop the procedure 'EXE018M_P_TMP_TBL_SP', because it does not exist or you do not have permission.
    Cannot drop the procedure 'EXE019M_P_TMP_TBL_SP_SUMMARY', because it does not exist or you do not have permission.
    Cannot drop the procedure 'SPTRCBTCHD', because it does not exist or you do not have permission.
    Cannot drop the procedure 'Clear_ExpectedNNPL_Stgng_SP', because it does not exist or you do not have permission.
    Cannot drop the procedure 'Clear_KPI_Legal_Bureau_Stgng_SP', because it does not exist or you do not have permission.
    Cannot drop the procedure 'Clear_KPI_Legal_Execution_Report_Stgng_SP', because it does not exist or you do not have permission.
    Cannot drop the procedure 'ClearMonthlyAssignByProduct_SP', because it does not exist or you do not have permission.
    Cannot drop the procedure 'Clear_KPI_Legal_SUMMONS_Stgng_SP', because it does not exist or you do not have permission.
    Cannot drop the procedure 'KPI_RPT', because it does not exist or you do not have permission.

    However,in the rdl file there is no drop of any procedure. How can one debug to find why these entries are seen in the report server logs.

    Please help.

    How can I debug which user is dropping in the reporting.

    Tuesday, November 12, 2019 4:11 PM

All replies

  • Hi,

    From the log, we can see, these drops were done by this report: '/Enterprise Reporting/test'.

    You could run this SQL query in your Report Server database to see who's running this report:

    SELECT *
      FROM [ReportServer].[dbo].[ExecutionLog3]
    WHERE [ItemPath]='/Enterprise Reporting/test'

    Hope this helps.

    Regards,

    Lukas


    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, November 13, 2019 12:52 AM
  • Thanks. Let me try.

    Usha

    Wednesday, November 13, 2019 7:13 AM
  • Does it work as we expected?

    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.

    Friday, November 15, 2019 7:52 AM