lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrea Gazzarini <a.gazzar...@sease.io>
Subject Re: Silent error from DataImportHandler
Date Mon, 10 Sep 2018 15:26:15 GMT
I cannot give you detailed instructions as I don't have in front of me a 
Solr console with the dataimport enabled, but I remember that there's a 
detailed section which reports a lot of information.

In the meantime: shooting in the dark, if the query is working and 
"total rows fetched" = 0, then the query is not working for some reason: 
can you check if some clause in your SQL include < or > ? They need to 
be escaped (&lt; &gt;)

Andrea


On 10/09/2018 17:22, Monique Monteiro wrote:
> This is shown in the section "Raw Debug-Response".
>
> On Mon, Sep 10, 2018 at 12:20 PM Andrea Gazzarini <a.gazzarini@sease.io>
> wrote:
>
>> Hi Monique, this is the output; when you check the debug checkbox
>> another section is printed
>>
>> Andrea
>>
>> On 10/09/2018 17:19, Monique Monteiro wrote:
>>> Text:
>>>
>>> { "responseHeader": { "status": 0, "QTime": 463 }, "initArgs": [
>> "defaults",
>>> [ "config", "data-cnpj-config.xml" ] ], "command": "full-import", "mode":
>>> "debug", "documents": [], "verbose-output": [], "status": "idle","
>>> importResponse": "", "statusMessages": { "Time Elapsed": "0:0:0.432",
>> "Total
>>> Requests made to DataSource": "1", "Total Rows Fetched": "0", "Total
>>> Documents Processed": "0", "Total Documents Skipped": "0", "Full Dump
>>> Started": "2018-09-10 12:04:03", "Full Import failed": "2018-09-10
>> 12:04:04"
>>> } }
>>>
>>> On Mon, Sep 10, 2018 at 12:08 PM Andrea Gazzarini <a.gazzarini@sease.io>
>>> wrote:
>>>
>>>> Hi Monique,
>>>> I think you cannot attach files / images, please post, if available, the
>>>> url of the image or a text description.
>>>>
>>>> Andrea
>>>>
>>>> On 10/09/2018 17:05, Monique Monteiro wrote:
>>>>> Hi Andrea,
>>>>>
>>>>> Solr console doesn't return a very different information even with
>>>>> debug mode enabled:
>>>>>
>>>>> image.png
>>>>>
>>>>> On Mon, Sep 10, 2018 at 12:00 PM Andrea Gazzarini
>>>>> <a.gazzarini@sease.io <mailto:a.gazzarini@sease.io>> wrote:
>>>>>
>>>>>       You can check the solr.log or the solr-console.log. Another option
>>>>>       is to
>>>>>       activate the debug mode in the Solr console before running the
>>>>>       data import.
>>>>>
>>>>>       Andrea
>>>>>
>>>>>       On 10/09/2018 16:57, Monique Monteiro wrote:
>>>>>       > Hi all,
>>>>>       >
>>>>>       > I have a data import handler configured with an Oracle SQL
query
>>>>>       which
>>>>>       > works like a charm.  However, when I have the same query
>>>>>       configured in
>>>>>       > Solr's data import handler, nothing happens, and it returns:
>>>>>       >
>>>>>       >
>>>>>       >
>>>>>       >      "*Total Requests made to DataSource*": "1",
>>>>>       >
>>>>>       >      "*Total Rows Fetched*": "0",
>>>>>       >
>>>>>       >      "*Total Documents Processed*": "0",
>>>>>       >
>>>>>       >      "*Total Documents Skipped*": "0",
>>>>>       >
>>>>>       > "Full Dump Started": "2018-09-06 18:15:59", "Full Import
>>>>>       failed": "2018-09-06
>>>>>       > 18:16:02"
>>>>>       >
>>>>>       > Has anyone any ideas about what may be happening?  Is there
any
>>>>>       log file
>>>>>       > which can tell the error?
>>>>>       >
>>>>>       > Thanks in advance,
>>>>>       >
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Monique Monteiro
>>>>> Twitter: http://twitter.com/monilouise
>>


Mime
View raw message