SAP Knowledge Base Article - Preview

3168295 - Running sp_sysmon with end_sample and a report type causes worktable Msg 17197 - SAP ASE


  • When running sp_sysmon with begin_sample / end_sample option
  • And using a report type other than 'kernel' in end_sample command
  • This causes worktable errors 17197 on a second sp_sysmon run for tables tempThreadStats , tempIOCStats , tempWorkQueue  & tempBucketPool

    -- second execution
    sp_sysmon "begin_sample"

    Msg 17197, Level 16, State 1:
    Server 'SP04_PL01', Procedure 'sp_sysmon_collect', Line 205:
    Work table 'tempdb.dbo.tempThreadStats' was found in tempdb.
    This may be because another user has executed sp_sysmon with begin_sample.
    Please run sp_sysmon again after the other sp_sysmon session has finished executing or delete the work table if it is not in use.



SAP Adaptive Server Enterprise (ASE) 16.0 SP04


SAP Adaptive Server Enterprise 16.0


tempdb.dbo.tempThreadStats , tempdb.dbo.tempIOCStats , tempdb.dbo.tempWorkQueue , tempdb.dbo.tempBucketPool  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.