SQL Server Errors or Failures from Error: 10522 to Error: 10602

SQLServerF1

 

Error: 10522, Severity: 16, Cannot create plan guide ‘%.*ls’ because @hints has illegal value. @hints must be OPTION(PARAMETERIZATION FORCED) or OPTION(PARAMETERIZATION SIMPLE) if @type is ‘template’.
Error: 10523, Severity: 16, Cannot generate query template because @querytext does not contain a valid single query.
Error: 10524, Severity: 16, Cannot parameterize @querytext.
Error: 10525, Severity: 10, Plan guide ‘%.*ls’ matched statement after it was parameterized automatically by FORCED or SIMPLE parameterization, but the RECOMPILE hint it contains was ignored. RECOMPILE is not supported on automatically parameterized

statements. Consider dropping thi
Error: 10526, Severity: 16, Cannot drop %S_MSG ‘%.*ls’ because its trigger ‘%.*ls’ is referenced by plan guide ‘%.*ls’. Use sp_control_plan_guide to drop the plan guide first. Record the plan guide definition for future use if needed.
Error: 10527, Severity: 16, Cannot create plan guide ‘%.*ls’ because the object ‘%.*ls’ is a temporary object.
Error: 10528, Severity: 16, Cannot create plan guide ‘%.*ls’ because its name is invalid. Plan guide name cannot begin with a ‘#’ character.
Error: 10529, Severity: 16, Cannot create plan guide ‘%.*ls’ because there is already a

planguide ‘%.*ls’ of @type ‘template’ on @stmt.
Error: 10530, Severity: 16, Cannot create plan guide ‘%.*ls’ because the statement specified by @statement_start_offset does not match any statement in specified module or batch. Consider modifying @statement_start_offset to match a statement in module or batch.
Error: 10531, Severity: 16, Cannot create plan guide ‘%.*ls’ from cache because the user does not have adequate permissions. Grant the VIEW SERVER STATE permission to the user creating the plan guide.
Error: 10532, Severity: 16, Cannot create plan guide ‘%.*ls’ because the batch or module specified by @plan_handle does not contain a statement that is eligible for a plan guide. Specify a different value for @plan_handle.
Error: 10533, Severity: 16, Cannot create plan guide ‘%.*ls’ because the plan guide name exceeds 124, the maximum number of characters allowed. Specify a name that contains fewer than 125 characters.
Error: 10534, Severity: 16, Cannot create plan guide ‘%.*ls’ because the value specified for @params is invalid. Specify the value in the form , or specify NULL.
Error: 10535, Severity: 16, Cannot create plan guide ‘%.*ls’ because a plan was not found in the plan cache that corresponds to the specified plan handle. Specify a cached plan handle. For a list of cached plan handles, query the sys.dm_exec_query_stats dynamic management view.
Error: 10536, Severity: 16, Cannot create plan guide ‘%.*ls’ because the batch or module corresponding to the specified @plan_handle contains more than 1000 eligible statements. Create a plan guide for each statement in the batch or module by specifying a statement_start_offset valu
Error: 10537, Severity: 16, Cannot enable plan guide ‘%.*ls’ because the enabled plan guide ‘%.*ls’ contains the same scope and starting offset value of the statement. Disable the existing plan guide before enabling the specified plan guide.
Error: 10538, Severity: 16, Cannot find the plan guide either because the specified plan guide ID is NULL or invalid, or you do not have permission on the object referenced by the plan guide. Verify that the plan guide ID is valid, the current session is set to the correct database
Error: 10539, Severity: 16, 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 datab
Error: 10601, Severity: 16, Cannot specify included columns for a clustered index.
Error: 10602, Severity: 16, Mixing old and new syntax in CREATE/ALTER/DROP INDEX statement is not allowed.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *