this comment says that <str name="Total Rows Fetched">7</str>
the query fetched only 7 rows. If possible open a tool and just run the same query and see how many rows are returned On Wed, Aug 19, 2009 at 3:46 AM, Erik Earle<erikea...@yahoo.com> wrote: > Using: > - apache-solr-1.3.0 > - java 1.6 > - tomcat 6 > - sql server 2005 w/ JSQLConnect 4.0 driver > > I have a group table with 3007 rows. I have confirmed the key is > unique with "select distinct id from group" and it returns 3007. When i > re-index using http://host:port/solr/dataimport?command=full-import I only > get 7 records indexed. Any insight into what is going on would be really > great. > > A partial response: > <lst name="statusMessages"> > <str name="Total Requests made to DataSource">1</str> > <str name="Total Rows Fetched">7</str> > <str name="Total Documents Skipped">0</str> > > > I have other entities that index all the rows without issue. > > There are no errors in the logs. > > I am not using any Transformers (and most of my config is not changed from > install) > > My schema.xml contains: > > <uniqueKey>key</uniqueKey> > > and field defs (not a full list of fields): > <field name="key" type="string" indexed="true" stored="true" > required="true" /> > <field name="class" type="string" indexed="true" stored="true" > required="true" /> > <field name="id" type="string" indexed="true" stored="true" /> > <field name="description" type="text" indexed="true" stored="true" /> > <field name="created" type="date" indexed="true" stored="true" /> > <field name="updated" type="date" indexed="true" stored="true" /> > > data-config.xml > ################ > <dataConfig> > <!-- > jdbc:JSQLConnect://se-eriearle-lt1/database=SocialSite2/user=SocialSite2/logfile=DB_TRACE.log > --> > <dataSource type="JdbcDataSource" > driver="com.jnetdirect.jsql.JSQLDriver" > > url="jdbc:JSQLConnect://se-eriearle-lt1/database=SocialSite2/user=SocialSite2" > user="SocialSite2" > password="SocialSite2" /> > > <document> > > .... > > <entity name="Group" pk="key" > query="select 'group.'+id as 'key', 'group' as 'class', name, > handle, description, created, updated from group order by created asc"> > </entity> > > <entity name="Message" pk="key" > query="<...redacted...>"> > </entity> > > </document> > </dataConfig> > > > > -- ----------------------------------------------------- Noble Paul | Principal Engineer| AOL | http://aol.com
