CODEWITHSUNDEEP
marklogicmarklogic-9
SinghVK
SinghVK

Reputation: 323

How to troubleshoot XDMP-RANGEINDEX error?

We are running reindex on one of our database which is 400 GB approx. and we are seeing below debug log entries :-

2021-01-24 16:13:55.705 Debug: IndexerEnv::putRangeIndex: XDMP-RANGEINDEX: Range index error: double "": XDMP-LEXVAL: Invalid lexical value ""
2021-01-24 16:13:55.715 Debug: IndexerEnv::putRangeIndex: XDMP-RANGEINDEX: Range index error: double "": XDMP-LEXVAL: Invalid lexical value ""

It looks like one of the index is not having proper scalar type set or element in document is having invalid values? How can we troubleshoot this issue ? Any suggestions

Upvotes: 2

Views: 239

Answers (1)

grtjn
grtjn

Reputation: 20414

What version of MarkLogic are you running? A quick test with MarkLogic 10.0-5 show a uri in the error message:

2021-01-25 09:36:01.636 Debug: IndexerEnv::putRangeIndex: XDMP-RANGEINDEX: Range index error: int fn:doc("/test/doc1.xml")/root/foo: XDMP-LEXVAL: Invalid lexical value "bar"

Without that, you will need to check which range indexes of type double you have in place, and try if XPath can show you which documents are troublesome. Something like:

subsequence(collection()[//path/to/double = ''], 1, 10) ! xdmp:node-uri(.)

Don't grab them all this way, but grabbing first 10 should be doable. Might give you an idea where to look.

HTH!

Upvotes: 1

Related Questions