You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Monique Monteiro <mo...@gmail.com> on 2018/09/10 14:57:25 UTC
Silent error from DataImportHandler
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
Re: Silent error from DataImportHandler
Posted by Walter Underwood <wu...@wunderwood.org>.
Copy and paste the text of the error. Pictures of text aren’t very useful, even when
they do make it through the mail reflector.
Also, expand the error (the small info button) to get a stack trace.
wunder
Walter Underwood
wunder@wunderwood.org
http://observer.wunderwood.org/ (my blog)
> On Sep 10, 2018, at 8:05 AM, Monique Monteiro <mo...@gmail.com> wrote:
>
> Hi Andrea,
>
> Solr console doesn't return a very different information even with debug mode enabled:
>
>
>
> On Mon, Sep 10, 2018 at 12:00 PM Andrea Gazzarini <a.gazzarini@sease.io <ma...@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 <http://twitter.com/monilouise>
Re: Silent error from DataImportHandler
Posted by Erick Erickson <er...@gmail.com>.
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
<mo...@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....@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....@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 <ma...@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
Re: Silent error from DataImportHandler
Posted by Monique Monteiro <mo...@gmail.com>.
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....@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....@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 <ma...@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
Re: Silent error from DataImportHandler
Posted by Andrea Gazzarini <a....@sease.io>.
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....@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....@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 <ma...@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
>>
Re: Silent error from DataImportHandler
Posted by Monique Monteiro <mo...@gmail.com>.
This is shown in the section "Raw Debug-Response".
On Mon, Sep 10, 2018 at 12:20 PM Andrea Gazzarini <a....@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....@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 <ma...@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
Re: Silent error from DataImportHandler
Posted by Andrea Gazzarini <a....@sease.io>.
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....@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 <ma...@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
>>
Re: Silent error from DataImportHandler
Posted by Monique Monteiro <mo...@gmail.com>.
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....@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 <ma...@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
Re: Silent error from DataImportHandler
Posted by Andrea Gazzarini <a....@sease.io>.
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 <ma...@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
Re: Silent error from DataImportHandler
Posted by Monique Monteiro <mo...@gmail.com>.
Hi Andrea,
Solr console doesn't return a very different information even with debug
mode enabled:
[image: image.png]
On Mon, Sep 10, 2018 at 12:00 PM Andrea Gazzarini <a....@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
Re: Silent error from DataImportHandler
Posted by Andrea Gazzarini <a....@sease.io>.
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,
>