I meant can you run it on the database directly, without Solr, and what
happens?
Best
Charlie
On 29/04/2021 14:00, Anuj Bhargava wrote:
{ "responseHeader":{ "status":0, "QTime":11, "params":{ "q":"*:*", "_":
"1619701169621"}}, "response":{"numFound":179573,"start":0,"numFoundExact":
true,"docs":[ { "country":["AU"], "date_c":"2019-03-14T18:30:00Z",
On Thu, 29 Apr 2021 at 17:18, Charlie Hull <ch...@opensourceconnections.com>
wrote:
What happens if you run exactly that SELECT query on your source database?
Charlie
On 29/04/2021 12:08, Anuj Bhargava wrote:
Ever since installing 8.6 a couple of months ago, the indexing was
working
fine. All of a sudden getting the following error -
4/29/2021, 12:01:59 PM
ERROR false
DocBuilder
Exception while processing: hotels document : SolrInputDocument(fields:
[]):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
to execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
='PK' OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK'
OR country ='MV' OR country ='BT' Processing Document # 1
4/29/2021, 12:01:59 PM
ERROR false
DataImporter
Full Import failed:java.lang.RuntimeException:
java.lang.RuntimeException:
org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
execute query: SELECT * FROM hotels WHERE country = 'IN' OR country ='PK'
OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK' OR
country ='MV' OR country ='BT' Processing Document # 1
Please help
--
Charlie Hull - Managing Consultant at OpenSource Connections Limited
<www.o19s.com>
Founding member of The Search Network <https://thesearchnetwork.com/>
and co-author of Searching the Enterprise
<https://opensourceconnections.com/about-us/books-resources/>
tel/fax: +44 (0)8700 118334
mobile: +44 (0)7767 825828
--
Charlie Hull - Managing Consultant at OpenSource Connections Limited
<www.o19s.com>
Founding member of The Search Network <https://thesearchnetwork.com/>
and co-author of Searching the Enterprise
<https://opensourceconnections.com/about-us/books-resources/>
tel/fax: +44 (0)8700 118334
mobile: +44 (0)7767 825828
