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 Ben McCarthy <be...@gmail.com> on 2011/12/08 15:01:44 UTC

Data Import Handler Delta Import and Debug Mode Help

Good Afternoon,



Im looking at Deltas via a DeltaImportHandler.  I was running Solr 1.4.1
but just upgraded to 3.5.  Previously I was able to run debug and verbose
from:



http://localhost:8080/solr/admin/dataimport.jsp?handler=/advert



But since upgrading when choosing these options the right panel does not
populate with anything.  Am I missing something when i upgraded as I copied
all relevant jars to my classpath.


This is proving a problem as im trying to debug why my delta import is not
picking up any records:



  <entity name="Stock"

                                  pk="ID"

                                  query="select * from stock_item s join
advert_detail a on a.stock_item_id=s.id where
a.Destination='ConsumerWebsite'"

                                  deltaImportQuery="select * from
stock_item s join advert_detail a on a.stock_item_id=s.id where
a.Destination='foo' and s.id='${dataimporter.delta.ID}'"

                                  deltaQuery="select s.ID from stock_item s
where s.last_updated &gt;
to_date('${dataimporter.last_index_time}','YYYY-MM-DD hh24:mm:ss')"

                                  dataSource="pos_ds">





The entity does have two nested entitys with in it.



When I run the query for the delta on the DB I get back the expected 100
stock id’s





Any help would be appreciated.



Thanks

Ben