From what you posted you have @xmlDocument declared as nvarchar(1000) but your string is 2997 chars long, so its getting truncated.

after increasing the length. It runs. but returns no Rows