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:
Post a Comment