Hello,
IIRC, DIH UI has some kind of verbose or debug option, which provides
expanded trace of what's going on. Can't you try to check it?
On Tue, Mar 13, 2012 at 4:35 AM, Tim Hurring tim.hurr...@finzsoft.comwrote:
I'm new to SOLR and have managed to get some basic indexing and querying
working. However I haven't been able to successfully implement the indexing
of a parent child database relationship.
My db-data-config.xml is:
dataConfig
dataSource driver=com.ibm.as400.access.AS400JDBCDriver
url=jdbc:as400://FAB/SV95TNDTA;;naming=system; user=SV95TNGLB
password=GLOBAL95TN /
document
entity name=client query=SELECT #1ABCD, #1C8TX, #1AFTX, #1A7NA,
#1A8NA FROM REP
field column=#1ABCD name=id /
field column=#1C8TX name=surname /
field column=#1AFTX name=forenames /
field column=#1A7NA name=ird_number /
field column=#1A8NA name=gst_number /
entity name=idreference query=select M6ABR from ABM6CPP where
M6ABCD='${client.id}'
field column=M6ABR name=id_reference /
/entity
/entity
/document
/dataConfig
Most 'client' records will have one or more 'idreference' records. SOLR
seems to import the data successfully (see status below) but when I do a
*:*
search there are no 'id_reference' elements in any document (see below at
bottom):
response
lst name=responseHeader
int name=status0/int
int name=QTime0/int
/lst
lst name=initArgs
lst name=defaults
str name=configdb-data-config.xml/str
/lst
/lst
str name=commandstatus/str
str name=statusidle/str
str name=importResponse/
lst name=statusMessages
str name=Total Requests made to DataSource13594/str
str name=Total Rows Fetched13593/str
str name=Total Documents Skipped0/str
str name=Full Dump Started2012-03-13 13:15:07/str
str name=
Indexing completed. Added/Updated: 13593 documents. Deleted 0 documents.
/str
str name=Committed2012-03-13 13:15:36/str
str name=Optimized2012-03-13 13:15:36/str
str name=Total Documents Processed13593/str
str name=Time taken 0:0:29.804/str
/lst
str name=WARNING
This response format is experimental. It is likely to change in the future.
/str
/response
result name=response numFound=13593 start=0 maxScore=1.0
doc
float name=score1.0/float
str name=forenamesJohn David/str
str name=gst_number/str
str name=id012345/str
str name=ird_number/str
str name=surnameSagers/str
/doc
doc
float name=score1.0/float
str name=forenamesMark James/str
str name=gst_number/str
str name=id000426/str
str name=ird_number/str
str name=surnameKirby/str
/doc
...
Any assistance would be greatly appreciated.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Incomplete-documents-with-parent-child-DB-relationship-tp3820963p3820963.html
Sent from the Solr - User mailing list archive at Nabble.com.
--
Sincerely yours
Mikhail Khludnev
Lucid Certified
Apache Lucene/Solr Developer
Grid Dynamics
http://www.griddynamics.com
mkhlud...@griddynamics.com