Hi! thanks so much, I have the latest release. Now, it shows that the delta import is successful but when I query for the updated article I am expecting, it has not updated. It's like the index is not being updated with the changes...Any ideas? thanks Kirsty
Noble Paul നോബിള് नोब्ळ्-2 wrote: > > http://people.apache.org/builds/lucene/solr/nightly/ > > On Wed, Sep 16, 2009 at 6:42 PM, KirstyS <kirst...@gmail.com> wrote: >> >> mmm..can't seem to find the link..could you help? >> >> >> Noble Paul നോബിള് नोब्ळ्-2 wrote: >>> >>> yeah, not yet released but going to be released pretty soon >>> >>> On Wed, Sep 16, 2009 at 6:32 PM, KirstyS <kirst...@gmail.com> wrote: >>>> >>>> I thought 1.4 was not released yet? >>>> >>>> >>>> Noble Paul നോബിള് नोब्ळ्-2 wrote: >>>>> >>>>> I vaguely remember there was an issue with delta-import in 1.3. could >>>>> you try it out with Solr1.4 >>>>> >>>>> On Wed, Sep 16, 2009 at 6:14 PM, KirstyS <kirst...@gmail.com> wrote: >>>>>> >>>>>> I hope this is the correct place to post this issue and if so, that >>>>>> someone >>>>>> can help. >>>>>> I am using the DIH with Solr 1.3 >>>>>> My data-config.xml file looks like this: >>>>>> <dataSource >>>>>> driver="net.sourceforge.jtds.jdbc.Driver" >>>>>> url="jdbc:jtds:sqlserver:{taken out for posting} >>>>>> user={taken out for posting} >>>>>> password={taken out for posting} /> >>>>>> >>>>>> <entity name="article" pk="CmsArticleId" >>>>>> query="Select a.CmsArticleId, a.CreatorId , LastUpdatedBy, >>>>>> LastUpdateDate, Title, Synopsis, Author, Source, IsPublished, >>>>>> ArticleTypeId, >>>>>> a.StrapHead, ShortHeading, HomePageBlurb, >>>>>> ByLine, >>>>>> ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank, >>>>>> c.CategoryId, AncestralName, CategoryName, >>>>>> CategoryDisplayName, ParentCategoryId, c.SiteId >>>>>> from Category c (nolock) >>>>>> inner join CmsArticleCollection ac (nolock) on >>>>>> c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId >>>>>> inner join CmsArticleArticleCollection aac >>>>>> (nolock) >>>>>> on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId >>>>>> inner join CmsArticle a (nolock) on >>>>>> aac.CmsArticleId >>>>>> = a.CmsArticleId >>>>>> where (a.LiveEdit is null or a.LiveEdit = 0) >>>>>> and aac.SourceCmsArticleArticleCollectionId >>>>>> is >>>>>> null" >>>>>> deltaQuery="Select a.CmsArticleId, a.CreatorId , >>>>>> LastUpdatedBy, >>>>>> LastUpdateDate, Title, Synopsis, Author, Source, IsPublished, >>>>>> ArticleTypeId, >>>>>> a.StrapHead, ShortHeading, HomePageBlurb, >>>>>> ByLine, >>>>>> ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank, >>>>>> c.CategoryId, AncestralName, CategoryName, >>>>>> CategoryDisplayName, ParentCategoryId, c.SiteId >>>>>> from Category c (nolock) >>>>>> inner join CmsArticleCollection ac (nolock) on >>>>>> c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId >>>>>> inner join CmsArticleArticleCollection aac >>>>>> (nolock) >>>>>> on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId >>>>>> inner join CmsArticle a (nolock) on >>>>>> aac.CmsArticleId >>>>>> = a.CmsArticleId >>>>>> where (a.LiveEdit is null or a.LiveEdit = 0) >>>>>> and aac.SourceCmsArticleArticleCollectionId >>>>>> is >>>>>> null >>>>>> and (LastUpdateDate > >>>>>> '${dataimporter.last_index_time}' >>>>>> OR a.CreationDate > '${dataimporter.last_index_time}')" > >>>>>> >>>>>> Have tried casting the dataimporter.last_index_time and the other >>>>>> date >>>>>> fields. To no avail. My Full Import works perfectly but I cannot get >>>>>> the >>>>>> command=delta-import to pick up the updated records. The >>>>>> LastUpdateDate >>>>>> is >>>>>> being updated. When I run this in the debug interface with >>>>>> delta-import >>>>>> it >>>>>> just never calls the delta import. >>>>>> Please, if anyone knows what I am doing wrong??? >>>>>> Many thanks >>>>>> Kirsty >>>>>> -- >>>>>> View this message in context: >>>>>> http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.html >>>>>> Sent from the Solr - User mailing list archive at Nabble.com. >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> ----------------------------------------------------- >>>>> Noble Paul | Principal Engineer| AOL | http://aol.com >>>>> >>>>> >>>> >>>> -- >>>> View this message in context: >>>> http://www.nabble.com/DeltaImport-problem-tp25471596p25471927.html >>>> Sent from the Solr - User mailing list archive at Nabble.com. >>>> >>>> >>> >>> >>> >>> -- >>> ----------------------------------------------------- >>> Noble Paul | Principal Engineer| AOL | http://aol.com >>> >>> >> >> -- >> View this message in context: >> http://www.nabble.com/DeltaImport-problem-tp25471596p25472102.html >> Sent from the Solr - User mailing list archive at Nabble.com. >> >> > > > > -- > ----------------------------------------------------- > Noble Paul | Principal Engineer| AOL | http://aol.com > > -- View this message in context: http://www.nabble.com/DeltaImport-problem-tp25471596p25487855.html Sent from the Solr - User mailing list archive at Nabble.com.