Hi Andrea,
In fact, I had to add *logLevel="debug"* to the DIH configuration. Just
checking "Debug" on console is not enough. I also checked "Verbose". Now,
a database exception (locked account is shown).
Thanks!
Monique
On Mon, Sep 10, 2018 at 12:26 PM Andrea Gazzarini <a.gazzar...@sease.io>
wrote:
> 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
> >>
>
>
--
Monique Monteiro
Twitter: http://twitter.com/monilouise
