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
