You very often get _much_ more detail in the Solr log rather than the
admin UI BTW....
On Mon, Sep 10, 2018 at 8:50 AM Monique Monteiro
<monique.lou...@gmail.com> wrote:
>
> 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
