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 KirstyS <ki...@gmail.com> on 2009/09/16 14:44:40 UTC
DeltaImport problem
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.
Re: DeltaImport problem
Posted by KirstyS <ki...@gmail.com>.
I got the build from 2009-09-12... :o(
Any ideas what is wrong or how to fix?
foamdino wrote:
>
> Hi,
>
>> 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?
>
> I have experienced the same issue with a build of solr-trunk (from
> about 2 months ago). The delta-import runs but the index doesn't seem
> to be updated - although the info suggests that the correct number of
> records have been indexed
>
> Kev
>
>
--
View this message in context: http://www.nabble.com/DeltaImport-problem-tp25471596p25488073.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: DeltaImport problem
Posted by Kevin Jackson <fo...@gmail.com>.
Hi,
> 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?
I have experienced the same issue with a build of solr-trunk (from
about 2 months ago). The delta-import runs but the index doesn't seem
to be updated - although the info suggests that the correct number of
records have been indexed
Kev
Re: DeltaImport problem
Posted by Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>.
check the logs and see if you have any messages like
Exception while adding ...
or
Error creating document :
2009/9/17 Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>:
> the status command is command=status
>
> 2009/9/17 Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>:
>> can you try the same command a commit=true ?
>>
>> On Thu, Sep 17, 2009 at 3:15 PM, KirstyS <ki...@gmail.com> wrote:
>>>
>>> No, I don't see any commit...
>>>
>>> I ran with this command
>>> http://localhost:8080/solr/dataimport?command=delta-import
>>> and these are the results
>>>
>>> <str name="command">delta-import</str>
>>> <str name="status">idle</str>
>>> <str name="importResponse"/>
>>> −
>>> <lst name="statusMessages">
>>> <str name="Total Requests made to DataSource">3</str>
>>> <str name="Total Rows Fetched">2</str>
>>> <str name="Total Documents Skipped">0</str>
>>> <str name="Delta Dump started">2009-09-17 11:42:14</str>
>>> <str name="Identifying Delta">2009-09-17 11:42:14</str>
>>> <str name="Deltas Obtained">2009-09-17 11:42:14</str>
>>> <str name="Building documents">2009-09-17 11:42:14</str>
>>> <str name="Total Changed Documents">2</str>
>>> <str name="Time taken ">0:0:0.172</str>
>>> </lst>
>>> −
>>> <str name="WARNING">
>>> This response format is experimental. It is likely to change in the future.
>>> </str>
>>>
>>> Is it not supposed to default to commit?
>>>
>>> Noble Paul നോബിള് नोब्ळ्-2 wrote:
>>>>
>>>> What does the status command say after delta-import? does it say
>>>> committed?
>>>>
>>>> On Thu, Sep 17, 2009 at 2:50 PM, KirstyS <ki...@gmail.com> wrote:
>>>>>
>>>>> 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 <ki...@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 <ki...@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 <ki...@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.
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> -----------------------------------------------------
>>>> Noble Paul | Principal Engineer| AOL | http://aol.com
>>>>
>>>>
>>>
>>> --
>>> View this message in context: http://www.nabble.com/DeltaImport-problem-tp25471596p25488209.html
>>> Sent from the Solr - User mailing list archive at Nabble.com.
>>>
>>>
>>
>>
>>
>> --
>> -----------------------------------------------------
>> Noble Paul | Principal Engineer| AOL | http://aol.com
>>
>
>
>
> --
> -----------------------------------------------------
> Noble Paul | Principal Engineer| AOL | http://aol.com
>
--
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com
Re: DeltaImport problem
Posted by Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>.
the status command is command=status
2009/9/17 Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>:
> can you try the same command a commit=true ?
>
> On Thu, Sep 17, 2009 at 3:15 PM, KirstyS <ki...@gmail.com> wrote:
>>
>> No, I don't see any commit...
>>
>> I ran with this command
>> http://localhost:8080/solr/dataimport?command=delta-import
>> and these are the results
>>
>> <str name="command">delta-import</str>
>> <str name="status">idle</str>
>> <str name="importResponse"/>
>> −
>> <lst name="statusMessages">
>> <str name="Total Requests made to DataSource">3</str>
>> <str name="Total Rows Fetched">2</str>
>> <str name="Total Documents Skipped">0</str>
>> <str name="Delta Dump started">2009-09-17 11:42:14</str>
>> <str name="Identifying Delta">2009-09-17 11:42:14</str>
>> <str name="Deltas Obtained">2009-09-17 11:42:14</str>
>> <str name="Building documents">2009-09-17 11:42:14</str>
>> <str name="Total Changed Documents">2</str>
>> <str name="Time taken ">0:0:0.172</str>
>> </lst>
>> −
>> <str name="WARNING">
>> This response format is experimental. It is likely to change in the future.
>> </str>
>>
>> Is it not supposed to default to commit?
>>
>> Noble Paul നോബിള് नोब्ळ्-2 wrote:
>>>
>>> What does the status command say after delta-import? does it say
>>> committed?
>>>
>>> On Thu, Sep 17, 2009 at 2:50 PM, KirstyS <ki...@gmail.com> wrote:
>>>>
>>>> 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 <ki...@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 <ki...@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 <ki...@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.
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> -----------------------------------------------------
>>> Noble Paul | Principal Engineer| AOL | http://aol.com
>>>
>>>
>>
>> --
>> View this message in context: http://www.nabble.com/DeltaImport-problem-tp25471596p25488209.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>
>
>
> --
> -----------------------------------------------------
> Noble Paul | Principal Engineer| AOL | http://aol.com
>
--
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com
Re: DeltaImport problem
Posted by KirstyS <ki...@gmail.com>.
It seems my deltaImportQuery was incorrect. I am now getting the documents
indexed.
thanks so much for helping!
KirstyS wrote:
>
> same response ..
> <str name="command">delta-import</str>
> <str name="status">idle</str>
> <str name="importResponse"/>
> −
> <lst name="statusMessages">
> <str name="Total Requests made to DataSource">3</str>
> <str name="Total Rows Fetched">2</str>
> <str name="Total Documents Skipped">0</str>
> <str name="Delta Dump started">2009-09-17 11:58:13</str>
> <str name="Identifying Delta">2009-09-17 11:58:13</str>
> <str name="Deltas Obtained">2009-09-17 11:58:13</str>
> <str name="Building documents">2009-09-17 11:58:13</str>
> <str name="Total Changed Documents">2</str>
> <str name="Time taken ">0:0:0.156</str>
>
> used
> http://localhost:8080/solr/dataimport?command=delta-import&commit=true
>
>
>
> Noble Paul നോബിള് नोब्ळ्-2 wrote:
>>
>> can you try the same command a commit=true ?
>>
>> On Thu, Sep 17, 2009 at 3:15 PM, KirstyS <ki...@gmail.com> wrote:
>>>
>>> No, I don't see any commit...
>>>
>>> I ran with this command
>>> http://localhost:8080/solr/dataimport?command=delta-import
>>> and these are the results
>>>
>>> <str name="command">delta-import</str>
>>> <str name="status">idle</str>
>>> <str name="importResponse"/>
>>> −
>>> <lst name="statusMessages">
>>> <str name="Total Requests made to DataSource">3</str>
>>> <str name="Total Rows Fetched">2</str>
>>> <str name="Total Documents Skipped">0</str>
>>> <str name="Delta Dump started">2009-09-17 11:42:14</str>
>>> <str name="Identifying Delta">2009-09-17 11:42:14</str>
>>> <str name="Deltas Obtained">2009-09-17 11:42:14</str>
>>> <str name="Building documents">2009-09-17 11:42:14</str>
>>> <str name="Total Changed Documents">2</str>
>>> <str name="Time taken ">0:0:0.172</str>
>>> </lst>
>>> −
>>> <str name="WARNING">
>>> This response format is experimental. It is likely to change in the
>>> future.
>>> </str>
>>>
>>> Is it not supposed to default to commit?
>>>
>>> Noble Paul നോബിള് नोब्ळ्-2 wrote:
>>>>
>>>> What does the status command say after delta-import? does it say
>>>> committed?
>>>>
>>>> On Thu, Sep 17, 2009 at 2:50 PM, KirstyS <ki...@gmail.com> wrote:
>>>>>
>>>>> 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 <ki...@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 <ki...@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 <ki...@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.
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> -----------------------------------------------------
>>>> Noble Paul | Principal Engineer| AOL | http://aol.com
>>>>
>>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/DeltaImport-problem-tp25471596p25488209.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-tp25471596p25489111.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: DeltaImport problem
Posted by KirstyS <ki...@gmail.com>.
same response ..
<str name="command">delta-import</str>
<str name="status">idle</str>
<str name="importResponse"/>
−
<lst name="statusMessages">
<str name="Total Requests made to DataSource">3</str>
<str name="Total Rows Fetched">2</str>
<str name="Total Documents Skipped">0</str>
<str name="Delta Dump started">2009-09-17 11:58:13</str>
<str name="Identifying Delta">2009-09-17 11:58:13</str>
<str name="Deltas Obtained">2009-09-17 11:58:13</str>
<str name="Building documents">2009-09-17 11:58:13</str>
<str name="Total Changed Documents">2</str>
<str name="Time taken ">0:0:0.156</str>
used http://localhost:8080/solr/dataimport?command=delta-import&commit=true
Noble Paul നോബിള് नोब्ळ्-2 wrote:
>
> can you try the same command a commit=true ?
>
> On Thu, Sep 17, 2009 at 3:15 PM, KirstyS <ki...@gmail.com> wrote:
>>
>> No, I don't see any commit...
>>
>> I ran with this command
>> http://localhost:8080/solr/dataimport?command=delta-import
>> and these are the results
>>
>> <str name="command">delta-import</str>
>> <str name="status">idle</str>
>> <str name="importResponse"/>
>> −
>> <lst name="statusMessages">
>> <str name="Total Requests made to DataSource">3</str>
>> <str name="Total Rows Fetched">2</str>
>> <str name="Total Documents Skipped">0</str>
>> <str name="Delta Dump started">2009-09-17 11:42:14</str>
>> <str name="Identifying Delta">2009-09-17 11:42:14</str>
>> <str name="Deltas Obtained">2009-09-17 11:42:14</str>
>> <str name="Building documents">2009-09-17 11:42:14</str>
>> <str name="Total Changed Documents">2</str>
>> <str name="Time taken ">0:0:0.172</str>
>> </lst>
>> −
>> <str name="WARNING">
>> This response format is experimental. It is likely to change in the
>> future.
>> </str>
>>
>> Is it not supposed to default to commit?
>>
>> Noble Paul നോബിള് नोब्ळ्-2 wrote:
>>>
>>> What does the status command say after delta-import? does it say
>>> committed?
>>>
>>> On Thu, Sep 17, 2009 at 2:50 PM, KirstyS <ki...@gmail.com> wrote:
>>>>
>>>> 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 <ki...@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 <ki...@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 <ki...@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.
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> -----------------------------------------------------
>>> Noble Paul | Principal Engineer| AOL | http://aol.com
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/DeltaImport-problem-tp25471596p25488209.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-tp25471596p25488365.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: DeltaImport problem
Posted by Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>.
can you try the same command a commit=true ?
On Thu, Sep 17, 2009 at 3:15 PM, KirstyS <ki...@gmail.com> wrote:
>
> No, I don't see any commit...
>
> I ran with this command
> http://localhost:8080/solr/dataimport?command=delta-import
> and these are the results
>
> <str name="command">delta-import</str>
> <str name="status">idle</str>
> <str name="importResponse"/>
> −
> <lst name="statusMessages">
> <str name="Total Requests made to DataSource">3</str>
> <str name="Total Rows Fetched">2</str>
> <str name="Total Documents Skipped">0</str>
> <str name="Delta Dump started">2009-09-17 11:42:14</str>
> <str name="Identifying Delta">2009-09-17 11:42:14</str>
> <str name="Deltas Obtained">2009-09-17 11:42:14</str>
> <str name="Building documents">2009-09-17 11:42:14</str>
> <str name="Total Changed Documents">2</str>
> <str name="Time taken ">0:0:0.172</str>
> </lst>
> −
> <str name="WARNING">
> This response format is experimental. It is likely to change in the future.
> </str>
>
> Is it not supposed to default to commit?
>
> Noble Paul നോബിള് नोब्ळ्-2 wrote:
>>
>> What does the status command say after delta-import? does it say
>> committed?
>>
>> On Thu, Sep 17, 2009 at 2:50 PM, KirstyS <ki...@gmail.com> wrote:
>>>
>>> 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 <ki...@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 <ki...@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 <ki...@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.
>>>
>>>
>>
>>
>>
>> --
>> -----------------------------------------------------
>> Noble Paul | Principal Engineer| AOL | http://aol.com
>>
>>
>
> --
> View this message in context: http://www.nabble.com/DeltaImport-problem-tp25471596p25488209.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
--
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com
Re: DeltaImport problem
Posted by KirstyS <ki...@gmail.com>.
No, I don't see any commit...
I ran with this command
http://localhost:8080/solr/dataimport?command=delta-import
and these are the results
<str name="command">delta-import</str>
<str name="status">idle</str>
<str name="importResponse"/>
−
<lst name="statusMessages">
<str name="Total Requests made to DataSource">3</str>
<str name="Total Rows Fetched">2</str>
<str name="Total Documents Skipped">0</str>
<str name="Delta Dump started">2009-09-17 11:42:14</str>
<str name="Identifying Delta">2009-09-17 11:42:14</str>
<str name="Deltas Obtained">2009-09-17 11:42:14</str>
<str name="Building documents">2009-09-17 11:42:14</str>
<str name="Total Changed Documents">2</str>
<str name="Time taken ">0:0:0.172</str>
</lst>
−
<str name="WARNING">
This response format is experimental. It is likely to change in the future.
</str>
Is it not supposed to default to commit?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
>
> What does the status command say after delta-import? does it say
> committed?
>
> On Thu, Sep 17, 2009 at 2:50 PM, KirstyS <ki...@gmail.com> wrote:
>>
>> 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 <ki...@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 <ki...@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 <ki...@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.
>>
>>
>
>
>
> --
> -----------------------------------------------------
> Noble Paul | Principal Engineer| AOL | http://aol.com
>
>
--
View this message in context: http://www.nabble.com/DeltaImport-problem-tp25471596p25488209.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: DeltaImport problem
Posted by Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>.
What does the status command say after delta-import? does it say committed?
On Thu, Sep 17, 2009 at 2:50 PM, KirstyS <ki...@gmail.com> wrote:
>
> 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 <ki...@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 <ki...@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 <ki...@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.
>
>
--
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com
Re: DeltaImport problem
Posted by KirstyS <ki...@gmail.com>.
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 <ki...@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 <ki...@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 <ki...@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.
Re: DeltaImport problem
Posted by Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>.
http://people.apache.org/builds/lucene/solr/nightly/
On Wed, Sep 16, 2009 at 6:42 PM, KirstyS <ki...@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 <ki...@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 <ki...@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
Re: DeltaImport problem
Posted by KirstyS <ki...@gmail.com>.
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 <ki...@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 <ki...@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.
Re: DeltaImport problem
Posted by Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>.
yeah, not yet released but going to be released pretty soon
On Wed, Sep 16, 2009 at 6:32 PM, KirstyS <ki...@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 <ki...@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
Re: DeltaImport problem
Posted by KirstyS <ki...@gmail.com>.
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 <ki...@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.
Re: DeltaImport problem
Posted by Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>.
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 <ki...@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