Hey, I have faced this type of issue while upgrading to ML8 and I solved it creating range index only. Did you check collation
Could you give some more details with an example? I could try to help you. Regards, Indy On Wed, Nov 25, 2015 at 11:22 PM, Ashley Peacock <[email protected]> wrote: > Hey, > > Yup I think so, I created an element range index with the namespace field > left blank and the local name as insert_timestamp. > > Ashley > > Sent from my iPhone > > > > *Ashley Peacock* > > Developer II > Elevate Credit International Limited > P: 01284 717800 | Ext: 877 | Elevate.co.uk <http://elevate.co.uk> > Amadeus House, Floral Street, Covent Garden, London WC2E 9DP > > > > Privileged and Confidential. This e-mail, and any attachments thereto, is > intended only for use by the addressee(s) named herein and may contain > privileged and/or confidential information. If you have received this > e-mail in error, please notify me immediately by a return e-mail and delete > this e-mail. You are hereby notified that any dissemination, distribution > or copying of this e-mail and/or any attachments thereto, is strictly > prohibited. > > Elevate Credit International Limited is registered in England & Wales with > Company Number 05041905. Registered Office: 27-28 Eastcastle Street, > London, W1W 8DH > > > > On 25 Nov 2015, at 17:40, Indrajeet Verma <[email protected]> > wrote: > > Have you created range index on element "insert_timestamp" type of > dateTime and without namespace? > > Regards, > Indy > > On Wed, Nov 25, 2015 at 9:44 PM, Ashley Peacock <[email protected]> > wrote: > >> Just to add to the below, I removed the index I added and re-ran the >> check-options and it comes up with a suggestion for an index… which is the >> exact index I had added. I re-added it, re-ran the check and nothing comes >> back suggesting I added the right index. >> >> >> >> I restarted the MarkLogic service, and even after that I still get the >> same response from the API as per below so somewhat stumped! >> >> >> >> Ashley >> >> >> >> >> >> *<imagea4201f.PNG>* >> >> *Ashley Peacock* >> >> Developer II >> Elevate Credit International Limited >> P: 01284 717800 | Ext: 877 | Elevate.co.uk <http://elevate.co.uk> >> Amadeus House, Floral Street, Covent Garden, London WC2E 9DP >> >> >> >> Privileged and Confidential. This e-mail, and any attachments thereto, is >> intended only for use by the addressee(s) named herein and may contain >> privileged and/or confidential information. If you have received this >> e-mail in error, please notify me immediately by a return e-mail and delete >> this e-mail. You are hereby notified that any dissemination, distribution >> or copying of this e-mail and/or any attachments thereto, is strictly >> prohibited. >> >> Elevate Credit International Limited is registered in England & Wales >> with Company Number 05041905. Registered Office: 27-28 Eastcastle >> Street, London, W1W 8DH >> >> >> >> *From:* [email protected] [mailto: >> [email protected]] *On Behalf Of *Ashley Peacock >> *Sent:* 25 November 2015 15:44 >> *To:* [email protected] >> *Subject:* [MarkLogic Dev General] SEARCH-BADORDERBY >> >> >> >> Hey, >> >> >> >> I have added the following search option: >> >> >> >> <options xmlns="http://marklogic.com/appservices/search";><sort-order >> type="xs:dateTime" direction="descending"><element ns="" >> name="insert_timestamp"/><annotation>Order by the timestamp, >> descending</annotation></sort-order></options> >> >> >> >> If I then query using that search option, I get the following result: >> >> >> >> {"errorResponse":{"statusCode":400, "status":"Bad Request", >> "messageCode":"SEARCH-BADORDERBY", "message":"SEARCH-BADORDERBY: >> (err:FOER0000) Indexes are required to support element, element-attribute, >> json-property, or field sort specifications."}} >> >> >> >> I’ve added an element range index to the field it’s querying on (and it’s >> re-indexed), and it still throws the same error. It said in the docs I >> could check the index required using: >> >> >> >> search:check-options( >> >> <options xmlns="http://marklogic.com/appservices/search";><sort-order >> type="xs:dateTime" direction="descending"><element ns="" >> name="insert_timestamp"/><annotation>Order by the timestamp, >> descending</annotation></sort-order></options>, >> >> true() >> >> ) >> >> >> >> But that yielded no result (“your query returned an empty sequence”) >> which makes me think the index is correct… yet it still throws the same >> error. >> >> >> >> Does anyone have any ideas? >> >> >> >> Thanks, >> >> >> >> Ashley >> >> >> >> *<image002.jpg>* >> >> *Ashley Peacock* >> >> Developer II >> Elevate Credit International Limited >> P: 01284 717800 | Ext: 877 | Elevate.co.uk <http://elevate.co.uk> >> Amadeus House, Floral Street, Covent Garden, London WC2E 9DP >> >> >> >> Privileged and Confidential. This e-mail, and any attachments thereto, is >> intended only for use by the addressee(s) named herein and may contain >> privileged and/or confidential information. If you have received this >> e-mail in error, please notify me immediately by a return e-mail and delete >> this e-mail. You are hereby notified that any dissemination, distribution >> or copying of this e-mail and/or any attachments thereto, is strictly >> prohibited. >> >> Elevate Credit International Limited is registered in England & Wales >> with Company Number 05041905. Registered Office: 27-28 Eastcastle >> Street, London, W1W 8DH >> >> >> >> >> >> Click here >> <https://www.mailcontrol.com/sr/7AmiNuPOlljGX2PQPOmvUmuFhuAgpUQ2de42Ozqoni8W2Wz4rmzPyDPi7XX!24hFyrF0K9sQw3yGoJj9+I0bOg==> >> to report this email as spam. >> >> >> _______________________________________________ >> General mailing list >> [email protected] >> Manage your subscription at: >> http://developer.marklogic.com/mailman/listinfo/general >> >> > _______________________________________________ > General mailing list > [email protected] > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general > > > _______________________________________________ > General mailing list > [email protected] > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general > >
_______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
