the command 'sp_showplan <SPID>' failed with error "Msg 10391, Level 14, State 2"
1> sp_showplan '<SPID>'
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)
- 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
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) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.