Error:     [SQLCODE: <-400>:<Fatal error occurred>]     [Cache Error: <<SUBSCRIPT>%0AmEdun+4^%sqlcq.HSREGISTRY.cls966.1 ^||%sql.temp(1,"")>]     [Location: <ServerLoop - Query Fetch>]     [%msg: <Unexpected error occurred:  <SUBSCRIPT>%0AmEdun+4^%sqlcq.HSREGISTRY.cls966.1 ^||%sql.temp(1,"")>]   Here is an example of a query that gives the error:     SELECT COUNT(DISTINCT Criteria) as Relevance FROM HS\_IHE\_ATNA_Repository.Aggregation     WHERE EventType = 'CROSS GATEWAY QUERY' The content of the actual field is XML, but the query simply returns a number.  Here is one that works:     SELECT COUNT(DISTINCT DestinationURI) FROM HS\_IHE\_ATNA_Repository.Aggregation     WHERE EventType = 'CROSS GATEWAY QUERY' The result here is "8" Anyone have any ideas?