SQL Server Errors or Failures from Error: 10339 to Error: 10521

SQLServerF1

 

Error: 10339, Severity: 16, Verification of assembly failed. Could not read from the physical file “%.*ls”: %ls.
Error: 10501, Severity: 16, Cannot create plan guide ‘%.*ls’ because type ‘%.*ls’ provided is not allowed.
Error: 10502, Severity: 16, Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, matches the existing plan guide ‘%.*ls’ in the database. Drop the existing plan guide before creating the new p
Error: 10503, Severity: 16, Operation ‘%.*ls’ is not allowed.

Error: 10504, Severity: 16, Cannot create plan guide ‘%.*ls’ because parameter @hints is incorrect. Use N’OPTION ( [ ,…n ] )’.
Error: 10505, Severity: 16, Cannot create plan guide ‘%.*ls’ because value ‘%.*ls’ provided for @module_or_batch is not legal two-part name. Use ‘schema_name.object_name’.
Error: 10506, Severity: 16, Cannot create plan guide ‘%.*ls’ because parameter @stmt has more than one statement.
Error: 10507, Severity: 16, Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, does not match any statement in the specified module or batch. Modify the values to match a statement in the mo
Error: 10508, Severity: 16, Cannot ‘%ls’ plan guide ‘%.*ls’ because it does not exist or you do not have permission. Verify plan guide name and database of current session, and that

you have needed permission.
Error: 10509, Severity: 16, Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt or @statement_start_offset either contains a syntax error or is ineligible for use in a plan guide. Provide a single valid Transact-SQL statement or a valid starting position of the
Error: 10510, Severity: 16, Cannot create plan guide ‘%.*ls’ because there is already a plan guide with that name in the database. Use a unique name.
Error: 10512, Severity: 16, Cannot create plan guide ‘%.*ls’ because object ‘@module_or_batch’ is encrypted. Consider tuning query using other techniques such as indexes and statistics.
Error: 10513, Severity: 16, Cannot %S_MSG %S_MSG ‘%.*ls’ because it 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: 10515, Severity: 16, Cannot create plan guide ‘%.*ls’ because the module ‘%.*ls’ does not exist or you do not have needed permission.
Error: 10516, Severity: 16, Cannot create plan guide ‘%.*ls’ because @module_or_batch can not be compiled.
Error: 10517, Severity: 16, Cannot create plan guide ‘%.*ls’ because you do not have needed permission. Alter database permission required.
Error: 10518, Severity: 16, Cannot execute sp_control_plan_guide because of insufficient permissions to control plan guide ‘%.*ls’. Alter permission on object referenced by plan guide, or alter database permission required.
Error: 10519, Severity: 16, Cannot create plan guide ‘%.*ls’ because the hints specified in @hints cannot be applied to the statement specified by either @stmt or @statement_start_offset. Verify that the hints can be applied to the statement.
Error: 10520, Severity: 16, Cannot create plan guide ‘%.*ls’ because @type was specified as ‘%ls’ and a non-NULL value is specified for the parameter ‘%ls’. This type requires a NULL value for the parameter. Specify NULL for the parameter, or change the type to one that allows a non
Error: 10521, Severity: 16, Cannot create plan guide ‘%.*ls’ because @type was specified as ‘%ls’ and the parameter ‘%ls’ is NULL. This type requires a non-NULL value for the parameter. Specify a non-NULL value for the parameter, or change the type to one that allows a NULL value fo

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 *