Symptom
The command 'sp_showplan <SPID>' failed with error "Msg 10391, Level 14, State 2"
sp_showplan '<SPID>'
go
Msg 10391, Level 14, State 2:
Server '<SID>', Procedure 'sp_showplan', Line 137:
To execute this command/procedure, you must have the same user identity as the target process or must have one of the following role(s) or permission(s): 'monitor qp performance'. Please contact a user with the appropriate role for help.
The query plan for spid '<SPID>' is unavailable. Possibly the query has not started or has finished executing.
(return status = 1)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
sp_showplan, 10391, Msg 10391, Level 14, State 2, monitor qp performance, role , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
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.
SAP Knowledge Base Article - Preview