Search

Advertisements

Showing posts with label Error. Show all posts
Showing posts with label Error. Show all posts

SQL Server Error - Msg 9412, Level 16, State 1

We will get this error when we are trying to query XML in SQL Server. If that XML is invalid, Say for example if the closing tag ">" is missed in the input XML

Below error message will be throwed :

Msg 9412, Level 16, State 1, Line 1
XML parsing: line 6, character 5, '>' expected


To resolve the error:

SQL Server - Error Msg 9400, Level 16, State 1, Line

We will get this error when we are trying to query XML in SQL Server. 
 
Each and every XML node should have closing node like this <element>....</element>. XML will become invalid when it has backslash "\" instead of forward slash "/"

Below error will be throwed  when input XML doesn't have proper enclosing node :

Msg 9400, Level 16, State 1, Line 1
XML parsing: line 6, character 5, unexpected end of input
 

To resolve the error:


SQL Server - Error Msg 9455, Level 16, State 1, Line

We will get this error when we are trying to query XML in SQL Server. 
 
Each and every XML node should have closing node like this <element>....</element>. XML will become invalid when it has backslash "\" instead of forward slash "/" and below error will be throwed :
 
Msg 9455, Level 16, State 1, Line 1
XML parsing: line 6, character 2, illegal qualified name character
 

To resolve the error :


SQL Server - SHOWPLAN permission denied in database - Error - Msg 262, Level 14, State 4, Line 1

When a User with minimum privilege try to view the execution plan for a query, below error will throwed:

Msg 262, Level 14, State 4, Line 1
SHOWPLAN permission denied in database 'AdventureWorks2012'.



To resolve the error:

Advertisements