MarkLogic: Look up duplicate URIs using the URI Lexicon (for troubleshooting XDMP-DBDUPURI exceptions)

duplicate-uri-lookup.xqy

xquery version "1.0-ml";
(:

  A Utility module to allow the detection of duplicate URIs for a given database
  This can be used in any situation where XDMP-DBDUPURI messages are found in the ErrorLogs

  URIs are sorted by frequency order so higher frequencies (e.g. > 1) indicate that the URI 
  has been found in more than one forest

  This module requires the uri lexicon to be enabled on your database

:)
 
for $uri at $i in cts:uris ((), ('frequency-order', 'descending', 'document'))
let $freq := cts:frequency($uri)
where $freq > 1
return ($uri||': '||$freq)