SAP Knowledge Base Article - Preview

2813845 - sp_showplan fails with error Msg 10391, Level 14, State 2 - SAP ASE on BS

Symptom

the command 'sp_showplan <SPID>' failed with error "Msg 10391, Level 14, State 2"

1> sp_showplan '<SPID>'
2> 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

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

sp_showplan, 10391, Msg 10391, Level 14, State 2, monitor qp performance, role , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This 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.