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.