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.com>wrote: > 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 AAAAREP"> > <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="status">0</int> > <int name="QTime">0</int> > </lst> > <lst name="initArgs"> > <lst name="defaults"> > <str name="config">db-data-config.xml</str> > </lst> > </lst> > <str name="command">status</str> > <str name="status">idle</str> > <str name="importResponse"/> > <lst name="statusMessages"> > <str name="Total Requests made to DataSource">13594</str> > <str name="Total Rows Fetched">13593</str> > <str name="Total Documents Skipped">0</str> > <str name="Full Dump Started">2012-03-13 13:15:07</str> > <str name=""> > Indexing completed. Added/Updated: 13593 documents. Deleted 0 documents. > </str> > <str name="Committed">2012-03-13 13:15:36</str> > <str name="Optimized">2012-03-13 13:15:36</str> > <str name="Total Documents Processed">13593</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="score">1.0</float> > <str name="forenames">John David</str> > <str name="gst_number"></str> > <str name="id">0000012345</str> > <str name="ird_number">000000000000</str> > <str name="surname">Sagers</str> > </doc> > <doc> > <float name="score">1.0</float> > <str name="forenames">Mark James</str> > <str name="gst_number"></str> > <str name="id">0000000426</str> > <str name="ird_number"></str> > <str name="surname">Kirby</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>