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 (< >)
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.gazzar...@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.gazzar...@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.gazzar...@sease.io <mailto:a.gazzar...@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
