SAP Knowledge Base Article - Preview

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

Symptom

  • 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"
    go

    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.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP04

Product

SAP Adaptive Server Enterprise 16.0

Keywords

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.