MSSQLSERVER_10539

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

Details

Attribute	Value
Product Name	SQL Server
Event ID	10539
Event Source	MSSQLSERVER
Component	SQLEngine
Symbolic Name	PG_NO_PLAN_FOR_STMT
Message Text	Cannot create plan guide '%.*ls' from cache because a query plan is not available for the statement with start offset %d. This problem can occur if the statement depends on database objects that have not yet been created. Make sure that all necessary database objects exist, and execute the statement before creating the plan guide.

Explanation

A query plan is not available in the plan cache for the statement with the specified starting offset.

User Action

Make sure that all necessary database objects exist, and execute the statement before creating the plan guide.

See Also

sp_create_plan_guide_from_handle (Transact-SQL)