Saturday, March 11, 2006

Internal server error:Missing LinkUrl


I've had a problem with this and I've seen other people having problem with this too.
If after making a SQL Full Text query like this:


SELECT
"DAV:getcontentlength",
"urn:schemas-microsoft-com:office:office#Title",
"Rank"
FROM Portal_Content..Scope()
WHERE ("DAV:getcontentlength" > 10000)
ORDER BY "DAV:getcontentlength"

using search.asmx web service you get this error:

<?xml version="1.0" encoding="utf-16"?>
<ResponsePacket xmlns="urn:Microsoft.Search.Response">
  <Response domain="QDomain">
    <Copyright>Microsoft (c) Office SharePoint (tm) Portal Server 2003</Copyright>
    <Status>ERROR_SERVER</Status>
    <DebugErrorMessage>Internal server error:Missing LinkUrl</DebugErrorMessage>
  </Response>
</ResponsePacket>

it's not a xml error. Just add this column to a select

"DAV:href"

and query it again

SELECT
"DAV:href",
"DAV:getcontentlength",
"urn:schemas-microsoft-com:office:office#Title",
"Rank"
FROM Portal_Content..Scope()
WHERE ("DAV:getcontentlength" > 10000)
ORDER BY "DAV:getcontentlength"

No comments: