Thursday 1 December 2016

SSRS Reports error in XML document (1, 43464). ' ', hexadecimal value 0x1F, is an invalid character. Line 1, position 43464.




Some Times when we mistake use the Collection and Query use IF Condition it will effet some more SSRS reports  when we get Below Error :-

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
There is an error in XML document (1, 43464).
' ', hexadecimal value 0x1F, is an invalid character. Line 1, position 43464. 


I used the following SQL query to search through the parameters to find which one(s) contain the 1F hex value

SELECT Name 
FROM v_Collection 
WHERE CONVERT(varchar(max),convert(varbinary(max),convert(nvarchar(max),Name)),2) LIKE ‘%1F%’
Here is what we got:

Name 
RestartOSCE _109057 (as Collection name)

No comments: